Postgres Pro
Downloads
Home   >   mailing lists

8.3 to 8.4 Upgrade issues - Mailing list pgsql-hackers

From Rod Taylor
Subject 8.3 to 8.4 Upgrade issues
Date
Msg-id AANLkTikKZgWdEx3iAvc7y7A3Udph51rRM0KcMgxRSdkY@mail.gmail.com
Whole thread Raw
Responses Re: 8.3 to 8.4 Upgrade issues
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Session timeout on commitfest.postgresql.org
Next
From: Tom Lane
Date:
Subject: Re: patch: Add JSON datatype to PostgreSQL (GSoC, WIP)