Re: New to PostgreSQL, performance considerations - Mailing list pgsql-performance

From Michael Stone
Subject Re: New to PostgreSQL, performance considerations
Date
Msg-id 20061214152623.GD29167@mathom.us
Whole thread Raw
In response to Re: New to PostgreSQL, performance considerations  (Ron <rjpeace@earthlink.net>)
List pgsql-performance
On Wed, Dec 13, 2006 at 01:03:04PM -0500, Ron wrote:
>What I find interesting is that so far Guido's C2D Mac laptop has
>gotten the highest values by far in this set of experiments, and no
>one else is even close.
>The slowest results, Michael's, are on the system with what appears
>to be the slowest CPU of the bunch; and the ranking of the rest of
>the results seem to similarly depend on relative CPU
>performance.  This is not what one would naively expect when benching
>a IO intensive app like a DBMS.

Note that I ran with fsync off, that the data set is <300M, and that all
of the systems (IIRC) have at least 1G RAM. This is exactly the
distribution I would expect since we're configuring the benchmark to
determine whether cpu-specific optimizations affect the results.

Mike Stone

pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Re: New to PostgreSQL, performance considerations
Next
From: Ron
Date:
Subject: Re: New to PostgreSQL, performance considerations