Horton

Re: [HACKERS] What can we learn from MySQL?

Matthew T. O'Connor <matthew@zeut.net>

View thread
From: "Matthew T. O'Connor" <matthew@zeut.net>
To: pg@fastcrypt.com
Cc: "Matthew T. O'Connor" <matthew@zeut.net>, "Fabien COELHO" <coelho@cri.ensmp.fr>, "Bruce Momjian" <pgman@candle.pha.pa.us>, "PostgreSQL-development" <pgsql-hackers@postgresql.org>, "PostgreSQL advocacy" <pgsql-advocacy@postgresql.org>
Date: 2004-04-23T15:52:14Z
Lists: pgsql-hackers 
> Does the current implementation of pg_autovacuum have a way of setting
> windows where it is allowed to vacuum? Many large 24/7 will only allow
> vacuumming at certain times of the day.

No the current implementation doesn't, but such a feature is in the works
(planned anyway).  What I was envisioning is the ability to set two
different sets of thresholds (peak / off peak).  If you demand zero
vacuuming during peak times, you could set that threshold to -1, or some
such setting.

FYI I wouldn't remcommend defaulting pg_autovacuum to on until it does
this, and a few more things that are also planned (see the archives).

Matthew