| From: | Guido Neitzer <lists(at)event-s(dot)net> |
|---|---|
| To: | Michael Stone <mstone+postgres(at)mathom(dot)us> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: New to PostgreSQL, performance considerations |
| Date: | 2006-12-12 10:34:10 |
| Message-ID: | 77709BF0-A6C3-4C07-BD57-3131BB51BD42@event-s.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexander Staubo | 2006-12-12 11:29:29 | Re: New to PostgreSQL, performance considerations |
| Previous Message | Axel Waggershauser | 2006-12-12 10:18:58 | Re: Low throughput of binary inserts from windows to linux |