Forgot to mention:
dfol=> select version();
version
-------------------------------------------------------------
PostgreSQL 8.1.0 on i686-pc-linux-gnu, compiled by GCC 2.96
(1 row)
-----Original Message-----
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: den 17 november 2005 16:04
To: Mikael Carneholm
Cc: [email protected]
Subject: Re: [BUGS] Autovacuum deadlock - bug or not?
"Mikael Carneholm" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
