From: Tom Lane <tgl@sss.pgh.pa.us>
To: Michael Fuhr <mike@fuhr.org>
Cc: Andrzej Zawadzki <zawadaa@wp.pl>
Cc: pgsql-performance@postgresql.org
Subject: Re: VACUUM FULL ANALYZE on 8.1.4 is slower then on 8.0
Date: Thu, 19 Oct 2006 10:32:51 -0400
Message-ID: <11372.1161268371@sss.pgh.pa.us> (raw)
In-Reply-To: <20061019142548.GB19440@winnie.fuhr.org>
References: <45377DFB.1000408@wp.pl>
<20061019142548.GB19440@winnie.fuhr.org>
Michael Fuhr <mike@fuhr.org> 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
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: tgl@sss.pgh.pa.us, mike@fuhr.org, zawadaa@wp.pl
Subject: Re: VACUUM FULL ANALYZE on 8.1.4 is slower then on 8.0
In-Reply-To: <11372.1161268371@sss.pgh.pa.us>
* 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