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 App Server). In tomcat I only run this application that has a connection pool of 30 connections(if I remember correctly).Once the application starts to open connections it looks that the each postmaster associated with the connection is not exiting as fast as was before. I can follow up with a ps -aux capture if you think that's helpful. Till yesterday all was working smoothly for about 2 years. It looks like the postmasters are not finishing of if they do takes a good while to finish. Also I've seen that the swap increases. I never use to have swap used. I don't have space problems not errors in the syslog.Am I running out of memory and all gets delayed by the swap handling ? I have the feeling that I spin around my tail. So these processes are taking all the CPU and memory and they hold for too long just doing a 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 provide more insight.MC> Date: Fri, 8 Jun 2007 16:35:40 -0400> From: ajs@xxxxxxxxxxxxxxx> To: pgsql-general@xxxxxxxxxxxxxx> 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 almost all the CPU. > > What else is the box doing? If it doesn't have any other work to do,> why shouldn't postgres use the CPU time? (This is a way of saying,> "You didn't tell us anything that would allow us to help.")> > A> > -- > Andrew Sullivan | ajs@xxxxxxxxxxxxxxx> In the future this spectacle of the middle classes shocking the avant-> garde will probably become the textbook definition of Postmodernism. > --Brad Holland> > ---------------------------(end of 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@xxxxxxxxxxxxxxxxx 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 //
