Re: count(*) performance

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: count(*) performance
Дата
Msg-id 20060327193527.GB12691@surnet.cl
обсуждение исходный текст
Ответ на Re: count(*) performance  (Brendan Duddridge <brendan@clickspace.com>)
Список pgsql-performance
Brendan Duddridge wrote:
> Does that mean that even though autovacuum is turned on, you still
> should do a regular vacuum analyze periodically?

No, it probably means you have set FSM settings too low, or not tuned
the autovacuum parameters to your specific situation.

A bug in the autovacuum daemon is not unexpected however, so if it
doesn't work after tuning, let us know.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

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

Предыдущее
От: "Matthew T. O'Connor"
Дата:
Сообщение: Re: count(*) performance
Следующее
От: Guido Neitzer
Дата:
Сообщение: Re: count(*) performance