pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Greg Smith <gsmith@gregsmith.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: David Kerr <dmk@mr-paradox.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: Question on pgbench output
Date: Fri, 3 Apr 2009 22:35:58 -0400 (EDT)
Message-ID: <alpine.GSO.2.01.0904032228180.25708@westnet.com> (raw)
In-Reply-To: <24809.1238799146@sss.pgh.pa.us>
References: <20090403195302.GA54342@mr-paradox.net>
	<alpine.GSO.2.01.0904031721570.5502@westnet.com>
	<24809.1238799146@sss.pgh.pa.us>

On Fri, 3 Apr 2009, Tom Lane wrote:

> However, I don't think anyone else has been pgbench'ing transactions
> where client-side libpq has to absorb (and then discard) a megabyte of
> data per xact.  I wouldn't be surprised that that eats enough CPU to
> make it an issue.  David, did you pay any attention to how busy the
> pgbench process was?

I certainly haven't ever tried that.  David, the thing you want to do here 
is run "top -c" when pgbench is going.  You should see the pgbench process 
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.

You can even automate collection of that with something like this:

top -b -d 10 -c -n 10000 > top.log &
TOPPID=$!
(run test)
kill $TOPPID

That will save a snapshot every 10 seconds of what's happening during your 
test.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD



view thread (15+ messages)  latest in thread

Message-ID: <alpine.GSO.2.01.0904032228180.25708@westnet.com>
Permalink:  ../alpine.GSO.2.01.0904032228180.25708@westnet.com/
Also on:    postgresql.org/message-id/alpine.GSO.2.01.0904032228180.25708@westnet.com

 · 

reply
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: gsmith@gregsmith.com, tgl@sss.pgh.pa.us, dmk@mr-paradox.net
  Subject: Re: Question on pgbench output
  In-Reply-To: <alpine.GSO.2.01.0904032228180.25708@westnet.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