Subject | Re: [firebird-support] Garbage clean |
---|---|
Author | Ivan Prenosil |
Post date | 2003-12-15T12:52:44Z |
> How " select count(*) from table_where_you_delete_the_rows "This commnd will internally fetch all rows; for each row it will
> clean the garbage ?
- look at its transaction_id (to decide whether your transaction can see
that row or not, and hence count it)
-look whether there are older versions of that row,
old enough that they can be garbage collected;
if yes, then (depending on the version of server)
- the old version is removed (garbage collected)
or
- the garbage collection thread is notified that this database page
contains garbage
Ivan