Re: Performance problem with Sarge compared with Woody

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Piñeiro <apinheiro(at)igalia(dot)com>
Cc: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance problem with Sarge compared with Woody
Date: 2006-09-12 15:13:14
Message-ID: 16370.1158073994@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

=?ISO-8859-1?Q?Pi=F1eiro?= <apinheiro(at)igalia(dot)com> writes:
> * About Postgre version: you advice me to upgrade from 7.4.7 (postgre
> version at sarge) to 8.2. Well, I don't want to be a troll, but I
> upgrade from 7.2.1 (woody) to 7.4.7 and I get worse, do you really think
> that upgrade to 8.1 will solve something?

If you really want informed answers rather than speculation, show us
EXPLAIN ANALYZE reports for the problem query on both machines.
I don't offhand know why 7.4 would be slower, but I speculate
that it's picking a worse plan for some reason.

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Chris Mair 2006-09-12 15:18:27 Re: Reg - Autovacuum
Previous Message krishnaraj D 2006-09-12 14:55:26 Reg - Autovacuum