RE: TOAST-table vacuuming (was Re: Idea for reducing pl anning time) - Mailing list pgsql-hackers

From Mikheev, Vadim
Subject RE: TOAST-table vacuuming (was Re: Idea for reducing pl anning time)
Date
Msg-id 8F4C99C66D04D4118F580090272A7A234D31FC@sectorbase1.sectorbase.com
Whole thread Raw
Responses Re: TOAST-table vacuuming (was Re: Idea for reducing pl anning time)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> > Also, is TOAST-table vacuuming fixed now?
> 
> Still broken.  Hiroshi had muttered something about fixing 
> the internal commit of VACUUM so that it's more like a real
> commit --- including advancing the transaction ID --- but
> still doesn't release the exclusive lock held by VACUUM.
> Basically we need to propagate the locks forward to the new
> xact instead of releasing them. I think that would be a nice
> clean solution if we could do it. Do you have any ideas about how?

Yes, it would be nice for cursors too - they should be able to cross
transaction boundaries...

Use BackendID instead of XID in XIDTAG?
Add internal (ie per backend) hash of locks that should not be
released at commit time?
And couple additional funcs in lmgr API?

Vadim


pgsql-hackers by date:

Previous
From: Alfred Perlstein
Date:
Subject: Re: Idea for reducing planning time
Next
From: Bruce Momjian
Date:
Subject: Re: Idea for reducing planning time