Effect of database encoding on performance

Lists: pgsql-performance
From: "Igor Postelnik" <Igor_Postelnik(at)messageone(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Effect of database encoding on performance
Date: 2005-02-01 16:38:13
Message-ID: 46F30BC04EC6364695BC07D4A57AAD2C627208@auscorpex-1.austin.messageone.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: 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