Re: Less rows -> better performance?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux