Dynamic table splitting in postgres

Question

I was looking for ways to publish postgres partition data to tables based on a timestamp, for example, without having to add the appropriate child tables manually. I saw this blog post that does just that.

https://blog.engineyard.com/2013/scaling-postgresql-performance-table-partitioning

but I doubt the idea of ​​creating tables based on string concatenation and pg_catalog validation. Is that a reasonable idea?

Answer 1

pg_partman is an extension designed specifically to manage the complexity of managing partitions. I did not use this extension, but I used other authors of the same author, and they usually have excellent quality.