pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostmaster taking up 100% of CPU
2+ messages / 2 participants
[nested] [flat]
* Postmaster taking up 100% of CPU
@ 2010-07-06 01:59 higeon <higeon@gmail.com>
2010-07-06 14:32 ` Re: Postmaster taking up 100% of CPU Greg Smith <greg@2ndquadrant.com>
0 siblings, 1 reply; 2+ messages in thread
From: higeon @ 2010-07-06 01:59 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Postmaster taking up 100% of CPU
2010-07-06 01:59 Postmaster taking up 100% of CPU higeon <higeon@gmail.com>
@ 2010-07-06 14:32 ` Greg Smith <greg@2ndquadrant.com>
0 siblings, 0 replies; 2+ messages in thread
From: Greg Smith @ 2010-07-06 14:32 UTC (permalink / raw)
To: higeon <higeon@gmail.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2010-07-06 14:32 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-07-06 01:59 Postmaster taking up 100% of CPU higeon <higeon@gmail.com>
2010-07-06 14:32 ` Greg Smith <greg@2ndquadrant.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox