Postmaster taking up 100% of CPU

Postmaster taking up 100% of CPU

am 06.07.2010 03:59:24 von higeon

--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

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 lo=
g:

=A0 PID USER    =A0 PR=A0 NI=A0 VIRT=A0 RES=A0 SHR S %CPU=
%MEM  =A0 TIME+=A0 COMMAND


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


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




--0016e64ca740373e48048aae681b--

Re: Postmaster taking up 100% of CPU

am 06.07.2010 16:32:58 von Greg Smith

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@2ndQuadrant.com www.2ndQuadrant.us


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin