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: 4538B704.3020503@logix-tt.com (view raw or flat)
Thread:
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.

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

Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org

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-2014 The PostgreSQL Global Development Group