| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Upgrade questions |
| Date: | 2012-03-14 07:24:49 |
| Message-ID: | 4F6047C1.6000302@hogranch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2012-03-14 07:38:44 | Re: Interesting article, Facebook woes using MySQL |
| Previous Message | Carson Gross | 2012-03-14 03:41:46 | Re: Upgrade questions |