Horton

Re: Autovacuum Improvements

Scott Ribe <scott_ribe@killerbytes.com>

View thread
From: Scott Ribe <scott_ribe@killerbytes.com>
To: Alvaro Herrera <alvherre@commandprompt.com>, Postgres general mailing list <pgsql-general@postgresql.org>
Date: 2006-12-21T17:41:24Z
Lists: pgsql-hackers 
> I intend to work on the maintenance window idea for 8.3.  I'm not sure
> if I'll be able to introduce the worker process stuff in there as well.
> I actually haven't done much design on the stuff so I can't say.

Something to consider, per-day maintenance windows, where Sat & Sun could
have 24-hour window, and trying to vacuum largest tables during longest
windows. This wouldn't work for every server, but for many...

-- 
Scott Ribe
scott_ribe@killerbytes.com
http://www.killerbytes.com/
(303) 722-0567 voice