From: Jeff Davis <pgsql@j-davis.com>
To: Piñeiro <apinheiro@igalia.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance problem with Sarge compared with Woody
Date: Mon, 11 Sep 2006 12:11:49 -0700
Message-ID: <1158001909.29889.33.camel@dogma.v10.wvs> (raw)
In-Reply-To: <1157998456.7540.15.camel@codfix.local.igalia.com>
References: <1157998456.7540.15.camel@codfix.local.igalia.com>
On Mon, 2006-09-11 at 20:14 +0200, Piñeiro wrote:
> Hi,
>
> a week ago we migrate a Woody(postgre 7.2.1) server to Sarge(postgre
> 7.4.7). To migrate the database we use a dump, using pg_dump with this
> options:
> pg_dump -U <username> -c -F p -O -v -f <filename> <DBname>
>
> We have a search, that using woody take about 1-2 minutes, but with
> sarge it is executing about 2 hours, and at least it crashes, with a
> message about a temporal file and no more disk space ( i have more than
> a GB of free disk space).
>
It sounds to me like it's choosing a bad sort plan, and unable to write
enough temporary disk files.
A likely cause is that you did not "vacuum analyze" after you loaded the
data. Try running that command and see if it helps. If not, can you
provide the output of "explain" and "explain analyze" on both the old
database and the new?
Also, I suggest that you upgrade to 8.1. 7.4 is quite old, and many
improvements have been made since then.
Regards,
Jeff Davis
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: pgsql@j-davis.com, apinheiro@igalia.com
Subject: Re: Performance problem with Sarge compared with Woody
In-Reply-To: <1158001909.29889.33.camel@dogma.v10.wvs>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox