Re: Postgres Performance Tuning

>
>
> Thanks Scott :
>
> My iostat package is not installed but have a look on below output:
>
> [root(at)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(at)s8-mysd-2 8.4SS]# iostat
> -bash: iostat: command not found
> [root(at)s8-mysd-2 8.4SS]#

Then install it. Not sure what distro you use, but it's usually packed in
sysstat package.

Tomas