Re: Vacuum now uses AccessShareLock for analyze

> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > The code will now vacuum all requested relations. It will then analyze
> > each relation. This way, all the exclusive vacuum work is done first,
> > then analyze can continue with shared locks.
>
> I agree with Marc: it'd make more sense to do it one table at a time,
> ie,
> get exclusive lock on table A
> vacuum table A
> commit, release lock
> get shared lock on table A
> gather stats for table A
> commit, release lock
> repeat sequence for table B
> etc

OK, changed.

I will work on the additional issues in the next week or so.

--
Bruce Momjian | http://www.op.net/~candle
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026