This week I have done some performance tuning at a customer's office. We have beaten (demoralized) MS SQL and DB2 in serializable mode and DB2 in any transaction isolation level :).

By the way: In case of very simple statements SERIALIZABLE is about 3 times faster than READ COMMITTED. I expected it to be faster but I did not expect this difference.

We have used Peter's fix which makes it possible to compile PostgreSQL with Intel's C compiler. PostgreSQL built nicely (just some nasty warnings). We have tries to run our benchmark (mostly simple statements and cursor work) on this version of PostgreSQL but the database cluster corrupted almost instantly. Although PostgreSQL compiled nicely we could not get the system running without corrupting something.
Maybe this behaviour should be varified by somebody else and documented somewhere (maybe a FAQ?).


Regards,

Hans

--
Cybertec Geschwinde u Schoenig
Ludo-Hartmannplatz 1/14, A-1160 Vienna, Austria
Tel: +43/2952/30706; +43/664/233 90 75
www.cybertec.at, www.postgresql.at, kernel.cybertec.at



---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Reply via email to