Re: Vacuum deadlocks?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: josh(at)agliodbs(dot)com
Cc: eric soroos <eric-psql(at)soroos(dot)net>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Vacuum deadlocks?
Date: 2003-01-10 20:09:21
Message-ID: 11792.1042229361@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Josh Berkus <josh(at)agliodbs(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message pippo 2003-01-10 21:51:36 ALTER USER does not work
Previous Message Josh Berkus 2003-01-10 19:33:11 Re: Vacuum deadlocks?