3 ms·
I recently did some db maintenance on a write heavy workload and I found that eventually it will bloat over time with a table with 500 million records. Switchin
by SOLAR_FIELDS 3y ago
I recently did some db maintenance on a write heavy workload and I found that eventually it will bloat over time with a table with 500 million records. Switching it to use a proper partitioning scheme helped a lot. So people should not read this and assume you can just dump massive workloads into pg and they will be screamingly performant without some tuning and thoughtful design (I don’t think this is what you are implying, just a PSA)
- riku_iki 3y agois there a chance you run some older version of PG? They reduced bloating significantly in last few releases.
- SOLAR_FIELDS 3y agoYes! PG12 in this case. Thanks, this definitely motivates my inflight project to get these db’s up to PG16. Very happy to hear that
- wlll 3y agoIf you need more motivation check out the feature matrix, there have been a fair number of pretty big advances since 12. https://www.postgresql.org/about/featurematrix/ https://www.postgresql.org/about/featurematrix/