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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
