On Mon, Apr 4, 2011 at 5:51 AM, Adarsh Sharma <adarsh.sharma@xxxxxxxxxx> wrote: > > > 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 OK, right now your machine is at idle. Run vmstat / iostat when it's under load. If the wa column stays low, then you're not IO bound but more than likely CPU bound. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
