Re: PG 8.3 and server load

От: Andy Colson
Тема: Re: PG 8.3 and server load
Дата: ,
Msg-id: 4A8C1C27.4000108@squeakycode.net
(см: обсуждение, исходный текст)
Ответ на: Re: PG 8.3 and server load  ("Kevin Grittner")
Ответы: 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, )

Kevin Grittner wrote:
> Andy Colson <> wrote:
>> Phoenix Kiula wrote:
>
>>>>> It's a 2 x Dual Core Intel 5310.
>
>> you have average 74% idle cpu.  So your not cpu bound either?
>
> Or one CPU is pegged and the other three are idle....
>
> -Kevin

Ahh, yeah...

Phoenix:  run top again, and hit the '1' key.  It'll show you stats for
each cpu.  Is one pegged and the others idle?


do a 'cat /proc/cpuinfo' and make sure your os is seeing all your cpus.

-Andy


В списке pgsql-performance по дате сообщения:

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