Re: VACUUM FULL ANALYZE on 8.1.4 is slower then on 8.0

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: Andrzej Zawadzki <zawadaa(at)wp(dot)pl>, pgsql-performance(at)postgresql(dot)org
Subject: Re: VACUUM FULL ANALYZE on 8.1.4 is slower then on 8.0
Date: 2006-10-19 14:32:51
Message-ID: 11372.1161268371@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Michael Fuhr <mike(at)fuhr(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Richard Huxton 2006-10-19 14:55:34 Re: DB Performance decreases due to often written/accessed
Previous Message Michael Fuhr 2006-10-19 14:25:48 Re: VACUUM FULL ANALYZE on 8.1.4 is slower then on 8.0