Postgres Pro
Downloads
Home   >   mailing lists

Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x - Mailing list pgsql-performance

From Gregory Stark
Subject Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
Date
Msg-id 87ps4bl91g.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x  (Douglas J Hunley <doug@hunley.homeip.net>)
Responses Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
List pgsql-performance
Tree view 
Those plans look like they have a lot of casts to text in them. How have you
defined your indexes? Are your id columns really text?

And you don't have a 7.4 install around to compare the plans do you?

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com

pgsql-performance by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: dbt2 NOTPM numbers
Next
From: Heikki Linnakangas
Date:
Subject: Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x