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
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:[EMAIL PROTECTED] 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
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster