Dynamic table partitioning in postgres

Question

I was looking up ways to have postgres partition data into tables based on timestamp for example, but without having to add the relevant child tables manually. I saw this blog post that does just that

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

but I'm dubious about the idea of creating tables based on string concatenation and checking the pg_catalog. Is this a reasonable idea?

bma · Accepted Answer · 2013-07-18 21:59:43Z

8

pg_partman is an extension created specifically to manage the complexity of partition management. I haven't used this extension, but I've used others by the same author and they are generally of excellent quality.

answered Jul 18, 2013 at 21:59

bma

9,8362 gold badges35 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Krusty the Clown Over a year ago

no longer supported unfortunately

Collectives™ on Stack Overflow

Dynamic table partitioning in postgres

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related