From: Dimi Paun <dimi@lattica.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Jeff Davis <pgsql@j-davis.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: What is postmaster doing?
Date: Wed, 20 Oct 2010 16:39:33 -0400
Message-ID: <1287607173.18151.75.camel@dimi.lattica.com> (raw)
In-Reply-To: <3615.1287606374@sss.pgh.pa.us>
References: <1287600255.18151.58.camel@dimi.lattica.com>
<1287604781.28384.50.camel@jdavis-ux.asterdata.local>
<3615.1287606374@sss.pgh.pa.us>
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@lattica.com>
Lattica, Inc.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dimi@lattica.com, tgl@sss.pgh.pa.us, pgsql@j-davis.com
Subject: Re: What is postmaster doing?
In-Reply-To: <1287607173.18151.75.camel@dimi.lattica.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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