Subject Re: Garbage clean
Author Alexander V.Nevsky
--- In, Doru Constantin <doru@o...>
> How:
> [code]
> select count(*) from table_where_the_rows_was_deleted
> [/code]
> can clean the garbage ?

Depends on [/code] :) and not in this instance of application too.
When you performed delete and _commited_ this transaction, deleted
records perform garbage. If there are parallel transactions which
should see data as it was at their start, this garbage can be cleaned.
When another transaction reads this table (note Count in FB is
performed as natural scan and visits all data pages) and encounters
garbage, in Super this transaction activates garbage collection
thread, in Classic performs garbage collection itself.

Best regards,