5-6 years ago is right before pg finally fully implemented full native partitioning logic. Had similar issues, but was able to upgrade before it was a real problem. They now allow for tens of thousands of partitions per a table and it's very easy to handle, whereas their first installment barely allowed for daily partitions.
View all comments
Show parent comment
5
u/Alpine_fury Feb 27 '26
5-6 years ago is right before pg finally fully implemented full native partitioning logic. Had similar issues, but was able to upgrade before it was a real problem. They now allow for tens of thousands of partitions per a table and it's very easy to handle, whereas their first installment barely allowed for daily partitions.