> Bruce Momjian <pgman@candle.pha.pa.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@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026