From: Andreas Hartmann <andreas@apache.org>
To: pgsql-performance@postgresql.org
Subject: Re: Less rows -> better performance?
Date: Mon, 21 Jul 2008 17:14:27 +0200
Message-ID: <4884A7D3.7050501@apache.org> (raw)
In-Reply-To: <4884A4A7.7050503@sime.com>
References: <48846A02.7090702@apache.org>
<48846DA3.2090308@archonet.com>
<4884722A.1000405@apache.org>
<1d4e0c10807210432v45c6272awb1ea13974747de54@mail.gmail.com>
<4884A0F6.2000501@apache.org>
<4884A4A7.7050503@sime.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: andreas@apache.org
Subject: Re: Less rows -> better performance?
In-Reply-To: <4884A7D3.7050501@apache.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox