Re: Postgres Performance Tuning - Mailing list pgsql-performance

From tv@fuzzy.cz
Subject Re: Postgres Performance Tuning
Date
Msg-id 8eba9f6568e3f5fe52495e0bf7a2f7b6.squirrel@sq.gransy.com
Whole thread Raw
In response to Re: Postgres Performance Tuning  (Adarsh Sharma <adarsh.sharma@orkash.com>)
List pgsql-performance
>
>
> 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


pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Postgres Performance Tuning
Next
From: Adarsh Sharma
Date:
Subject: Re: Postgres Performance Tuning