Denis Perchine <dyp(at)perchine(dot)com> writes:
> When I run 2 vacuum's in parallel they hangs. Both.
> I use PostgreSQL from 7.0.x CVS (almost 7.0.3).

Hm.  I don't see a hang, but I do see errors like

NOTICE:  Deadlock detected -- See the lock(l) manual page for a possible cause.
ERROR:  WaitOnLock: error on wakeup - Aborting this transaction

What's curious is that neither 7.0.2 nor current seem to exhibit this
behavior (at least, it's much easier to reproduce in REL7_0_PATCHES than
in 7.0.2 or current).  Odd... in theory we shouldn't have introduced any
new bugs in REL7_0_PATCHES that wouldn't also be in current...

			regards, tom lane

In response to

• Problem with 2 avcuums in parallel at 2000-10-31 14:16:29 from Denis Perchine

Responses

• Re: Problem with 2 avcuums in parallel at 2000-11-03 17:12:39 from Tom Lane

pgsql-hackers by date

Next:	From: Philip Warner	Date: 2000-11-02 22:59:39
	Subject: Re: Transaction costs?
Previous:	From: Tom Lane	Date: 2000-11-02 22:01:23
	Subject: Re: relation ### modified while in use