Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Wed, 31 May 2006 15:18:00 +0200
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
- References:
- PGSQL 7.4 -> 8.1 migration & performance problem
- From: Philippe Lang
- PGSQL 7.4 -> 8.1 migration & performance problem
- Prev by Date: CreateUser error
- Next by Date: Re: Best high availability solution ?
- Previous by thread: Re: PGSQL 7.4 -> 8.1 migration & performance problem
- Next by thread: Re: PGSQL 7.4 -> 8.1 migration & performance problem
- Indexes: