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 15:03:55
Message-ID: 26074.1132239835@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Mikael Carneholm" <Mikael(dot)Carneholm(at)WirelessCar(dot)com> writes:
> variant: CLUSTER indexname ON tablename

Hmph. Looking at the code, that should always lock the table first,
so I don't see where the problem is. Would you look up the numbers
for us --- exactly which relations were involved in the deadlock,
and (if you can tell) which process was which?

Also, what PG version is this exactly?

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Matt Carter 2005-11-17 15:11:07 Huge query stalls at PARSE/BIND stage (1)
Previous Message Mikael Carneholm 2005-11-17 14:59:08 Re: Autovacuum deadlock - bug or not?