From: David Kerr <dmk@mr-paradox.net>
To: Greg Smith <gsmith@gregsmith.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: Question on pgbench output
Date: Sat, 4 Apr 2009 21:06:11 -0700
Message-ID: <20090405040611.GA27947@mr-paradox.net> (raw)
In-Reply-To: <alpine.GSO.2.01.0904032228180.25708@westnet.com>
References: <20090403195302.GA54342@mr-paradox.net>
<alpine.GSO.2.01.0904031721570.5502@westnet.com>
<24809.1238799146@sss.pgh.pa.us>
<alpine.GSO.2.01.0904032228180.25708@westnet.com>
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
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: dmk@mr-paradox.net, gsmith@gregsmith.com, tgl@sss.pgh.pa.us
Subject: Re: Question on pgbench output
In-Reply-To: <20090405040611.GA27947@mr-paradox.net>
* 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