Re: What is postmaster doing?

From: Dimi Paun <dimi(at)lattica(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Jeff Davis <pgsql(at)j-davis(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: What is postmaster doing?
Date: 2010-10-20 20:39:33
Message-ID: 1287607173.18151.75.camel@dimi.lattica.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, 2010-10-20 at 16:26 -0400, Tom Lane wrote:
> > It seems strange that the postmaster is eating 99% cpu. Is there a
> > chance that it's flooded with connection attempts?

Maybe, I'll try to figure that one out next time it happens.

> It's probably a backend process, not the postmaster --- I suspect the
> OP is using a version of ps that only tells you the original process
> name by default. "ps auxww" or "ps -ef" (depending on platform)
> is likely to be more informative. Looking into pg_stat_activity,
> even more so.

I'm running CentOS 5.5, using procps-3.2.7-16.el5. I cannot check
more at this point as postmaster seems to have finished whatever it
was doing, but I'll try to investigate better next time.

--
Dimi Paun <dimi(at)lattica(dot)com>
Lattica, Inc.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2010-10-20 20:45:29 Re: What is postmaster doing?
Previous Message Mladen Gogala 2010-10-20 20:30:19 Re: What is postmaster doing?