Received: from localhost (maia-2.hub.org [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id D993F9FA430
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 13 Dec 2006 12:13:38 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024)
	with ESMTP id 29896-03 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 13 Dec 2006 12:13:31 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from ebrsrv01.ebravo.it (unknown [85.34.205.53])
	by postgresql.org (Postfix) with ESMTP id 9F4479FA311
	for <pgsql-performance@postgresql.org>;
	Wed, 13 Dec 2006 12:13:30 -0400 (AST)
Received: from [192.168.11.103] ([192.168.11.103])
	by ebrsrv01.ebravo.it (8.11.6/8.12.5) with ESMTP id kBDGC2D12928;
	Wed, 13 Dec 2006 17:12:43 +0100
Message-ID: <4580264F.8030109@streppone.it>
Date: Wed, 13 Dec 2006 17:11:59 +0100
From: Cosimo Streppone <cosimo@streppone.it>
User-Agent: Mozilla Thunderbird 1.5 (X11/20051201)
MIME-Version: 1.0
To: Postgresql Performance list <pgsql-performance@postgresql.org>
CC: Michael Stone <mstone+postgres@mathom.us>
Subject: Re: New to PostgreSQL, performance considerations
References: <C1A31C39.15548%llonergan@greenplum.com>
	<457EA39E.1020207@streppone.it> <20061212124803.GA29167@mathom.us>
In-Reply-To: <20061212124803.GA29167@mathom.us>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200612/322
X-Sequence-Number: 22378

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