Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 7F9899FB2BC for ; Thu, 19 Oct 2006 11:38:00 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 83202-02 for ; Thu, 19 Oct 2006 14:36:10 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 613749FB258 for ; Thu, 19 Oct 2006 11:33:02 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k9JEWpRQ011373; Thu, 19 Oct 2006 10:32:51 -0400 (EDT) To: Michael Fuhr cc: Andrzej Zawadzki , pgsql-performance@postgresql.org Subject: Re: VACUUM FULL ANALYZE on 8.1.4 is slower then on 8.0 In-reply-to: <20061019142548.GB19440@winnie.fuhr.org> References: <45377DFB.1000408@wp.pl> <20061019142548.GB19440@winnie.fuhr.org> Comments: In-reply-to Michael Fuhr message dated "Thu, 19 Oct 2006 08:25:48 -0600" Date: Thu, 19 Oct 2006 10:32:51 -0400 Message-ID: <11372.1161268371@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200610/401 X-Sequence-Number: 21530 Michael Fuhr writes: > On Thu, Oct 19, 2006 at 03:30:35PM +0200, Andrzej Zawadzki wrote: >> After upgrade PostgreSQL from 8.0 to 8.1.4 a VACUUM FULL ANALYZE >> process is much slower, from logs: > Is it possible that 8.1 was built with --enable-cassert and 8.0 > wasn't? What does "SHOW debug_assertions" show on each server? Different vacuum delay settings maybe? regards, tom lane