From: Jeff Davis <pgsql@j-davis.com>
To: Dimi Paun <dimi@lattica.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: What is postmaster doing?
Date: Wed, 20 Oct 2010 12:59:41 -0700
Message-ID: <1287604781.28384.50.camel@jdavis-ux.asterdata.local> (raw)
In-Reply-To: <1287600255.18151.58.camel@dimi.lattica.com>
References: <1287600255.18151.58.camel@dimi.lattica.com>
On Wed, 2010-10-20 at 14:44 -0400, Dimi Paun wrote:
> 23425 postgres 20 0 22008 10m 10m R 99.9 0.5 21:45.87 postmaster
>
> I'd like to figure out what it is doing. How can I figure out what
> statement causes the problem?
>
It seems strange that the postmaster is eating 99% cpu. Is there a
chance that it's flooded with connection attempts?
Usually the work is done by backend processes, not the postmaster. The
postmaster just does some management like accepting connections and
starting new processes.
Regards,
Jeff Davis
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: pgsql@j-davis.com, dimi@lattica.com
Subject: Re: What is postmaster doing?
In-Reply-To: <1287604781.28384.50.camel@jdavis-ux.asterdata.local>
* 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