Re: Postmaster processes taking all the CPU

MC Moisei wrote:
>
> I'm not sure I understand the question. What else runs on it ?I have an Apache that fronts a Tomcat (Java Enterprise
AppServer). In tomcat I only run this application that has a connection pool of 30 connections(if I remember
correctly).Oncethe application starts to open connections it looks that the each postmaster associated with the
connectionis not exiting as fast as was before. I can follow up with a ps -aux capture if you think that's helpful.
Tillyesterday all was working smoothly for about 2 years. It looks like the postmasters are not finishing of if they do
takesa good while to finish. Also I've seen that the swap increases. I never use to have swap used. I don't have space
problemsnot errors in the syslog.Am I running out of memory and all gets delayed by the swap handling ? I have the
feelingthat I spin around my tail. So these processes are taking all the CPU and memory and they hold for too long just
doinga select. The traffic didn't increase by any me 
ans so one can say that causes the problem - at one point it sustained 4 times more traffic without problems.Hope this
providemore insight.MC> Date: Fri, 8 Jun 2007 16:35:40 -0400> From: ajs@crankycanuck.ca> To:
pgsql-general@postgresql.org>Subject: Re: [GENERAL] Postmaster processes taking all the CPU> > On Fri, Jun 08, 2007 at
03:20:28PM-0500, MC Moisei wrote:> > > > pack of postmaster(4-22) processes ran by postgres user are taking> > over
almostall the CPU. > > What else is the box doing?  If it doesn't have any other work to do,> why shouldn't postgres
usethe CPU time?  (This is a way of saying,> "You didn't tell us anything that would allow us to help.")> > A> > -- >
AndrewSullivan  | ajs@crankycanuck.ca> In the future this spectacle of the middle classes shocking the avant-> garde
willprobably become the textbook definition of Postmodernism. >                 --Brad Holland> >
---------------------------(endof broadcast)---------------------------> TIP 4: Have  
you searched our list archives?> >                http://archives.postgresql.org/
>

Could you please send your messages as plain text? Your mail client is
doing something foul to the plain text alternative incorporated in the
multi-part message. It's almost unreadable this way.

--
Alban Hertroys
alban@magproductions.nl

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
   7500 AK Enschede

// Integrate Your World //