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: [EMAIL PROTECTED]> 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 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 | [EMAIL PROTECTED]> 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
[EMAIL PROTECTED]
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 //
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
