Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id E32A3632371 for ; Mon, 16 Aug 2010 03:44:45 -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 93189-10 for ; Mon, 16 Aug 2010 06:44:38 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.186]) by mail.postgresql.org (Postfix) with ESMTP id 36CFA632324 for ; Mon, 16 Aug 2010 03:44:38 -0300 (ADT) Received: from [192.168.1.151] (static-71-179-240-8.bltmmd.fios.verizon.net [71.179.240.8]) by mrelayeu.kundenserver.de (node=mrbap0) with ESMTP (Nemesis) id 0MIPk7-1OkbWO2Ti3-004Iim; Mon, 16 Aug 2010 08:44:36 +0200 Message-ID: <4C68DE52.70001@2ndquadrant.com> Date: Mon, 16 Aug 2010 02:44:34 -0400 From: Greg Smith User-Agent: Thunderbird 2.0.0.24 (X11/20100317) MIME-Version: 1.0 To: Mario Splivalo CC: pgsql-testers@postgresql.org Subject: Re: vacuum in pg9beta4 much slower than in 8.4 References: <4C6801B4.5050202@megafon.hr> In-Reply-To: <4C6801B4.5050202@megafon.hr> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V02:K0:F2V2BEiPleN/avehH6Tbk1IsKdJBhGpLLbwAKLlp2SY iMFiK4TRPwlvL/lG6BTdIrX040pgdo72MSbXvJsffpSZZSQYRh OUfMWsEc32pFs0pj06pZ8PVrcBuj7PqzBaOcr9M34uQZNyAEUT NFXbTWfxLM4OI4G8xx3u3DXZO1jQ8X1b+Hp0YPwbw0LFGsbvkI tL5Y7kXUk/Xj4dTohWnrMr2Y8DJggmsZWVLuboU4VY= 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, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201008/15 X-Sequence-Number: 170 Mario Splivalo wrote: > I understand that VACUUM FULL in 9.0 copies all the data, but is it OK > that plain vacuum in 9.0 is slower than in 8.4? It should be faster for tables with a lot of junk in them, but the new VACUUM FULL is likely to be slower for ones that are already clean. Note that one thing to be aware of is that depending on where you got your 9.0 from, it may be compiled with debugging and assertion calls that can slow certain operations down quite a bit. If you try this at a command prompt: postgres=# show debug_assertions; debug_assertions ------------------ on And that's on, you can expect that copy of 9.0 to be significantly slower at a number of things than a similar 8.4. -- Greg Smith 2ndQuadrant US Baltimore, MD PostgreSQL Training, Services and Support greg@2ndQuadrant.com www.2ndQuadrant.us