Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id B2C5063252F for ; Sun, 5 Apr 2009 01:06:14 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 08561-10 for ; Sun, 5 Apr 2009 01:06:13 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from vexbert.mr-paradox.net (vexbert.mr-paradox.net [198.145.180.174]) by mail.postgresql.org (Postfix) with ESMTP id 5442A6324C2 for ; Sun, 5 Apr 2009 01:06:13 -0300 (ADT) Received: by vexbert.mr-paradox.net (Postfix, from userid 18391) id 2B54C84531; Sun, 5 Apr 2009 00:06:11 -0400 (EDT) Date: Sat, 4 Apr 2009 21:06:11 -0700 From: David Kerr To: Greg Smith Cc: Tom Lane , pgsql-performance@postgresql.org Subject: Re: Question on pgbench output Message-ID: <20090405040611.GA27947@mr-paradox.net> References: <20090403195302.GA54342@mr-paradox.net> <24809.1238799146@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.4.2.3i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200904/102 X-Sequence-Number: 33469 On Fri, Apr 03, 2009 at 10:35:58PM -0400, Greg Smith wrote: - On Fri, 3 Apr 2009, Tom Lane wrote: - - and a bunch of postmaster ones, with "-c" (or by hitting "c" while top is - running) you can even see what they're all doing. If the pgbench process - is consuming close to 100% of a CPU's time, that means the results it's - giving are not valid--what you're seeing in that case are the limitations - of the testing program instead. Looks pretty good to me. not too much mem or CPU. PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 4241 postgres 20 0 9936 2652 1680 S 0 0.1 0:00.02 pgbench 4241 postgres 20 0 22948 10m 1708 R 4 0.3 0:00.46 pgbench 4241 postgres 20 0 26628 14m 1708 R 5 0.3 0:00.96 pgbench 4241 postgres 20 0 29160 15m 1708 R 5 0.4 0:01.44 pgbench 4241 postgres 20 0 30888 16m 1708 R 4 0.4 0:01.86 pgbench 4241 postgres 20 0 31624 17m 1708 R 5 0.4 0:02.34 pgbench 4241 postgres 20 0 32552 18m 1708 R 5 0.5 0:02.82 pgbench 4241 postgres 20 0 33160 18m 1708 R 5 0.5 0:03.28 pgbench 4241 postgres 20 0 33608 18m 1708 R 4 0.5 0:03.70 pgbench 4241 postgres 20 0 34056 19m 1708 R 4 0.5 0:04.08 pgbench 4241 postgres 20 0 34056 19m 1708 R 4 0.5 0:04.52 pgbench 4241 postgres 20 0 34376 19m 1708 R 4 0.5 0:04.98 pgbench 4241 postgres 20 0 34536 19m 1708 R 4 0.5 0:05.42 pgbench 4241 postgres 20 0 34536 19m 1708 R 5 0.5 0:05.88 pgbench 4241 postgres 20 0 34664 19m 1708 R 5 0.5 0:06.34 pgbench 4241 postgres 20 0 34664 19m 1708 R 5 0.5 0:06.82 pgbench 4241 postgres 20 0 34664 19m 1708 R 4 0.5 0:07.26 pgbench 4241 postgres 20 0 34664 20m 1708 R 4 0.5 0:07.72 pgbench 4241 postgres 20 0 34664 20m 1708 R 4 0.5 0:08.12 pgbench Dave