Re: postgres performance tunning

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@2ndQuadrant.com   Baltimore, MD
PostgreSQL Training, Services and Support        www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books