Re: Less rows -> better performance?

From: Andreas Hartmann <andreas(at)apache(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Less rows -> better performance?
Date: 2008-07-21 15:14:27
Message-ID: 4884A7D3.7050501@apache.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mario Weilguni 2008-07-21 15:29:14 Re: Less rows -> better performance?
Previous Message Harald Armin Massa 2008-07-21 14:56:27 Re: Less rows -> better performance?