The following bug has been logged online: Bug reference: 5200 Logged by: Andrew Masterton Email address: a.j.master...@open.ac.uk PostgreSQL version: 8.3.8 Operating system: RedHat Enterprise 5.4 Description: Use of min suffix in autovacuum_naptime ignored Details:
The default configuration of 8.3.8 has autovacuum_naptime = 1min. It would appear that the min is ignored as turning up debug show the autovacuum running every second. On my 8.3.8 installation with a large number of databases and tables this has the side effect of the stats collector process using up large amounts of CPU and I/O. Changing this setting to 60min causes the autovacuum process to have the correct 60 second naptime. I Haven't tried removing the min and setting it to s to see if any time suffix is ignored for this configuration option. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
