Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group