Re: Question on pgbench output

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