pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: tv@fuzzy.cz
To: Adarsh Sharma <adarsh.sharma@orkash.com>
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgres Performance Tuning
Date: Mon, 4 Apr 2011 14:28:14 +0200
Message-ID: <8eba9f6568e3f5fe52495e0bf7a2f7b6.squirrel@sq.gransy.com> (raw)
In-Reply-To: <4D99B0B1.4020702@orkash.com>
References: <4D999211.9080507@orkash.com>
	<BANLkTi=ykDDwaAxphKH061Y2aZ1ygnmPEA@mail.gmail.com>
	<BANLkTinONdxh35_0rTdg1L7K=C1KimRUnA@mail.gmail.com>
	<BANLkTin1ss6Sy2PYtbvYPUjz0_A_Uxb5Fg@mail.gmail.com>
	<4D99ACC0.5090009@orkash.com>
	<BANLkTi=irsx4RauJoLbPDRLqy8-MCP7G7g@mail.gmail.com>
	<4D99B0B1.4020702@orkash.com>

>
>
> 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




view thread (22+ messages)  latest in thread

Message-ID: <8eba9f6568e3f5fe52495e0bf7a2f7b6.squirrel@sq.gransy.com>
Permalink:  ../8eba9f6568e3f5fe52495e0bf7a2f7b6.squirrel@sq.gransy.com/
Also on:    postgresql.org/message-id/8eba9f6568e3f5fe52495e0bf7a2f7b6.squirrel@sq.gransy.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: tv@fuzzy.cz, adarsh.sharma@orkash.com, scott.marlowe@gmail.com
  Subject: Re: Postgres Performance Tuning
  In-Reply-To: <8eba9f6568e3f5fe52495e0bf7a2f7b6.squirrel@sq.gransy.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox