Skip site navigation (1) Skip section navigation (2)

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

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: Andrew Masterton <a(dot)j(dot)masterton(at)open(dot)ac(dot)uk>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5200: Use of min suffix in autovacuum_naptime ignored
Date: 2009-11-20 19:51:39
Message-ID: 4B06F34B.9040206@enterprisedb.com (view raw or flat)
Thread:
Lists: pgsql-bugs
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

In response to

pgsql-bugs by date

Next:From: Kris JurkaDate: 2009-11-20 23:43:04
Subject: Re: BUG #5197: JDBC: selecting oid results in Exception
Previous:From: Robert HaasDate: 2009-11-20 17:41:35
Subject: Re: BUG #5197: JDBC: selecting oid results in Exception

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group