Re: Postmaster using only 4-5% CPU

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: Edoardo Serra <osdevel(at)webrainstorm(dot)it>
Cc: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Postmaster using only 4-5% CPU
Date: 2006-03-24 10:16:54
Message-ID: 20060324101654.GQ90527@pervasive.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jim C. Nasby 2006-03-24 10:21:38 Re: Indexes with descending date columns
Previous Message Jim C. Nasby 2006-03-24 10:14:40 Re: Scaling up PostgreSQL in Multiple CPU / Dual Core