| From: | Martín Marqués <martin(at)bugs(dot)unl(dot)edu(dot)ar> |
|---|---|
| To: | Jeremiah Jahn <jeremiah(at)cs(dot)earlham(dot)edu> |
| Cc: | postgres list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Where is initdb? |
| Date: | 2004-01-27 15:51:20 |
| Message-ID: | 1075218680.401688f806fc0@bugs.unl.edu.ar |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Mensaje citado por Jeremiah Jahn <jeremiah(at)cs(dot)earlham(dot)edu>:
> I think it's fair to say that out of the box and RPM install should not
> result in indexes not being used because the LANG is set to something
> other than 'C'. I'm all for reading the manual and tuning later, but
> that is something that can't be changed without a complete
> dump/initdb/restore. It's just always seemed kind of misleading to me..
The question is which should be the default? For me it's better to have
LANG=es_AR, just because I will have REAL string ordering in a query like this:
SELECT varfield FROM sometable ORDER BY varfield;
That would work great with 'C' locale if varfield didn't contain caracters like á,
é, í, ó, ú, ñ.
--
select 'mmarques' || '@' || 'unl.edu.ar' AS email;
-------------------------------------------------------
Martín Marqués | Programador, DBA
Centro de Telemática | Administrador
Universidad Nacional
del Litoral
-------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ericson Smith | 2004-01-27 15:55:12 | Re: I can't upgrade to PostgreSQL 7.4 in RedHat 9.0 |
| Previous Message | Lincoln Yeoh | 2004-01-27 15:46:17 | Re: postmaster growing to consume all memory |