-
|
Hi! I'm currently in the process of migrating a database containing large (and rapidly growing) amounts of historical records, partitioned monthly by timestamps. These records are primarily from the last 2 years, but the dataset spans from as far back as 2010. Because the records from before 2023 are few and far between, I figured I'd manually create a single partition for those records and allow partman to manage the rest. My question is: is this a supported use case, and will partman like the presence of a manually created partition outside of its configured interval? |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment 1 reply
-
|
If you do not enable any retention options, pg_partman does not care anything about older partitions. So you can feel free to rebuild them as you see fit to maintain whichever older intervals that you'd like. If you do enable retention, I honestly have not tested it when you don't have a different interval than is configured, so I can't say what would happen. |
Beta Was this translation helpful? Give feedback.
-
|
Good to know! I don't need automatic retention management for this particular configuration, so it works out. Thank you for such a speedy answer and this tremendously useful extension! |
Beta Was this translation helpful? Give feedback.
If you do not enable any retention options, pg_partman does not care anything about older partitions. So you can feel free to rebuild them as you see fit to maintain whichever older intervals that you'd like.
If you do enable retention, I honestly have not tested it when you don't have a different interval than is configured, so I can't say what would happen.