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