Alvaro Herrera Munoz <alvherre@dcc.uchile.cl> writes:
> I think both VACUUM and ANALYZE could be best served by appropiate use
> of short-lived ResourceOwners. It needs some thought though.
At least for VACUUM FULL, this is pretty much a nonstarter: it needs a
real live genuine COMMIT in the middle. No half measures unless you are
willing to lose your data on crash.
ANALYZE could possibly get away with simply releasing the table lock early.
I haven't thought about it in detail.
regards, tom lane