Postgres Pro
Downloads
Home   >   mailing lists

Re: VACUUM FULL ANALYZE on 8.1.4 is slower then on 8.0 - Mailing list pgsql-performance

From Tom Lane
Subject Re: VACUUM FULL ANALYZE on 8.1.4 is slower then on 8.0
Date
Msg-id 11372.1161268371@sss.pgh.pa.us
Whole thread Raw
In response to Re: VACUUM FULL ANALYZE on 8.1.4 is slower then on 8.0  (Michael Fuhr <mike@fuhr.org>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: VACUUM FULL ANALYZE on 8.1.4 is slower then on 8.0
Next
From: Richard Huxton
Date:
Subject: Re: DB Performance decreases due to often written/accessed