Re: BUG #5849: Stats Collector Frozen - Autovacuum Not Working Anymore

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #5849: Stats Collector Frozen - Autovacuum Not Working Anymore
Дата
Msg-id 20057.1296062512@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #5849: Stats Collector Frozen - Autovacuum Not Working Anymore  ("Radu Ilie" <rilie@wsi.com>)
Ответы Re: BUG #5849: Stats Collector Frozen - Autovacuum Not Working Anymore  ("Ilie, Radu" <rilie@wsi.com>)
Список pgsql-bugs
Дерево обсуждения 
"Radu Ilie" <rilie@wsi.com> writes:
> PostgreSQL version: 8.4.4 32 bit

> We started noticing very poor performance one day ago. Turns out the
> autovacuum was no longer working.

Perhaps you ran into the cost_limit problem that was fixed in 8.4.6?

http://archives.postgresql.org/pgsql-committers/2010-11/msg00186.php

> Any idea why the stats collector was stuck?

I don't think you've offered any proof that the stats collector was
stuck.  Waiting for a message would be its normal state.

            regards, tom lane

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

Предыдущее
От: "Radu Ilie"
Дата:
Сообщение: BUG #5849: Stats Collector Frozen - Autovacuum Not Working Anymore
Следующее
От: Jens Kapp
Дата:
Сообщение: NO DATA error message in Frontend when querying large datasets