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

From Stephen Frost
Subject Re: We probably need autovacuum_max_wraparound_workers
Date
Msg-id 20120628022900.GQ1267@tamriel.snowman.net
Whole thread Raw
In response to We probably need autovacuum_max_wraparound_workers  (Josh Berkus <josh@agliodbs.com>)
Responses Re: We probably need autovacuum_max_wraparound_workers
List pgsql-hackers
Josh, all,

* Josh Berkus (josh@agliodbs.com) wrote:
> Yeah, I can't believe I'm calling for *yet another* configuration
> variable either.  Suggested workaround fixes very welcome.

As I suggested on IRC, my thought would be to have a goal-based system
for autovacuum which is similar to our goal-based commit system.  We
don't need autovacuum sucking up all the I/O in the box, nor should we
ask the users to manage that.  Instead, let's decide when the autovacuum
on a given table needs to finish and then plan to keep on working at a
rate that'll allow us to get done well in advance of that deadline.

Just my 2c.
Thanks,
    Stephen

pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: We probably need autovacuum_max_wraparound_workers
Next
From: Tom Lane
Date:
Subject: Re: Server crash while trying to fetch EXPLAIN query results with a cursor