[SOLAR_FIELDS]

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]

is there a chance you run some older version of PG? They reduced bloating significantly in last few releases.

[SOLAR_FIELDS]

Yes! 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]

If 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/