Re: Preventing duplicate vacuums?

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