Scott Marlowe wrote:
I can sustain about 5,000 transactions per second on a machine with 8 cores (2 years old) and 14 15k seagate hard drives.
Right. You can hit 2 to 3000/second with a relatively inexpensive system, so long as you have a battery-backed RAID controller and a few hard drives. Doing 5K writes/second is going to take a giant pile of hard drive or SSDs to pull off. There is no possible way to meet the performance objectives here without a lot more cores in the server and some pretty beefy storage too.
-- Greg Smith 2ndQuadrant US greg@xxxxxxxxxxxxxxx Baltimore, MD PostgreSQL Training, Services and Support www.2ndQuadrant.us "PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
