| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Jérôme BENOIS <benois(at)argia-engineering(dot)fr> |
| Cc: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com>, Dave Dutcher <dave(at)tridecap(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: High CPU Load |
| Date: | 2006-09-14 21:14:26 |
| Message-ID: | 9832.1158268466@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
=?ISO-8859-1?Q?J=E9r=F4me?= BENOIS <benois(at)argia-engineering(dot)fr> writes:
> Le jeudi 14 septembre 2006 =C3=A0 10:56 -0500, Scott Marlowe a =C3=A9crit :
>> I'm gonna make a SWAG here and guess that maybe your 7.4 db was initdb'd
>> with a locale of C and the new one is initdb'd with a real locale, like
>> en_US. Can J=C3=A9r=C3=B4me confirm or deny this?
> The locale used to run initdb is :
> su - postgres
> :~$ locale
> LANG=POSIX
It'd be more convincing if "show lc_collate" etc. display C or POSIX.
The fact that postgres' current default environment is LANG=POSIX
doesn't prove much about what initdb saw.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guillaume Smet | 2006-09-14 21:22:48 | Re: High CPU Load |
| Previous Message | Jérôme BENOIS | 2006-09-14 21:07:37 | Re: High CPU Load |