the impact of encoding on performance.

From: Michael Ben-Nes <miki(at)canaan(dot)co(dot)il>
To: postgresql <pgsql-general(at)postgresql(dot)org>
Subject: the impact of encoding on performance.
Date: 2005-03-10 06:59:46
Message-ID: 422FF062.4070600@canaan.co.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All

Snip <<<
The drawback of using locales other than C or POSIX in PostgreSQL is
its performance impact. It slows character handling and prevents
ordinary indexes from being used by LIKE. For this reason use locales
only if you actually need them.
snip;

What is the impact of the locale on the server ? is it irelevant, small
or huge ?

Encoding of the DB impact performance too ? UTF8, 8859-8 ?

Thanks

--
--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
Cel: 972-52-8555757
Fax: 972-4-6990098
http://www.canaan.net.il
--------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sim Zacks 2005-03-10 07:00:11 Re: postgresql on gentoo
Previous Message Adam Tomjack 2005-03-10 05:46:05 Re: Disabling triggers in a transaction