Subject Re: [Firebird-Architect] FB2, read-commited and blobs
Author Ann W. Harrison
Vlad Horsun wrote:
>>7) In garbage collection, notice whether the record has blobs. If so,
>>check both oldest_active and oldest_blob before removing old versions.
>
>
> I have a problem with implementation of this last step. Question is
> when we can make such check ?

An easy first approximation is to leave the record version if it has a
non-null blob field. That would get the right answer consistently and
allow a lot more garbage collection than we do now. For the full
implementation, we'll have to make changes to vio and blb so the going
and staying lists are compiled before anything is removed and the blobs
can be checked.


Regards,


Ann