Re: Vacuum deadlocks? - Mailing list pgsql-novice

From Tom Lane
Subject Re: Vacuum deadlocks?
Date
Msg-id 11792.1042229361@sss.pgh.pa.us
Whole thread Raw
In response to Re: Vacuum deadlocks?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-novice
Josh Berkus <josh@agliodbs.com> writes:
> The only related fix between 7.2.1 and 7.2.3 I can find is on:
> http://www3.us.postgresql.org/users-lounge/docs/7.3/postgres/release-7-2-3.html
> " Prevent spinlock hangs on SMP PPC machines (Tomoyuki Niijima)"

Given that Eric is using SMP PPC hardware, I would strongly advise
updating to get that patch.

I'm not aware of any reasons for vacuuming to cause deadlocks, so I
suspect that the spinlock bug must be the problem.

            regards, tom lane

pgsql-novice by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Vacuum deadlocks?
Next
From: pippo@bellnet.ca
Date:
Subject: ALTER USER does not work