Re: Upgrade questions

On 03/13/12 8:41 PM, Carson Gross wrote:
> Does anyone have a reasonable guess as to the inserts per second 
> postgres is capable of these days on middle-of-the-road hardware?  Any 
> order of magnitude would be fine: 10, 100, 1000, 10,000.

my dedicated database server in my lab, which is a 2U dual Xeon X5660 
box with 12 cores at 2.8ghz, 48GB ram, and 20 15000rpm SAS drives in a 
RAID10 with a 1GB flash-cached raid card, can pretty easily sustain 6000 
or more writes/second given enough threads doing the work, although 
indexes, and/or large rows would slow that down.    a single 
connection/thread will not get that much throughput.

thats my definition of a middle of the road database server.  I have no 
idea what yours is.


-- 
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast