Skip site navigation (1) Skip section navigation (2)

Re: Autovacuum deadlock - bug or not?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mikael Carneholm" <Mikael(dot)Carneholm(at)WirelessCar(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Autovacuum deadlock - bug or not?
Date: 2005-11-17 14:51:10
Message-ID: 25956.1132239070@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"Mikael Carneholm" <Mikael(dot)Carneholm(at)WirelessCar(dot)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

In response to

pgsql-bugs by date

Next:From: Mikael CarneholmDate: 2005-11-17 14:59:08
Subject: Re: Autovacuum deadlock - bug or not?
Previous:From: Mikael CarneholmDate: 2005-11-17 14:11:13
Subject: Autovacuum deadlock - bug or not?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group