X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id A9682D1B52C for ; Sat, 30 Aug 2003 05:21:51 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 01827-05 for ; Sat, 30 Aug 2003 02:21:21 -0300 (ADT) Received: from lakemtao03.cox.net (lakemtao03.cox.net [68.1.17.242]) by svr1.postgresql.org (Postfix) with ESMTP id C53E8D1B93F for ; Sat, 30 Aug 2003 02:21:17 -0300 (ADT) Received: from lhosts ([68.11.66.83]) by lakemtao03.cox.net (InterMail vM.5.01.06.04 201-253-122-130-104-20030726) with ESMTP id <20030830052118.XIFK10977.lakemtao03.cox.net@lhosts> for ; Sat, 30 Aug 2003 01:21:18 -0400 Subject: Re: Hardware recommendations to scale to silly load From: Ron Johnson To: PgSQL Performance ML In-Reply-To: <200308300244.h7U2i4S12751@candle.pha.pa.us> References: <200308300244.h7U2i4S12751@candle.pha.pa.us> Content-Type: text/plain Message-Id: <1062220877.669.406.camel@haggis> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.4 Date: Sat, 30 Aug 2003 00:21:17 -0500 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/522 X-Sequence-Number: 3338 On Fri, 2003-08-29 at 21:44, Bruce Momjian wrote: > 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? Is that FOR I BETWEEN 1 AND 4000 BEGIN INSERT COMMIT or BEGIN INSERT INSERT COMMIT; or COPY I get the impression that Matt will need to do 25,000 of these per hour: SELECT IF BEGIN INSERT or UPDATE COMMIT; He says his current h/w peaks at 1/10th that rate. My question is: is that current peak rate ("300 inserts/updates *or* 2500 selects") based upon 1 connection, or many connections? With 4 CPUs, and a 4 disk RAID10, I wouldn't be surprised if 4 con- current connections gives the optimum speed. -- ----------------------------------------------------------------- Ron Johnson, Jr. ron.l.johnson@cox.net Jefferson, LA USA Great Inventors of our time: Al Gore -> Internet Sun Microsystems -> Clusters