Re: Less rows -> better performance? - Mailing list 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