All Questions
3 questions
0
votes
1
answer
125
views
Citus - Possible to undo citus's create_time_partitions results?
I'm working on a database with Citus and I would like to know if it's possible to undo the results made by executing create_time_partitions. I know that it is possible to "undistribute" a ...
- 132
0
votes
0
answers
803
views
PostgreSQL How to Switch/Exchange Partition?
I have been working on MSSQL and i am using Alter table switch partition command on MSSQL in some of my procedures.
How can i achive the same results on PostgreSQL with good performance?
Is there ...
1
vote
1
answer
3k
views
How do I partition table over two columns?
Table T1 has cols - app_id,start_time,end_time,value.
We have multiple applications and would like to partition tables by app_id and start_time (weekly partitions).
This is how the child partitions ...
- 1,094