Обсуждение: Recent High CPU

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.

Thanks,
Hunter

On Friday 16 July 2004 10:57 pm, 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?
>

Here are some starting places:

Check the Postgresql log files for clues.

Find what queries are running:
select * from pg_stat_activity;

Use basic system tools (ps, netstat, fuser, etc.) to track back to the
client machine and process that is triggering the high usage.

The above may lead you to the answer. If not, ask here again with the
info you have discovered.

Cheers,
Steve

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