Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id A15A81337B50 for ; Wed, 20 Oct 2010 17:55:59 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 61646-01 for ; Wed, 20 Oct 2010 20:55:53 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from ulysses.lattica.com (lattica.com [204.14.19.114]) by mail.postgresql.org (Postfix) with ESMTP id 3583C1337B78 for ; Wed, 20 Oct 2010 17:55:52 -0300 (ADT) Received: from localhost (ulysses.lattica.com [127.0.0.1]) by ulysses.lattica.com (Postfix) with ESMTP id 388D5738781; Wed, 20 Oct 2010 16:55:52 -0400 (EDT) X-Virus-Scanned: amavisd-new at lattica.com Received: from ulysses.lattica.com ([127.0.0.1]) by localhost (ulysses.lattica.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id pDsbzCVZTaKf; Wed, 20 Oct 2010 16:55:51 -0400 (EDT) Received: from [192.168.3.11] (CPE00222d5a2ad0-CM00222d5a2acd.cpe.net.cable.rogers.com [99.230.157.51]) by ulysses.lattica.com (Postfix) with ESMTP id F3AB673808E; Wed, 20 Oct 2010 16:55:50 -0400 (EDT) Subject: Re: What is postmaster doing? From: Dimi Paun To: Tom Lane Cc: Jeff Davis , pgsql-performance@postgresql.org In-Reply-To: <4055.1287607529@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> <1287607173.18151.75.camel@dimi.lattica.com> <4055.1287607529@sss.pgh.pa.us> Content-Type: text/plain; charset="UTF-8" Organization: Lattica, Inc. Date: Wed, 20 Oct 2010 16:55:50 -0400 Message-ID: <1287608150.18151.77.camel@dimi.lattica.com> Mime-Version: 1.0 X-Mailer: Evolution 2.28.3 (2.28.3-1.fc12) Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201010/325 X-Sequence-Number: 40743 On Wed, 2010-10-20 at 16:45 -0400, Tom Lane wrote: > Hm, what ps options did you use? I'm having a hard time reproducing > your display format on Fedora 13 (procps-3.2.8-7.fc13.x86_64). Sorry, it wasn't a ps output, it was a line from top(1). My to header says: PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 23425 postgres 20 0 22008 10m 10m R 99.9 0.5 21:45.87 postmaster -- Dimi Paun Lattica, Inc.