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

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: "Douglas J Hunley" <doug(at)hunley(dot)homeip(dot)net>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
Date: 2007-06-04 21:11:23
Message-ID: 87ps4bl91g.fsf@oxford.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Heikki Linnakangas 2007-06-04 21:17:03 Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
Previous Message Heikki Linnakangas 2007-06-04 20:22:35 Re: dbt2 NOTPM numbers