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

From Cosimo Streppone
Subject Re: New to PostgreSQL, performance considerations
Date
Msg-id 4580264F.8030109@streppone.it
Whole thread Raw
In response to Re: New to PostgreSQL, performance considerations  (Michael Stone <mstone+postgres@mathom.us>)
Responses Re: New to PostgreSQL, performance considerations  (Ron <rjpeace@earthlink.net>)
List pgsql-performance
Michael Stone wrote:

> On Tue, Dec 12, 2006 at 01:42:06PM +0100, Cosimo Streppone wrote:
>> "-O0" ~ 957 tps
>> "-O1 -mcpu=pentium4 -mtune=pentium4" ~ 1186 tps
>> "-O2 -mcpu=pentium4 -mtune=pentium4" ~ 1229 tps
>> "-O3 -mcpu=pentium4 -mtune=pentium4" ~ 1257 tps
>> "-O6 -mcpu=pentium4 -mtune=pentium4" ~ 1254 tps
>>
>> I'm curious now to get the same tests run with
>> a custom-cflags-compiled glibc.
>
> I'd be curious to see -O2 with and without the arch-specific flags,
> since that's mostly what the discussion is about.

I run the same tests only for:

1) '-O2'
2) '-O2 -march=pentium4 -mtune=pentium4 -mcpu=pentium4'
    (so no more doubts here, and thanks for gcc hints :-)

and I obtained respectively an average of 1238 (plain -O2)
vs. 1229 tps on 9 runs.
Disk subsystem is a standard desktop SATA, no more than that.

I tried also recompiling *only* pgbench with various options, but as
I expected (and hoped) nothing changed.

Interesting, eh?

--
Cosimo


pgsql-performance by date:

Previous
From: Arnaud Lesauvage
Date:
Subject: Re: Slow update with simple query
Next
From: asif ali
Date:
Subject: Re: Slow update with simple query