BUG #5200: Use of min suffix in autovacuum_naptime ignored

Поиск
Список
Период
Сортировка
От Andrew Masterton
Тема BUG #5200: Use of min suffix in autovacuum_naptime ignored
Дата
Msg-id 200911192109.nAJL9XpR038628@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #5200: Use of min suffix in autovacuum_naptime ignored  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      5200
Logged by:          Andrew Masterton
Email address:      a.j.masterton@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.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Jaime Casanova
Дата:
Сообщение: Re: data shown from down to up
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: BUG #5065: pg_ctl start fails as administrator, with "could not locate matching postgres executable"