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

From Mikael Carneholm
Subject Re: Autovacuum deadlock - bug or not?
Date
Msg-id 7F10D26ECFA1FB458B89C5B4B0D72C2B0A01E3@sesrv12.wirelesscar.com
Whole thread Raw
In response to Autovacuum deadlock - bug or not?  ("Mikael Carneholm" <Mikael.Carneholm@WirelessCar.com>)
List pgsql-bugs
Forgot to mention:=20

dfol=3D> select version();
                           version=20=20=20=20=20=20=20=20=20=20=20=20=20=
=20=20=20=20=20=20=20=20=20=20=20=20=20=20
-------------------------------------------------------------
 PostgreSQL 8.1.0 on i686-pc-linux-gnu, compiled by GCC 2.96
(1 row)


-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: den 17 november 2005 16:04
To: Mikael Carneholm
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] Autovacuum deadlock - bug or not?=20


"Mikael Carneholm" <Mikael.Carneholm@WirelessCar.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

pgsql-bugs by date:

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