Postgres Pro
Downloads
Home   >   mailing lists

Re: Autovacuum deadlock - bug or not? - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Autovacuum deadlock - bug or not?
Date
Msg-id 25956.1132239070@sss.pgh.pa.us
Whole thread Raw
In response to Autovacuum deadlock - bug or not?  ("Mikael Carneholm" <Mikael.Carneholm@WirelessCar.com>)
List pgsql-bugs
Tree view 
"Mikael Carneholm" <Mikael.Carneholm@WirelessCar.com> writes:
> Don't know if this is a bug or just undocumented, but it seems as you should turn off autovacuum before you run
CLUSTER,otherwise you might run into a deadlock: 

Which variant of CLUSTER were you using?  ISTR that some of them lock
the index before the table, which is prone to deadlock against nearly
all other operations on the table (not just vacuum).

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Mikael Carneholm"
Date:
Subject: Autovacuum deadlock - bug or not?
Next
From: "Mikael Carneholm"
Date:
Subject: Re: Autovacuum deadlock - bug or not?