Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x - Mailing list 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