Postmaster taking up 100% of CPU

From: higeon <higeon(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Postmaster taking up 100% of CPU
Date: 2010-07-06 01:59:24
Message-ID: AANLkTilaoyL2RcTu4he-iDU9MKSYATU7qQEWfxopF4l7@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,everyone

The CPU of my linux box is 100% by postmaster processes for hours.
How to deal with it?
The following is my top log and ps log:

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
8970 postgres 16 0 53692 36m 34m R 27.3 3.6 1:14.80 postmaster
8807 postgres 16 0 53696 36m 34m R 27.0 3.6 1:26.62 postmaster
8653 postgres 16 0 53696 36m 34m R 23.7 3.6 1:32.29 postmaster
8961 postgres 16 0 53692 36m 34m R 21.7 3.6 1:36.59 postmaster

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tim Landscheidt 2010-07-06 12:38:39 [PATCH] Clarify that "psql -c" ignores psqlrc files
Previous Message Tom Lane 2010-07-06 00:08:39 Re: "Localizing" paths?