X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id E7ADC9DC83F for ; Fri, 24 Mar 2006 06:16:54 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 69050-09 for ; Fri, 24 Mar 2006 06:16:56 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id A5ECB9DC82F for ; Fri, 24 Mar 2006 06:16:52 -0400 (AST) Received: by noel.decibel.org (Postfix, from userid 1001) id 3B7D156435; Fri, 24 Mar 2006 04:16:55 -0600 (CST) Received: (hashcash-sendmail, from uid 1001); Fri, 24 Mar 2006 04:16:54 -0600 Date: Fri, 24 Mar 2006 04:16:54 -0600 From: "Jim C. Nasby" To: Edoardo Serra Cc: Scott Marlowe , pgsql-performance@postgresql.org Subject: Re: Postmaster using only 4-5% CPU Message-ID: <20060324101654.GQ90527@pervasive.com> References: <7.0.0.16.2.20060321115738.060f9078@webrainstorm.it> <1142963080.17883.193.camel@state.g2switchworks.com> <7.0.0.16.2.20060322120000.0796c930@webrainstorm.it> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <7.0.0.16.2.20060322120000.0796c930@webrainstorm.it> X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060324:osdevel@webrainstorm.it::VJdPaCoWOfeNeLkg:00000000000000 0000000000000000000000000Xrw X-Hashcash: 1:20:060324:smarlowe@g2switchworks.com::HGftchYcBNt0XYWY:00000000000 0000000000000000000000008GkH X-Hashcash: 1:20:060324:pgsql-performance@postgresql.org::fOuJX/9eR1vlKjmM:00000 0000000000000000000000000SHU X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.108 required=5 tests=[AWL=0.108] X-Spam-Score: 0.108 X-Spam-Level: X-Archive-Number: 200603/483 X-Sequence-Number: 17920 On Thu, Mar 23, 2006 at 10:14:24AM +0100, Edoardo Serra wrote: > >Now, for the interesting test. Run the import on both machines, with > >the begin; commit; pairs around it. Halfway through the import, pull > >the power cord, and see which one comes back up. Don't do this to > >servers with data you like, only test machines, obviously. For an even > >more interesting test, do this with MySQL, Oracle, DB2, etc... > > I will surely run a test like this ;) If you do, I'd be *very* interested in the results. Pervasive would probably pay for a whitepaper about this, btw (see http://www.pervasivepostgres.com/postgresql/partners_in_publishing.asp). -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461