Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 89EA89FB258 for ; Thu, 19 Oct 2006 10:37:25 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 29303-04 for ; Thu, 19 Oct 2006 10:37:20 -0300 (ADT) X-Greylist: delayed 00:06:39.531259 by SQLgrey- Received: from smtp.wp.pl (mx.wp.pl [212.77.101.4]) by postgresql.org (Postfix) with ESMTP id 991129FB235 for ; Thu, 19 Oct 2006 10:37:19 -0300 (ADT) Received: (wp-smtpd smtp.wp.pl 846 invoked from network); 19 Oct 2006 15:30:37 +0200 Received: from bramka-zew.dfqs.pl (HELO [192.168.2.69]) (zawadaa@[194.126.222.22]) (envelope-sender ) by smtp.wp.pl (WP-SMTPD) with AES256-SHA encrypted SMTP for ; 19 Oct 2006 15:30:37 +0200 Message-ID: <45377DFB.1000408@wp.pl> Date: Thu, 19 Oct 2006 15:30:35 +0200 From: Andrzej Zawadzki User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.8.0.7) Gecko/20060916 SeaMonkey/1.0.5 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: VACUUM FULL ANALYZE on 8.1.4 is slower then on 8.0 Content-Type: text/plain; charset=ISO-8859-2 Content-Transfer-Encoding: 7bit X-WP-AV: skaner antywirusowy poczty Wirtualnej Polski S. A. X-WP-SPAM: NO AS1=NO(Body=1 Fuz1=1 Fuz2=1) AS2=NO(0.500000) AS3=NO AS4=NO AS5=NO X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.134 tagged_above=0 required=5 tests=FORGED_RCVD_HELO, SPF_PASS X-Spam-Level: X-Archive-Number: 200610/397 X-Sequence-Number: 21526 Hello! After upgrade PostgreSQL from 8.0 to 8.1.4 a VACUUM FULL ANALYZE process is much slower, from logs: 8.0 [13666][postgres][2006-10-06 01:13:38 CEST][1340121452] LOG: statement: VACUUM FULL ANALYZE; [13666][postgres][2006-10-06 01:39:15 CEST][0] LOG: duration: 1536862.425 ms 8.1 [4535][postgres][2006-10-10 01:08:51 CEST][6144112] LOG: statement: VACUUM FULL ANALYZE; [4535][postgres][2006-10-10 02:04:23 CEST][0] LOG: duration: 3332128.332 ms Databases are equal. I'm not using autovacuum. Linux kernel is the same in two cases. $uname -a Linux zamczysko 2.6.13.4 #2 SMP Tue Oct 18 21:19:23 UTC 2005 x86_64 Dual_Core_AMD_Opteron(tm)_Processor_875 unknown PLD Linux Why new PostgreSQL is slower? -- Andrzej Zawadzki