Skip site navigation (1) Skip section navigation (2)

Re: Hardware recommendations to scale to silly load

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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

In response to

Responses

pgsql-performance by date

Next:From: Bruno Wolff IIIDate: 2003-08-30 02:55:03
Subject: Re: bad estimates
Previous:From: Bruce MomjianDate: 2003-08-30 02:34:34
Subject: Re: The results of my PostgreSQL/filesystem performance tests

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2003-08-30 02:58:50
Subject: Re: Beta2 Tag'd and Bundled ...
Previous:From: John BattlesDate: 2003-08-30 01:40:09
Subject: pgadmin3-0.9.1 wxwindows build woes utils/misc.cpp:389: error: no matching function for call to `wxMBConv::MB2WC

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group