I'm sorry I haven't done any research beforehand, but are any such materials regarding performance tuning available in the canned form on the 'net for me to show to my boss? I believe statements like this will greatly promote PostgreSQL if substantiated with concise "executive summary" articles and maybe some short technical details for administrators. Thank you!
Sergey.
Hans-Jürgen Schönig wrote:
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.
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
