On 7/27/20 5:19 PM, Keith Fiske wrote: [snip]
Also, I would not recommend partitioning simply to improve vacuuming. Especially if extensive tuning hasn't been tried first. Most times you can get per-table tuning working well enough to get autovacuum running properly. Especially on 9.6 and even more-so on PG11, where autovacuum has itself been improved.
SIMPLY to improve vacuum performance? No. But there are reasons that partitioning was "invented", and minimizing the work needed to be done on the whole of a Very Large and Rapidly Growing table is one of them.
-- Angular momentum makes the world go 'round.
