I'm observing that when I have many processes doing some work on my system that the transactions run along almost in lockstep. It appears from messages posted here that the foreign keys are acquiring and holding locks during the transactions, which seems like it would cause this behavior.
I'd like to experiment with deferred foreign key checks so that the lock is only held during the commit when the checks are done. My questions are: 1) can I, and if so, how do I convert my existing FK's to deferrable without drop/create of the keys. Some of the keys take a long time to create and I'd like to avoid the hit. 2) do I increase the liklihood of deadlocks when the FK locks are being acquired or is it just as likeley as with the current non-deferred checking? I'm running 7.4 (soon to be 7.4.1) -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D. Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-301-869-4449 x806 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
