| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Alvaro Herrera Munoz <alvherre(at)dcc(dot)uchile(dot)cl> |
| Cc: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Analyze using savepoints? |
| Date: | 2004-08-09 15:03:22 |
| Message-ID: | 14844.1092063802@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Alvaro Herrera Munoz <alvherre(at)dcc(dot)uchile(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Wieck | 2004-08-09 15:36:48 | Re: VACUUM DELAY |
| Previous Message | Tom Lane | 2004-08-09 14:54:54 | Re: Add Missing From? |