Re: Analyze using savepoints? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Analyze using savepoints?
Date
Msg-id 14844.1092063802@sss.pgh.pa.us
Whole thread Raw
In response to Re: Analyze using savepoints?  (Alvaro Herrera Munoz <alvherre@dcc.uchile.cl>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Add Missing From?
Next
From: Jan Wieck
Date:
Subject: Re: VACUUM DELAY