Postmaster taking up 100% of CPU

--0016e64ca740373e48048aae681b
Content-Type: text/plain; charset=ISO-8859-1

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

--0016e64ca740373e48048aae681b
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi,everyone<br><br>The CPU of my linux box is 100% by postmaster processes =
for hours.<br>How to deal with it?<br>The following is my top log and ps lo=
g:<br><br>=A0 PID USER=A0=A0=A0=A0=A0 PR=A0 NI=A0 VIRT=A0 RES=A0 SHR S %CPU=
%MEM=A0=A0=A0 TIME+=A0 COMMAND<br>

=A08970 postgres=A0 16=A0=A0 0 53692=A0 36m=A0 34m R 27.3=A0 3.6=A0=A0 1:14=
..80 postmaster<br>=A08807 postgres=A0 16=A0=A0 0 53696=A0 36m=A0 34m R 27.0=
=A0 3.6=A0=A0 1:26.62 postmaster<br>=A08653 postgres=A0 16=A0=A0 0 53696=A0=
36m=A0 34m R 23.7=A0 3.6=A0=A0 1:32.29 postmaster<br>

=A08961 postgres=A0 16=A0=A0 0 53692=A0 36m=A0 34m R 21.7=A0 3.6=A0=A0 1:36=
..59 postmaster<br><br><br>

--0016e64ca740373e48048aae681b--
higeon [ Di, 06 Juli 2010 03:59 ] [ ID #2044123 ]

Re: Postmaster taking up 100% of CPU

higeon wrote:
> The following is my top log and ps log:

Try using "top -c" on Linux instead. Then you'll be able to see what
all the processes are doing. Any heavy query will cause a CPU to
consume 100% of its time when running, so there may be nothing wrong
other than you have queries to optimize better.

--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg [at] 2ndQuadrant.com www.2ndQuadrant.us


--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Greg Smith [ Di, 06 Juli 2010 16:32 ] [ ID #2044124 ]
Datenbanken » gmane.comp.db.postgresql.admin » Postmaster taking up 100% of CPU

Vorheriges Thema: Change to 'timing on' globally
Nächstes Thema: Zip file for windows 8.4.4 binary