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 30FE0D1B8CB for ; Sat, 30 Aug 2003 15:37:22 +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 40687-06 for ; Sat, 30 Aug 2003 12:36:51 -0300 (ADT) Received: from wight.ymogen.net (unknown [217.27.240.153]) by svr1.postgresql.org (Postfix) with SMTP id 02411D1B8B5 for ; Sat, 30 Aug 2003 12:36:41 -0300 (ADT) Received: (qmail 18513 invoked from network); 30 Aug 2003 15:36:11 -0000 Received: from host213-123-217-162.in-addr.btopenworld.com (HELO solent) (213.123.217.162) by wight.ymogen.net with SMTP; 30 Aug 2003 15:36:11 -0000 From: "Matt Clark" To: "Bruce Momjian" Cc: "Ron Johnson" , "PgSQL Performance ML" Subject: Re: Hardware recommendations to scale to silly load Date: Sat, 30 Aug 2003 16:36:20 +0100 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) In-Reply-To: <200308300244.h7U2i4S12751@candle.pha.pa.us> Importance: Normal X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/536 X-Sequence-Number: 3352 > 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? I think Ron asked this, but I will too, is that 4k inserts in one transaction or 4k transactions each with one insert? fsync is very much faster (as are all random writes) with the write-back cache, but I'd hazard a guess that it's still not nearly as fast as turning fsync off altogether. I'll do a test perhaps...