On Thu, 2004-02-05 at 16:51, Josh Berkus wrote: > Tom, > > > Yes we do: there's a lock. > > Sorry, bad test. Forget I said anything. > > Personally, I would like to have the 2nd vacuum error out instead of blocking. > However, I'll bet that a lot of people won't agree with me. >
Don't know if I would agree for sure, but i the second vacuum could see that it is being blocked by the current vacuum, exiting out would be a bonus, since in most scenarios you don't need to run that second vacuum so it just ends up wasting resources (or clogging other things up with it lock) Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster