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

From Guido Neitzer
Subject Re: New to PostgreSQL, performance considerations
Date
Msg-id 77709BF0-A6C3-4C07-BD57-3131BB51BD42@event-s.net
Whole thread Raw
In response to Re: New to PostgreSQL, performance considerations  (Michael Stone <mstone+postgres@mathom.us>)
List pgsql-performance
On 12.12.2006, at 02:37, Michael Stone wrote:

> Can anyone else reproduce these results? I'm on similar hardware
> (2.5GHz P4, 1.5G RAM) and my test results are more like this:

I'm on totally different hardware / software (MacBook Pro 2.33GHz
C2D) and I can't reproduce the tests.

I have played with a lot of settings in the CFLAGS including -march
and -O3 and -O2 - there is no significant difference in the tests.

With fsync=off I get around 2100tps on average with all different
settings I have tested. I tried to get the rest of the setup as
similar to the described on ty Daniel as possible. It might be that
the crappy Pentium 4 needs some special handling, but I can't get the
Core 2 Duo in my laptop produce different tps numbers with the
different optimizations.

Btw: best results were 2147 with -march=i686 and 2137 with -
march=nocona. Both with -O3.

cug

pgsql-performance by date:

Previous
From: "Axel Waggershauser"
Date:
Subject: Re: Low throughput of binary inserts from windows to linux
Next
From: Alexander Staubo
Date:
Subject: Re: New to PostgreSQL, performance considerations