Re: How much expensive are row level statistics?

Поиск
Список
Период
Сортировка
От Michael Fuhr
Тема Re: How much expensive are row level statistics?
Дата
Msg-id 20051211194442.GA97174@winnie.fuhr.org
обсуждение исходный текст
Ответ на How much expensive are row level statistics?  (Carlos Benkendorf <carlosbenkendorf@yahoo.com.br>)
Ответы Re: How much expensive are row level statistics?  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-performance
On Sun, Dec 11, 2005 at 11:53:36AM +0000, Carlos Benkendorf wrote:
> I would like to use autovacuum but is not too much expensive
> collecting row level statistics?

The cost depends on your usage patterns.  I did tests with one of
my applications and saw no significant performance difference for
simple selects, but a series of insert/update/delete operations ran
about 30% slower when block- and row-level statistics were enabled
versus when the statistics collector was disabled.

--
Michael Fuhr

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

Предыдущее
От: Kaloyan Iliev
Дата:
Сообщение: Re: Query not using index
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Join the same row