Postgres list dynamic partitioning

Question

I'm trying to make dynamic partitions in Postgres. What am I trying to achieve: I will have tableA that will have a lot of data and will have a column with some_id which will be heavily used in where statement. So, my plan is to have partition by list with some_id value. How to achieve dynamic partitioning, So when new id is inserted partition is dynamically created?

Laurenz Albe · Accepted Answer · 2021-03-11 14:19:56Z

1

There is no way to do that in PostgreSQL currently.

answered Mar 11, 2021 at 14:19

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

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

2 Comments

shonster88 Over a year ago

Thanks. What about a bit hardcoding with trigger? Would that be considered as good practice?

Laurenz Albe Over a year ago

I tried, and it doesn't work. Basically, a trigger that is run from an action on a table cannot modify the table's definition.

shonster88 · Accepted Answer · 2021-04-15 15:56:23Z

0

The best possible way to do it currently is through code. Since trigger cannot change table definition the best approach would be to do execute a statement after through a backend after insert.

answered Apr 15, 2021 at 15:56

shonster88

8411 bronze badges

Collectives™ on Stack Overflow

Postgres list dynamic partitioning

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related