Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id CC4671337B47
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Wed, 20 Oct 2010 16:59:58 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 95999-04
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Wed, 20 Oct 2010 19:59:51 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mail-fx0-f46.google.com (mail-fx0-f46.google.com
	[209.85.161.46])
	by mail.postgresql.org (Postfix) with ESMTP id DCB01133798F
	for <pgsql-performance@postgresql.org>;
	Wed, 20 Oct 2010 16:59:49 -0300 (ADT)
Received: by fxm4 with SMTP id 4so3044454fxm.19
	for <pgsql-performance@postgresql.org>;
	Wed, 20 Oct 2010 12:59:48 -0700 (PDT)
Received: by 10.103.165.11 with SMTP id s11mr4217579muo.32.1287604788297;
	Wed, 20 Oct 2010 12:59:48 -0700 (PDT)
Received: from [10.10.3.129] (71-6-94-66.static-ip.telepacific.net
	[71.6.94.66])
	by mx.google.com with ESMTPS id z19sm392269fam.16.2010.10.20.12.59.43
	(version=SSLv3 cipher=RC4-MD5); Wed, 20 Oct 2010 12:59:45 -0700 (PDT)
Subject: Re: What is postmaster doing?
From: Jeff Davis <pgsql@j-davis.com>
To: Dimi Paun <dimi@lattica.com>
Cc: pgsql-performance@postgresql.org
In-Reply-To: <1287600255.18151.58.camel@dimi.lattica.com>
References: <1287600255.18151.58.camel@dimi.lattica.com>
Content-Type: text/plain; charset="ISO-8859-1"
Date: Wed, 20 Oct 2010 12:59:41 -0700
Message-ID: <1287604781.28384.50.camel@jdavis-ux.asterdata.local>
Mime-Version: 1.0
X-Mailer: Evolution 2.28.3 
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9,
	RCVD_IN_DNSWL_NONE=-0.0001
X-Spam-Level: 
X-Archive-Number: 201010/320
X-Sequence-Number: 40738

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