Re: Less rows -> better performance?

Поиск
Список
Период
Сортировка
От Andreas Hartmann
Тема Re: Less rows -> better performance?
Дата
Msg-id 4884A7D3.7050501@apache.org
обсуждение исходный текст
Ответ на Less rows -> better performance?  (Andreas Hartmann <andreas@apache.org>)
Ответы Re: Less rows -> better performance?  (Mario Weilguni <mweilguni@sime.com>)
Список pgsql-performance
Mario Weilguni schrieb:
> Andreas Hartmann schrieb:

[…]

>> I just verified that the autovacuum property is enabled.

[…]

> Did you have:
> stats_start_collector = on
> stats_block_level = on
> stats_row_level = on
>
> Otherwise autovacuum won't run IMO.

Thanks for the hint! The section looks like this:

stats_start_collector = on
#stats_command_string = off
#stats_block_level = off
stats_row_level = on
#stats_reset_on_server_start = off


I'll check the logs if the vacuum really runs - as soon as I find them :)

-- Andreas
--
Andreas Hartmann, CTO
BeCompany GmbH
http://www.becompany.ch
Tel.: +41 (0) 43 818 57 01

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

Предыдущее
От: "Harald Armin Massa"
Дата:
Сообщение: Re: Less rows -> better performance?
Следующее
От: Mario Weilguni
Дата:
Сообщение: Re: Less rows -> better performance?