Re: PG 8.3 and server load - Mailing list pgsql-performance

From Matthew Wakeling
Subject Re: PG 8.3 and server load
Date
Msg-id alpine.DEB.2.00.0908191634420.19472@aragorn.flymine.org
Whole thread Raw
In response to Re: PG 8.3 and server load  (Phoenix Kiula <phoenix.kiula@gmail.com>)
List pgsql-performance
On Wed, 19 Aug 2009, Phoenix Kiula wrote:
> ~ > vmstat 4
> procs -----------memory---------- ---swap-- -----io---- --system-- ----cpu----
> r  b   swpd   free   buff  cache   si   so    bi    bo   in    cs us sy id wa
> 0  2  16128  35056  62800 7697428    0    0    74   153    0     3 10  5 74 12
> 0  0  16128  38256  62836 7698172    0    0   166   219 1386  1440  7  4 85  4
> 0  1  16128  34704  62872 7698916    0    0   119   314 1441  1589  7  4 85  5
> 0  0  16128  29544  62912 7699396    0    0   142   144 1443  1418  6  3 88  2
> 7  1  16128  26784  62832 7692196    0    0   343   241 1492  1671  8  5 83  4
> 0  0  16128  32840  62880 7693188    0    0   253   215 1459  1511  7  4 85  4
> 0  0  16128  30112  62940 7693908    0    0   187   216 1395  1282  6  3 87  4

As far as I can see from this, your machine isn't very busy at all.

> [MYSITE] ~ > ps ax|grep postgres
> 25302 ?        Ss     0:00 postgres: logger process
> 25352 ?        Ss     0:07 postgres: writer process
> 25353 ?        Ss     4:21 postgres: stats collector process
> 24718 pts/12   S+     0:00 grep postgres

Moreover, Postgres isn't doing anything either.

So, what is the problem that you are seeing? What do you want to change?

Matthew

--
Surely the value of C++ is zero, but C's value is now 1?
  -- map36, commenting on the "No, C++ isn't equal to D. 'C' is undeclared
  [...] C++ should really be called 1" response to "C++ -- shouldn't it
  be called D?"

pgsql-performance by date:

Previous
From: Andy Colson
Date:
Subject: Re: PG 8.3 and server load
Next
From: Phoenix Kiula
Date:
Subject: Re: PG 8.3 and server load