Re: PG 8.3 and server load

От: Matthew Wakeling
Тема: Re: PG 8.3 and server load
Дата: ,
Msg-id: alpine.DEB.2.00.0908191634420.19472@aragorn.flymine.org
(см: обсуждение, исходный текст)
Ответ на: Re: PG 8.3 and server load  (Phoenix Kiula)
Список: pgsql-performance

Скрыть дерево обсуждения

PG 8.3 and server load  (Phoenix Kiula, )
 Re: PG 8.3 and server load  (Ivan Voras, )
  Re: PG 8.3 and server load  (Guillaume Cottenceau, )
 Re: PG 8.3 and server load  (Andy Colson, )
  Re: PG 8.3 and server load  (Karl Denninger, )
 Re: PG 8.3 and server load  (Andy Colson, )
  Re: PG 8.3 and server load  (Phoenix Kiula, )
   Re: PG 8.3 and server load  (Matthew Wakeling, )
  Re: PG 8.3 and server load  ("Kevin Grittner", )
   Re: PG 8.3 and server load  (Andy Colson, )
    Re: PG 8.3 and server load  (Phoenix Kiula, )
     Re: PG 8.3 and server load  (Andy Colson, )
     Re: PG 8.3 and server load  (Tom Lane, )
     Re: PG 8.3 and server load  (Guillaume Cottenceau, )
     Re: PG 8.3 and server load  (Scott Marlowe, )
      Re: PG 8.3 and server load  (Ivan Voras, )

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 по дате сообщения:

От: Kevin Kempter
Дата:
Сообщение: Re: Query tuning
От: Jaime Casanova
Дата:
Сообщение: [PERFORMANCE] how to set wal_buffers