On Wed, Mar 5, 2008 at 3:41 PM, Pavan Deolasee <[EMAIL PROTECTED]> wrote: > > > > Two backends try to vacuum full two different catalog tables. Each acquires > an > exclusive lock on the respective catalog relation. Then each try to > initialize its > own catalog cache. But to do that they need AccessShareLock on each other's > table leading to a deadlock. >
Well I could reproduce the above mentioned deadlock scenario with two system relations. So that validates the theory. Thanks, Pavan -- Pavan Deolasee EnterpriseDB http://www.enterprisedb.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-hackers