Re: REINDEX deadlock - Postgresql -9.1 - Mailing list pgsql-general

From Scott Marlowe
Subject Re: REINDEX deadlock - Postgresql -9.1
Date
Msg-id CAOR=d=28uL9o1OB=uUMn_2j1s5fG0N2xUJe=qb=J6Zei==9-kw@mail.gmail.com
Whole thread Raw
In response to Re: REINDEX deadlock - Postgresql -9.1  (Anoop K <anoopk6@gmail.com>)
List pgsql-general
Note that if those processes use persistent connections you'll need to
restart them to free up the connections.  In the meantime you can use
the step of renaming your superuser account.  Then cutting all
superuser conns and turning off superuser of postgres user
temporarily.  I wouldn't do this all night or anything, as autovac
usually connects as postgres to do its thing.

pgsql-general by date:

Previous
From: Anoop K
Date:
Subject: Re: REINDEX deadlock - Postgresql -9.1
Next
From: Thomas Kellerer
Date:
Subject: Re: feature requests (possibly interested in working on this): functional foreign keys