| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | matt <matt(at)ymogen(dot)net> |
| Cc: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>, PgSQL Performance ML <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Hardware recommendations to scale to silly load |
| Date: | 2003-08-30 02:44:04 |
| Message-ID: | 200308300244.h7U2i4S12751@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
matt wrote:
> > Are you *sure* about that???? 3K updates/inserts per second xlates
> > to 10,800,000 per hour. That, my friend, is a WHOLE HECK OF A LOT!
>
> Yup, I know!
Just a data point, but on my Dual Xeon 2.4Gig machine with a 10k SCSI
drive I can do 4k inserts/second if I turn fsync off. If you have a
battery-backed controller, you should be able to do the same. (You will
not need to turn fsync off --- fsync will just be fast because of the
disk drive RAM).
Am I missing something?
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2003-08-30 02:58:50 | Re: Beta2 Tag'd and Bundled ... |
| Previous Message | John Battles | 2003-08-30 01:40:09 | pgadmin3-0.9.1 wxwindows build woes utils/misc.cpp:389: error: no matching function for call to `wxMBConv::MB2WC |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2003-08-30 02:55:03 | Re: bad estimates |
| Previous Message | Bruce Momjian | 2003-08-30 02:34:34 | Re: The results of my PostgreSQL/filesystem performance tests |