Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id 3CC739FA4F0
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Fri, 20 Oct 2006 08:46:23 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 07121-03 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Fri, 20 Oct 2006 08:46:15 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from mail.logix-tt.com (mail.logix-tt.com [212.211.145.186])
	by postgresql.org (Postfix) with ESMTP id 072F89FB1D5
	for <pgsql-performance@postgresql.org>;
	Fri, 20 Oct 2006 08:46:14 -0300 (ADT)
Received: from kingfisher.intern.logix-tt.com
	(84-72-188-217.dclient.hispeed.ch [84.72.188.217])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by mail.logix-tt.com (Postfix) with ESMTP id 150D26599C;
	Fri, 20 Oct 2006 13:48:47 +0200 (CEST)
Received: from [127.0.0.1] (localhost [127.0.0.1])
	by kingfisher.intern.logix-tt.com (Postfix) with ESMTP id B9CAC181C2173;
	Fri, 20 Oct 2006 13:46:12 +0200 (CEST)
Message-ID: <4538B704.3020503@logix-tt.com>
Date: Fri, 20 Oct 2006 13:46:12 +0200
From: Markus Schaber <schabi@logix-tt.com>
Organization: Logical Tracking and Tracing International AG, Switzerland
User-Agent: Thunderbird 1.5.0.7 (X11/20060927)
MIME-Version: 1.0
To: 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
References: <45377DFB.1000408@wp.pl>
In-Reply-To: <45377DFB.1000408@wp.pl>
X-Enigmail-Version: 0.94.0.0
Content-Type: text/plain; charset=ISO-8859-15
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.184 tagged_above=0 required=5 tests=AWL,
	FORGED_RCVD_HELO
X-Spam-Level: 
X-Archive-Number: 200610/428
X-Sequence-Number: 21557

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