Joshua D. Drake wrote: > On Thu, 2009-02-05 at 17:08 -0500, Tom Lane wrote: >> My feeling is that we should be trying to eliminate use-cases for >> cron-driven vacuuming, not trying to make sure that cron-driven >> scripts can do anything autovacuum can. > Agreed. IMO, the user should only have to think about "vacuum" in an > abstract sense.
+1 >> The main remaining use-case seems to me to make vacuuming work adhere >> to some business-determined schedule, hence maintenance windows seem >> like the next thing to do. > Also agreed. Somewhat agreed - since in many cases the business-determined schedule is just a rough estimate of measurable attributes of the machine. When we say "vacuum between midnight and 5am" we often actually mean "vacuum when the I/O subsystem has bandwidth to spare and the machine's otherwise lightly loaded, and we guess that means late at night". -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers