| From: | Florian Weimer <fweimer(at)bfk(dot)de> |
|---|---|
| To: | Cosimo Streppone <cosimo(at)streppone(dot)it> |
| Cc: | Postgresql Performance list <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: New to PostgreSQL, performance considerations |
| Date: | 2006-12-12 15:17:27 |
| Message-ID: | 82psapuos8.fsf@mid.bfk.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
* Cosimo Streppone:
> "-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
-mcpu and -mtune are synonymous. You really should -march here (but
the result is non-generic code). Keep in mind that GCC does not
contain an instruction scheduler for the Pentium 4s. I also believe
that the GCC switches are not fine-grained enough to cover the various
Pentium 4 variants. For instance, some chips don't like the CMOV
instruction at all, but others can process it with decent speed.
--
Florian Weimer <fweimer(at)bfk(dot)de>
BFK edv-consulting GmbH http://www.bfk.de/
Kriegsstraße 100 tel: +49-721-96201-1
D-76133 Karlsruhe fax: +49-721-96201-99
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bill Moran | 2006-12-12 15:26:10 | Re: New to PostgreSQL, performance considerations |
| Previous Message | Ron | 2006-12-12 15:13:14 | Re: New to PostgreSQL, performance considerations |