On Thu, Jan 6, 2011 at 2:41 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote: > On Thu, Jan 6, 2011 at 2:31 PM, Robert Haas <robertmhaas@xxxxxxxxx> wrote: >> On Mon, Dec 20, 2010 at 12:49 PM, Greg Smith <greg@xxxxxxxxxxxxxxx> wrote: >>> 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. >> >> Is this with synchronous_commit on, or off? > > Off. It doesn't seem to make a lot of difference one you're running > on a good battery backed caching RAID controller. Sorry, that's ON not OFF. Turning it off doesn't seem to ... -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
