Postgres Pro
Downloads
Home   >   mailing lists

the impact of encoding on performance. - Mailing list pgsql-general

From Michael Ben-Nes
Subject the impact of encoding on performance.
Date
Msg-id 422FF062.4070600@canaan.co.il
Whole thread Raw
Responses Re: the impact of encoding on performance.
List pgsql-general
Tree view 
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
--------------------------

pgsql-general by date:

Previous
From: Ulrich Wisser
Date:
Subject: Re: Can't start PostgreSQL on Fedora Core3
Next
From: Shaun Clements
Date:
Subject: Re: pl sql to check if table of table_name exists