Re: Recent High CPU

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