From: Miroslav Šulc <miroslav.sulc@startnet.cz>
To: pginfo <pginfo@t1.unisoftbg.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: lower and unicode
Date: Mon, 14 Mar 2005 13:57:35 +0100
Message-ID: <42358A3F.6090400@startnet.cz> (raw)
In-Reply-To: <42357AA0.4090303@t1.unisoftbg.com>
References: <423528B6.2070407@t1.unisoftbg.com>
<42354812.7030106@startnet.cz>
<42355BFC.4080409@t1.unisoftbg.com>
<42356AB5.1010306@startnet.cz>
<42357AA0.4090303@t1.unisoftbg.com>
pginfo wrote:
> Hi,
> I am using --no-locale by init db.
> I readet that if I am using some locale the pg will work very slow.
I don't remember reading it will be very slow. I just remember that I've
read it will slow down some things (which I think is logical in this case).
> Have you noticed some speed penalty by using cs_CZ.utf8.
When using PostgreSQL, I need correct collating order for strings so I
have no other choice. I didn't do any speed tests but I think if you
need correct behaviour for your locale, you should use your locale. Just
try it and you will see the results. You can then make a decision for
yourself. I think you won't be the only one using locale for your
database ;-)
> regards,
> ivan.
Miroslav
Attachments:miroslav.sulc.vcf (text/x-vcard, 385B) download
begin:vcard
fn;quoted-printable:Miroslav =C5=A0ulc
n;quoted-printable:=C5=A0ulc;Miroslav
org:StartNet s.r.o.
adr;quoted-printable;quoted-printable:;;Vrchlick=C3=A9ho 161/5;Praha 5;;150 00;=C4=8Cesk=C3=A1 republika
email;internet:miroslav.sulc@startnet.cz
title:CEO
tel;work:+420 257 225 602
tel;cell:+420 603 711 413
x-mozilla-html:TRUE
url:http://www.startnet.cz
version:2.1
end:vcard
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: miroslav.sulc@startnet.cz, pginfo@t1.unisoftbg.com
Subject: Re: lower and unicode
In-Reply-To: <42358A3F.6090400@startnet.cz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox