Autovacuum seems to block database: WARNING worker took too long to start

Поиск
Список
Период
Сортировка
От Pablo Delgado
Тема Autovacuum seems to block database: WARNING worker took too long to start
Дата
Msg-id AANLkTi=rfhwt9Mqx8syiFp8yLAOMtbw9f=w96fbLJ_oN@mail.gmail.com
обсуждение исходный текст
Список pgsql-admin
Hi all,

I'm having a strange problem with postgres & autovacuum
Everything is working fine until I start getting the following errors ... and postgres stops working shortly after (it stops accepting connections)

2010-11-13 12:34:08.599 CET|1|||7104||4cde77b0.1bc0|2010-11-13 12:34:08 CET|1/44303|0|| LOG:  automatic vacuum of table "mrs.pg_catalog.pg_statistic": index scans: 1
        pages: 0 removed, 189 remain
        tuples: 132 removed, 4587 remain
        system usage: CPU 0.00s/0.00u sec elapsed 0.04 sec
2010-11-13 13:24:40.998 CET|2|||3300||4cdc2ae6.ce4|2010-11-11 18:41:58 CET||0|| WARNING:  worker took too long to start; cancelled
2010-11-13 13:25:41.126 CET|3|||3300||4cdc2ae6.ce4|2010-11-11 18:41:58 CET||0|| WARNING:  worker took too long to start; cancelled
2010-11-13 13:26:41.254 CET|4|||3300||4cdc2ae6.ce4|2010-11-11 18:41:58 CET||0|| WARNING:  worker took too long to start; cancelled
.........
.........
infinite errors like this ...
.........
.........

This situation obviously creates serious problems for us!! He have to restart the database to make it work again.

Some info of our system

OS: Centos 5.5
Kernel: 2.6.18-194.26.1.el5
Postgres version: 8.4.5 (installation out-of-the-box using yum)
Server memory: 28GB

Autovacuum configuration
autovacuum = on
vacuum_cost_delay = 10
log_autovacuum_min_duration =   0
autovacuum_naptime = 60
autovacuum_vacuum_threshold = 50
autovacuum_vacuum_cost_delay = 20ms

Shared memory value
shared_buffers = 917504

I've read the problem seems to be autovacuum using all resources and leaving the system unasable (not allowing to accept more connections), but I've not read the way to fix it.
Does upgrading to postgres 9.0 help?

Any help would be appreciated!

Thanks

Pablo

--
Mirai España S.L.
Calle Fuencarral 6, 4º
28004, Madrid
Tel. 91 5913500
Fax. 91 4473032
http://www.miraiespana.com/
-
Visit http://www.hotelsearch.com/ !!

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

Предыдущее
От: Pablo Delgado Díaz-Pache
Дата:
Сообщение: Re: Autovacuum seems to block database: WARNING worker took too long to start
Следующее
От: ojas dubey
Дата:
Сообщение: Find all running postgres DB servers on a network