Re: BUG #5200: Use of min suffix in autovacuum_naptime ignored

Andrew Masterton wrote:
> The following bug has been logged online:
>
> Bug reference: 5200
> Logged by: Andrew Masterton
> Email address: a(dot)j(dot)masterton(at)open(dot)ac(dot)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.

I can't reproduce this. Can you send the relevant lines from your
postgresql.conf and the logs showing what's happening, and/or anything
else that might help to track that down?

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com