Skip site navigation (1) Skip section navigation (2)

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

From: Markus Schaber <schabi(at)logix-tt(dot)com>
To: Andrzej Zawadzki <zawadaa(at)wp(dot)pl>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: VACUUM FULL ANALYZE on 8.1.4 is slower then on 8.0
Date: 2006-10-20 11:46:12
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
Hi, Andrzej,

Andrzej Zawadzki wrote:
> 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.

Are they on equal disks? And in the same areas of those disks? Some
current disks tend to drop down their speed at the "end" of the LBA
address space drastically.

Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in Europe!

In response to

pgsql-performance by date

Next:From: Tobias BroxDate: 2006-10-20 12:18:57
Subject: Re: Swappiness setting on a linux pg server
Previous:From: Harald Armin MassaDate: 2006-10-20 08:13:58
Subject: pgBench on Windows

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group