Subject Re: [firebird-support] Re: Performance when deleting a lot of records, again
Author Ann W. Harrison
cosamektoo wrote:
> One 'DEVICE_FREE_SPACE' - 1455 and STATUS_KEEPER : 103420.(This table
> contains only one record all the time with un integer value).
> I've checked the transactions on those tables and they all commit
> immediately.

Ah! All transactions have to finish, not just the ones that touch those
tables. A snapshot transaction sees a stable state of the whole
database, so it inhibits garbage collection everywhere.