Re: [PERFORM] High CPU Load

y postgres configuration) : http://sharengo.org/haplatform/docs/PostgreSQL/en/html_single/index.html Cheers, Jérôme. -- Open-Source : http://www.sharengo.org Corporate : http://www.argia-engineering.fr Le vendredi 22 septembre 2006 à 09:43 +0200, Jérôme BENOIS a écrit : > Hi, Markus, > > Le

Re: [PERFORM] High CPU Load

Hi, Markus, Le mardi 19 septembre 2006 à 15:09 +0200, Markus Schaber a écrit : > Hi, Jerome, > > Jérôme BENOIS wrote: > > >>> Now i Have 335 concurrent connections, i decreased work_mem parameter to > >>> 32768 and disabled Hyper Threading in BIOS. But my CP

Re: [PERFORM] High CPU Load

Markus, Le mardi 19 septembre 2006 à 11:53 +0200, Markus Schaber a écrit : > Hi, Jerome, > > Jérôme BENOIS wrote: > > > Now i Have 335 concurrent connections, i decreased work_mem parameter to > > 32768 and disabled Hyper Threading in BIOS. But my CPU load is still >

Re: [PERFORM] High CPU Load

Hi Markus, Le vendredi 15 septembre 2006 à 11:43 +0200, Markus Schaber a écrit : > Hi, Jérôme, > > Jérôme BENOIS wrote: > > > max_connections = 512 > > Do you really have that much concurrent connections? Then you should > think about getting a larger machi

Re: [PERFORM] High CPU Load

it('@')])" Le vendredi 15 septembre 2006 à 00:24 +0200, Guillaume Smet a écrit : > On 9/14/06, Jérôme BENOIS <[EMAIL PROTECTED]> wrote: > > Yes i have a lot of users ;-) > > So your work_mem is probably far too high (that's what I told you in > my firs

Re: [PERFORM] High CPU Load

Hi Guillaume, Le jeudi 14 septembre 2006 à 23:22 +0200, Guillaume Smet a écrit : > Jérôme, > > Perhaps it's a stupid question but are your queries slower than > before? You didn't tell it. No, it's not stupid question ! Yes queries speed but when the load average exceeds 40 all queries are slower

Re: [PERFORM] High CPU Load

pool but i have many servers in front of database server. Ok i will test new lower work_mem tomorrow. -- Jérôme, python -c "print '@'.join(['.'.join([w[::-1] for w in p.split('.')]) for p in '[EMAIL PROTECTED]'.split('@')])" > On Thu

Re: [PERFORM] High CPU Load

Hi Scott, Le jeudi 14 septembre 2006 à 10:56 -0500, Scott Marlowe a écrit : > On Thu, 2006-09-14 at 10:02, Dave Dutcher wrote: > > > -Original Message- > > > From: [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED] On Behalf Of > > > Jérôme BE

Re: [PERFORM] High CPU Load

Hi Dave, Le jeudi 14 septembre 2006 à 10:02 -0500, Dave Dutcher a écrit : > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of > > Jérôme BENOIS > > > explain analyze select distinct > > INTEGER_VALUE,DAT

Re: [PERFORM] High CPU Load

Hello, Le jeudi 14 septembre 2006 à 09:21 -0500, Scott Marlowe a écrit : > On Thu, 2006-09-14 at 09:17, Jérôme BENOIS wrote: > > Hi Tom, > > > > Le jeudi 14 septembre 2006 à 10:13 -0400, Tom Lane a écrit : > > > =?ISO-8859-1?Q?J=E9r=F4me?= BENOIS <[EMAIL

Re: [PERFORM] High CPU Load

Hi Tom, Le jeudi 14 septembre 2006 à 10:13 -0400, Tom Lane a écrit : > =?ISO-8859-1?Q?J=E9r=F4me?= BENOIS <[EMAIL PROTECTED]> writes: > >I migrated Postgres server from 7.4.6 to 8.1.4, But my server is > > completely full, by moment load average > 40 > > Did you remember to ANALYZE the whole

[PERFORM] High CPU Load

' default_with_oids = on My Server is Dual Xeon 3.06GHz with 2 Go RAM and good SCSI disks. Best Regards, Jérôme BENOIS. signature.asc Description: Ceci est une partie de message numériquement signée

Re: [PERFORM] High CPU Load

Hi Guillaume, Le jeudi 14 septembre 2006 à 15:46 +0200, Guillaume Smet a écrit : > On 9/14/06, Jérôme BENOIS <[EMAIL PROTECTED]> wrote: > >I migrated Postgres server from 7.4.6 to 8.1.4, But my server is > > completely full, by moment load average > 40 > >