From: Andrzej Zawadzki <zawadaa@wp.pl>
To: pgsql-performance@postgresql.org
Subject: VACUUM FULL ANALYZE on 8.1.4 is slower then on 8.0
Date: Thu, 19 Oct 2006 15:30:35 +0200
Message-ID: <45377DFB.1000408@wp.pl> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: zawadaa@wp.pl
Subject: Re: VACUUM FULL ANALYZE on 8.1.4 is slower then on 8.0
In-Reply-To: <45377DFB.1000408@wp.pl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox