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

From: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
To: Douglas J Hunley <doug(at)hunley(dot)homeip(dot)net>
Cc: Gregory Stark <stark(at)enterprisedb(dot)com>, 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:17:03
Message-ID: 4664814F.4050109@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Gregory Stark wrote:
> 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 did you use the same encoding and locale? Text operations on
multibyte encodings are much more expensive.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message david 2007-06-04 23:33:24 Re: Thousands of tables versus on table?
Previous Message Gregory Stark 2007-06-04 21:11:23 Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x