> Could you try this again with "top -c", which will label these
> postmaster processes usefully, and include the pgbench client itself in
> what you post? It's hard to sort out what's going on in these
> situations without that style of breakdown.
I had run pgbench on a separate instance last time, but this time I ran it on
the same machine. With the -c option, top(1) reports that many of the postgres
processes are idle.
top - 18:25:23 up 8 min, 2 users, load average: 1.52, 1.32, 0.55
Tasks: 218 total, 15 running, 203 sleeping, 0 stopped, 0 zombie
Cpu(s): 32.3%us, 17.5%sy, 0.0%ni, 49.6%id, 0.0%wa, 0.0%hi, 0.0%si, 0.6%st
Mem: 7358492k total, 1620500k used, 5737992k free, 11144k buffers
Swap: 0k total, 0k used, 0k free, 1248388k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1323 postgres 20 0 50364 2192 1544 R 56.7 0.0 0:03.19 pgbench -S -c 16 -T
30
1337 postgres 20 0 197m 114m 112m R 25.4 1.6 0:01.35 postgres: postgres
postgres [local] SELECT
1331 postgres 20 0 197m 113m 111m R 24.4 1.6 0:01.16 postgres: postgres
postgres [local] idle
1335 postgres 20 0 197m 114m 112m R 24.1 1.6 0:01.30 postgres: postgres
postgres [local] SELECT
1340 postgres 20 0 197m 113m 112m R 22.7 1.6 0:01.28 postgres: postgres
postgres [local] idle
1327 postgres 20 0 197m 114m 113m R 22.1 1.6 0:01.26 postgres: postgres
postgres [local] idle
1328 postgres 20 0 197m 114m 113m R 21.8 1.6 0:01.32 postgres: postgres
postgres [local] SELECT
1332 postgres 20 0 197m 114m 112m R 21.8 1.6 0:01.11 postgres: postgres
postgres [local] SELECT
1326 postgres 20 0 197m 112m 110m R 21.4 1.6 0:01.10 postgres: postgres
postgres [local] idle
1325 postgres 20 0 197m 112m 110m R 20.8 1.6 0:01.28 postgres: postgres
postgres [local] SELECT
1330 postgres 20 0 197m 113m 111m R 20.4 1.6 0:01.21 postgres: postgres
postgres [local] idle
1339 postgres 20 0 197m 113m 111m R 20.4 1.6 0:01.10 postgres: postgres
postgres [local] idle
1333 postgres 20 0 197m 114m 112m S 20.1 1.6 0:01.08 postgres: postgres
postgres [local] SELECT
1336 postgres 20 0 197m 113m 111m S 19.8 1.6 0:01.10 postgres: postgres
postgres [local] SELECT
1329 postgres 20 0 197m 113m 111m S 19.1 1.6 0:01.21 postgres: postgres
postgres [local] idle
1338 postgres 20 0 197m 114m 112m R 19.1 1.6 0:01.28 postgres: postgres
postgres [local] SELECT
1334 postgres 20 0 197m 114m 112m R 18.8 1.6 0:01.00 postgres: postgres
postgres [local] idle
1214 root 20 0 14900 1348 944 R 0.3 0.0 0:00.41 top -c
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
