Re: High CPU Utilization

From: Ron
Subject: Re: High CPU Utilization
Date: ,
Msg-id: E1LmFZX-0006RF-Tt@elasmtp-curtail.atl.sa.earthlink.net
(view: Whole thread, Raw)
In response to: Re: High CPU Utilization  (Joe Uhl)
Responses: Re: High CPU Utilization  (Scott Marlowe)
List: pgsql-performance

Tree view

High CPU Utilization  (Joe Uhl, )
 Re: High CPU Utilization  (Alan Hodgson, )
  Re: High CPU Utilization  (Joe Uhl, )
   Re: High CPU Utilization  (Greg Smith, )
    Re: High CPU Utilization  (Joe Uhl, )
     Re: High CPU Utilization  (Scott Marlowe, )
     Re: High CPU Utilization  (Greg Smith, )
    Re: High CPU Utilization  (Gregory Stark, )
     Re: High CPU Utilization  (Greg Smith, )
      Re: High CPU Utilization  (Joe Uhl, )
       Re: High CPU Utilization  (Scott Marlowe, )
        Re: High CPU Utilization  (Joe Uhl, )
         Re: High CPU Utilization  (Scott Marlowe, )
          Re: High CPU Utilization  (Joe Uhl, )
          Re: High CPU Utilization  (Joe Uhl, )
           Re: High CPU Utilization  (Greg Smith, )
            Re: High CPU Utilization  (Scott Marlowe, )
           Re: High CPU Utilization  (Ron, )
            Re: High CPU Utilization  (Scott Marlowe, )
             Re: High CPU Utilization  (Scott Carey, )

At 02:47 PM 3/24/2009, Joe Uhl wrote:

>Turns out we may have an opportunity to purchase a new database
>server with this increased load.  Seems that the best route, based
>on feedback to this thread, is to go whitebox, get quad opterons,
>and get a very good disk controller.
>
>Can anyone recommend a whitebox vendor?
I'll 2nd the Aberdeen recommendation.  I'll add Pogolinux to that list as well.


>Is there a current controller anyone on this list has experience
>with that they could recommend?
The 2 best performing RAID controller vendors at this time are AMCC
(AKA 3Ware) and Areca.
In general, the 8+ port Areca's with their BB cache maxed outperform
every other controller available.


>This will be a bigger purchase so will be doing research and
>benchmarking but any general pointers to a vendor/controller greatly
>appreciated.

Be =very= careful to thoroughly bench both the AMD and Intel CPU
options.  It is far from clear which is the better purchase.

I'd be very interested to see the results of your research and
benchmarks posted here on pgsql-performance.

Ron Peacetree



pgsql-performance by date:

From: Mark Kirkwood
Date:
Subject: Re: Raid 10 chunksize
From: Greg Smith
Date:
Subject: Re: Raid 10 chunksize