Re: We probably need autovacuum_max_wraparound_workers - Mailing list pgsql-hackers

From Daniel Farina
Subject Re: We probably need autovacuum_max_wraparound_workers
Date
Msg-id CAAZKuFZT_GhazRyw7=K28mOEe79n8CitwRG0z0QYciHcQ1S7gg@mail.gmail.com
Whole thread Raw
In response to We probably need autovacuum_max_wraparound_workers  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
On Wed, Jun 27, 2012 at 7:00 PM, Josh Berkus <josh@agliodbs.com> wrote:
> I've seen this at two sites now, and my conclusion is that a single
> autovacuum_max_workers isn't sufficient if to cover the case of
> wraparound vacuum.  Nor can we just single-thread the wraparound vacuum
> (i.e. just one worker) since that would hurt users who have thousands of
> small tables.

I have also witnessed very unfortunate un-smooth performance behavior
around wraparound time. It seems like a bit of adaptive response in
terms of allowed autovacuum throughput to number of pages requiring
wraparound vacuuming would be one load off my mind.  Getting slower
and slower gradually with some way to know that autovacuum has decided
it should work harder and harder is better than the brick wall that
can sneak up currently.

Count me as appreciative for improvements in this area.

-- 
fdr


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Uh, I change my mind about commit_delay + commit_siblings (sort of)
Next
From: Daniel Farina
Date:
Subject: Re: pg_signal_backend() asymmetry