From: Tom Lane <tgl@sss.pgh.pa.us>
To: Jérôme BENOIS <benois@argia-engineering.fr>
Cc: Scott Marlowe <smarlowe@g2switchworks.com>
Cc: Dave Dutcher <dave@tridecap.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: High CPU Load
Date: Thu, 14 Sep 2006 17:14:26 -0400
Message-ID: <9832.1158268466@sss.pgh.pa.us> (raw)
In-Reply-To: <1158268058.5167.2.camel@localhost.localdomain>
References: <004001c6d80e$bdef5bc0$8300a8c0@tridecap.com>
<1158249411.24726.17.camel@state.g2switchworks.com>
<1158268058.5167.2.camel@localhost.localdomain>
=?ISO-8859-1?Q?J=E9r=F4me?= BENOIS <benois@argia-engineering.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
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-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, benois@argia-engineering.fr, smarlowe@g2switchworks.com, dave@tridecap.com
Subject: Re: High CPU Load
In-Reply-To: <9832.1158268466@sss.pgh.pa.us>
* 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