Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 504536500EE for ; Mon, 21 Jul 2008 12:14:35 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 98452-04 for ; Mon, 21 Jul 2008 12:14:31 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from macnews.de (webmail.macnews.de [193.164.134.233]) by postgresql.org (Postfix) with ESMTP id E0C3564FFC4 for ; Mon, 21 Jul 2008 12:14:30 -0300 (ADT) Received: from [84.253.63.109] (account pl30411 HELO [192.168.113.215]) by macnews.de (CommuniGate Pro SMTP 5.0.11) with ESMTPA id 93318789 for pgsql-performance@postgresql.org; Mon, 21 Jul 2008 17:14:28 +0200 Message-ID: <4884A7D3.7050501@apache.org> Date: Mon, 21 Jul 2008 17:14:27 +0200 From: Andreas Hartmann User-Agent: Thunderbird 2.0.0.14 (Macintosh/20080421) MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Less rows -> better performance? 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> In-Reply-To: <4884A4A7.7050503@sime.com> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200807/184 X-Sequence-Number: 30784 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