From: Cosimo Streppone <cosimo@streppone.it>
To: Postgresql Performance list <pgsql-performance@postgresql.org>
Cc: Michael Stone <mstone+postgres@mathom.us>
Subject: Re: New to PostgreSQL, performance considerations
Date: Wed, 13 Dec 2006 17:11:59 +0100
Message-ID: <4580264F.8030109@streppone.it> (raw)
In-Reply-To: <20061212124803.GA29167@mathom.us>
References: <C1A31C39.15548%llonergan@greenplum.com>
<457EA39E.1020207@streppone.it>
<20061212124803.GA29167@mathom.us>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: cosimo@streppone.it, mstone+postgres@mathom.us
Subject: Re: New to PostgreSQL, performance considerations
In-Reply-To: <4580264F.8030109@streppone.it>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox