On Wed, Jun 10, 2009 at 6:19 PM, Kevin
> So, if price were not an option and you had a system that needed to average
> 10K+ inserts per second what HW would you recommend? (Obviously there's mega
> architectural issues here)
This really depends on how it's going to be used. Do these inserts
need to be made to the same exact image to prevent collisions? Can
they go to multiple servers and be aggregated at a later date? Are
you running thousands of inserts in the same transaction? couple? one?
> (Dell PowerEdge 905? , HP Proliant DL700?)
I find their solutions kind of limited and overly expensive in the big db realm.
> Direct Attached Storage:
> (Dell MD3000? HP MSA70?)
Lots of companies make and sell JBOD solutions. Again, I find the big
vendors tend to overcharge for storage boxes.
> RAID/Storage array cards?
Areca 1680ix w/ bbu cache
As many hard drives and controllers as you can afford to throw at it?
In response to
pgsql-admin by date
|Next:||From: Iñigo Martinez Lasala||Date: 2009-06-11 08:47:09|
|Subject: Re: Sobre Actualizacion|
|Previous:||From: Pavel Stehule||Date: 2009-06-11 04:48:57|
|Subject: Re: Different handling of PL/pgSQL for-loop variables in 8.3.7 vs. 8.2.7 ???|