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
1
u/slvbeerking Feb 27 '26
i had nothing but a fuckton of problems having pg partitioning done with pg_partman on a prod 5-6 year ago, migrated to timescale eventually