Postgres Pro
Downloads
Home   >   mailing lists

Re: Recent High CPU - Mailing list pgsql-general

From Gaetano Mendola
Subject Re: Recent High CPU
Date
Msg-id 40F8F541.6030207@bigfoot.com
Whole thread Raw
In response to Recent High CPU  (Hunter Hillegas <lists@lastonepicked.com>)
List pgsql-general
Tree view 
Hunter Hillegas wrote:

 > I have recently seen my 'postmaster' processes sucking up a lot of CPU.
 >
 > What can I do to determine why they have started eating the processors?
 >
 > I am running 7.4.2 on Red Hat Enterprise 2.1.

I had the same behaviour if I didn't reindex the tables at least one in a
week. You are using the 7.4 so it's enough vacuum the db, do you use the
pg_autovacuum daemon ?


Regards
Gaetano Mendola

pgsql-general by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: FOR-IN-EXECUTE, why fail?
Next
From: Gunasekaran Balakrishnan
Date:
Subject: Re: DIfferent ORDER BY behaviour in 7.4.2