Kevin Brown <[EMAIL PROTECTED]> writes: > When a heavy INSERT or UPDATE load on a table is occurring (lots of > quick INSERTs or UPDATEs within a single transaction), a VACUUM > ANALYZE (or just straight VACUUM) has a really good chance (10% or so) > of causing either the INSERT/UPDATE or the VACUUM to fail with a > "deadlock detected" error.
I was unable to replicate this in CVS tip, using "pgbench -c 10 -t 1000" as the load generator. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])