Re: Postgres Performance Tuning - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Postgres Performance Tuning
Date
Msg-id BANLkTimKEM9jVFPnSEBWd4R7T7vcrnjBRw@mail.gmail.com
Whole thread Raw
In response to Re: Postgres Performance Tuning  (Adarsh Sharma <adarsh.sharma@orkash.com>)
List pgsql-performance
On Mon, Apr 4, 2011 at 5:51 AM, Adarsh Sharma <adarsh.sharma@orkash.com> 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.

pgsql-performance by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: Postgres Performance Tuning
Next
From: tv@fuzzy.cz
Date:
Subject: Re: Postgres Performance Tuning