Our CTO wrote an article about partitioning in PostgreSQL. Check it out to see how to maximize your performance and learn all the best practices around. https://www.metisdata.io/blog/partitioning-made-easy-in-postgresql