| From: | "Andrew Masterton" <a(dot)j(dot)masterton(at)open(dot)ac(dot)uk> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #5200: Use of min suffix in autovacuum_naptime ignored |
| Date: | 2009-11-19 21:09:33 |
| Message-ID: | 200911192109.nAJL9XpR038628@wwwmaster.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2009-11-20 01:28:49 | Re: BUG #5065: pg_ctl start fails as administrator, with "could not locate matching postgres executable" |
| Previous Message | Tom Lane | 2009-11-19 19:55:09 | Re: BUG #5199: Window frame clause wrong (?) behaviour |