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

Re: PGSQL 7.4 -> 8.1 migration & performance problem

From: Nis Jorgensen <nis(at)superlativ(dot)dk>
To: Philippe Lang <philippe(dot)lang(at)attiksystem(dot)ch>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PGSQL 7.4 -> 8.1 migration & performance problem
Date: 2006-05-31 13:18:00
Message-ID: 447D9788.9030700@superlativ.dk (view raw or flat)
Thread:
Lists: pgsql-general
Philippe Lang wrote:
> Hi,
> 
> For an unknown reason, I cannot post this message to the mailing-list!
> 
> Here it is:
> 
> http://www.attiksystem.ch/postgresql-general.txt

Please post query and table structure as well. And since you are using a
medium with no limitation on line lenght, unwrap the query plan.

EXPLAIN ANALYZE output would more useful. Indeed, PG 8 believes it has
found a "better" plan than 7.4, costing only ~1.1 million units
(although these are probably not directly comparable).

Memory settings might be relevant - you may be comparing a vanilla
installation of 8.1 with a "tuned" 7.4.

/Nis



In response to

pgsql-general by date

Next:From: Tatsuo IshiiDate: 2006-05-31 13:26:42
Subject: Re: Lossy character conversion to Latin-1
Previous:From: Pit MüllerDate: 2006-05-31 13:08:42
Subject: Re: Problem in Pg 8.1.4 with CREATEDB

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