Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id C09EC6327A7 for ; Mon, 16 Aug 2010 14:12:38 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 55360-03 for ; Mon, 16 Aug 2010 17:12:31 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from glacier.frostconsultingllc.com (glacier.frostconsultingllc.com [69.36.227.170]) by mail.postgresql.org (Postfix) with ESMTP id A582E632C6C for ; Mon, 16 Aug 2010 14:12:31 -0300 (ADT) Received: from dsl081-245-111.sfo1.dsl.speakeasy.net ([64.81.245.111] helo=[192.168.1.118]) by glacier.frostconsultingllc.com with esmtpsa (TLSv1:CAMELLIA256-SHA:256) (Exim 4.69) (envelope-from ) id 1Ol3EY-0001qJ-Nq for pgsql-testers@postgresql.org; Mon, 16 Aug 2010 10:12:29 -0700 Message-ID: <4C697179.5080906@agliodbs.com> Date: Mon, 16 Aug 2010 10:12:25 -0700 From: Josh Berkus User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.1.9pre) Gecko/20100217 Shredder/3.0.3pre MIME-Version: 1.0 To: pgsql-testers@postgresql.org Subject: Re: vacuum in pg9beta4 much slower than in 8.4 References: <4C6801B4.5050202@megafon.hr> <4C68DE52.70001@2ndquadrant.com> <4C690609.5030306@megafon.hr> In-Reply-To: <4C690609.5030306@megafon.hr> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201008/17 X-Sequence-Number: 172 > Yes, I run the tests on clean tables. I run VACUUM FULL, and after that > I mesured how long it takes for VACUUM ANALYZE and VACUUM ANALYZE FULL. > So, it is ok for VACUUM FULL (on clean tables) on 9.0b4 to be six times > slower than on 8.4. But is it ok for plain VACUUM to be two times slower? On clean or on dirty tables? -- -- Josh Berkus PostgreSQL Experts Inc. http://www.pgexperts.com