On Wed, Jun 27, 2012 at 7:00 PM, Josh Berkus <j...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
