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 15:03:55
Message-ID: 26074.1132239835@sss.pgh.pa.us (view raw or flat)
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

pgsql-bugs by date

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

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