| From: | Greg Smith <greg(at)2ndquadrant(dot)com> |
|---|---|
| To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
| Cc: | selvi88 <selvi(dot)dct(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: postgres performance tunning |
| Date: | 2010-12-20 17:49:16 |
| Message-ID: | 4D0F971C.8040309@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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(at)2ndQuadrant(dot)com Baltimore, MD
PostgreSQL Training, Services and Support www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeremy Harris | 2010-12-20 17:59:42 | Re: CPU bound |
| Previous Message | Scott Marlowe | 2010-12-20 17:26:56 | Re: postgres performance tunning |