Re: How can i be certain autovacuum is causing reuse if table still grows

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.