Re: PG 8.3 and server load

From: Andy Colson
Subject: Re: PG 8.3 and server load
Date: ,
Msg-id: 4A8C1C27.4000108@squeakycode.net
(view: Whole thread, Raw)
In response to: Re: PG 8.3 and server load  ("Kevin Grittner")
Responses: Re: PG 8.3 and server load  (Phoenix Kiula)
List: pgsql-performance

Tree view

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 by date:

From: Kevin Kempter
Date:
Subject: Re: Query tuning
From: Jaime Casanova
Date:
Subject: [PERFORMANCE] how to set wal_buffers