From: | Cosimo Streppone <cosimo(at)streppone(dot)it> |
---|---|
To: | Postgresql Performance list <pgsql-performance(at)postgresql(dot)org> |
Cc: | Michael Stone <mstone+postgres(at)mathom(dot)us> |
Subject: | Re: New to PostgreSQL, performance considerations |
Date: | 2006-12-13 16:11:59 |
Message-ID: | 4580264F.8030109@streppone.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | asif ali | 2006-12-13 16:43:57 | Re: Slow update with simple query |
Previous Message | Arnaud Lesauvage | 2006-12-13 15:19:55 | Re: Slow update with simple query |