Tom Lane wrote: > Gregory Stark <[EMAIL PROTECTED]> writes: > > I think there's a window where the process waiting directly on > > autovacuum could have already fired its deadlock check before it was > > waiting directly on autovacuum. > > I think you don't understand what that code is doing. If there's an > autovac anywhere in the dependency graph, it'll find it.
Thanks for making that explicit, I was trying to build a test case where it would lock :-) (If we had concurrent psql we could even have it in the regression tests ...) -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
