Re: Recent High CPU

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: Hunter Hillegas <lists(at)lastonepicked(dot)com>
Subject: Re: Recent High CPU
Date: 2004-07-17 09:45:37
Message-ID: 40F8F541.6030207@bigfoot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gaetano Mendola 2004-07-17 09:49:08 Re: FOR-IN-EXECUTE, why fail?
Previous Message Clodoaldo Pinto Neto 2004-07-17 09:30:07 Re: server closed the connection unexpectedly