8.3 to 8.4 Upgrade issues

From: Rod Taylor <rod(dot)taylor(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: 8.3 to 8.4 Upgrade issues
Date: 2010-08-10 17:21:45
Message-ID: AANLkTikKZgWdEx3iAvc7y7A3Udph51rRM0KcMgxRSdkY@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

We recently upgraded from 8.3 to 8.4 and have seen a performance
degredation which we are trying to explain and I have been asked to
get a second opinion on the cost of going from LATIN1 to UTF8
(Collation and CType) where the encoding remained SQL_ASCII..

Does anybody have experience on the cost, if any, of making this change?

Pg 8.3:
Encoding: SQL_ASCII
LC_COLLATE: en_US
LC_CTYPE: en_US

Pg 8.4:
Encoding: SQL_ASCII
Collation: en_US.UTF-8
Ctype: en_US.UTF-8

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2010-08-10 17:22:04 Re: Session timeout on commitfest.postgresql.org
Previous Message Steve Atkins 2010-08-10 15:51:55 Re: host name support in pg_hba.conf