From: | Matthew Wakeling <matthew(at)flymine(dot)org> |
---|---|
To: | Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com> |
Cc: | Andy Colson <andy(at)squeakycode(dot)net>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: PG 8.3 and server load |
Date: | 2009-08-19 15:37:13 |
Message-ID: | alpine.DEB.2.00.0908191634420.19472@aragorn.flymine.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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?"
From | Date | Subject | |
---|---|---|---|
Next Message | Phoenix Kiula | 2009-08-19 15:40:40 | Re: PG 8.3 and server load |
Previous Message | Andy Colson | 2009-08-19 15:37:11 | Re: PG 8.3 and server load |