> > > Thanks Scott : > > My iostat package is not installed but have a look on below output: > > [root@s8-mysd-2 8.4SS]# vmstat 10 > procs -----------memory---------- ---swap-- -----io---- --system-- > -----cpu------ > r b swpd free buff cache si so bi bo in cs us sy > id wa st > 1 0 147664 93920 72332 15580748 0 1 113 170 47 177 6 > 1 92 1 0 > 0 0 147664 94020 72348 15580748 0 0 0 4 993 565 0 > 0 100 0 0 > 0 0 147664 93896 72364 15580748 0 0 0 5 993 571 0 > 0 100 0 0 > 0 0 147664 93524 72416 15580860 0 0 0 160 1015 591 0 > 0 100 0 0 > 0 0 147664 93524 72448 15580860 0 0 0 8 1019 553 0 > 0 100 0 0 > 0 0 147664 93648 72448 15580860 0 0 0 0 1019 555 0 > 0 100 0 0 > 0 0 147664 93648 72448 15580860 0 0 0 3 1023 560 0 > 0 100 0 0 Is this from a busy or idle period? I guess it's from an idle one, because the CPU is 100% idle and there's very little I/O activity. That's useless - we need to see vmstat output from period when there's something wrong. > [root@s8-mysd-2 8.4SS]# iostat > -bash: iostat: command not found > [root@s8-mysd-2 8.4SS]# Then install it. Not sure what distro you use, but it's usually packed in sysstat package. Tomas -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
