On Wed, Jun 10, 2009 at 6:19 PM, Kevin Kempter<kevink@xxxxxxxxxxxxxxxxxxx> wrote: > 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? > Server? > (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 > Other? As many hard drives and controllers as you can afford to throw at it? -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
