If you cannot make your transactons shorter (and
please don't tell me that you have user interaction going on while
holding any open transactions), then you might be able to increase
your concurrency by deferring the foreign key check until commit.
oh! my! gawd!!! THANK YOU! The deferred foreign key checks are exactly what I needed. They are quite useful for other reasons too. I think that should be the default for foreign
The way it is is the way it is defined by the standard.
Jan
-- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== [EMAIL PROTECTED] #
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
