Effect of database encoding on performance - Mailing list pgsql-performance

From Igor Postelnik
Subject Effect of database encoding on performance
Date
Msg-id 46F30BC04EC6364695BC07D4A57AAD2C627208@auscorpex-1.austin.messageone.com
Whole thread Raw
List pgsql-performance

What’s the effect of different encodings on database performance?

 

We’re looking to switch encoding of our database from SQL_ASCII to UTF-8 to better handle international data. I expect that at least 90% of our data will be in the ASCII range with a few characters that need double-byte encoding. Has anyone done extensive comparison of the performance of different encodings?

 

-Igor

 

 

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: GiST indexes and concurrency (tsearch2)
Next
From: Sean Davis
Date:
Subject: Re: [SQL] OFFSET impact on Performance???