Re: Postmaster using only 4-5% CPU - Mailing list pgsql-performance

From Jim C. Nasby
Subject Re: Postmaster using only 4-5% CPU
Date
Msg-id 20060324101654.GQ90527@pervasive.com
Whole thread Raw
In response to Re: Postmaster using only 4-5% CPU  (Edoardo Serra <osdevel@webrainstorm.it>)
Responses Re: Postmaster using only 4-5% CPU  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Scaling up PostgreSQL in Multiple CPU / Dual Core
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Indexes with descending date columns