"Alvaro Herrera" <[EMAIL PROTECTED]> writes: > Hmm, it looks like the race condition Heikki mentioned is the culprit. > We need a way to stop future analyzes from starting. Back to the > drawing board ...
A crazy idea I just had -- what if you roll this into the deadlock check? So after waiting on the lock for 1s it wakes up, finds that the holder it's waiting on is an autovacuum process and cancels it instead of finding no deadlock. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate