Re: High CPU Load - Mailing list pgsql-performance

From Jérôme BENOIS
Subject Re: High CPU Load
Date
Msg-id 1158243436.5226.35.camel@localhost.localdomain
Whole thread Raw
In response to Re: High CPU Load  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: High CPU Load  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-performance
Hi Tom,

Le jeudi 14 septembre 2006 à 10:13 -0400, Tom Lane a écrit :
> =?ISO-8859-1?Q?J=E9r=F4me?= BENOIS <benois@argia-engineering.fr> 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 database after reloading it?
> pg_dump/reload won't by itself regenerate statistics.
>
>             regards, tom lane
I tested, dump + restore + vaccumdb --analyze on all databases but no change ...

Cheers,

--
Jérôme,

python -c "print '@'.join(['.'.join([w[::-1] for w in p.split('.')]) for
p in 'sioneb@gnireenigne-aigra.rf'.split('@')])"

Attachment

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: High CPU Load
Next
From: Scott Marlowe
Date:
Subject: Re: High CPU Load