Hi,

1. I've deleted 500000 records from TABLE A. I've commited transaction.
2. I made SELECT * FROM TABLE A. Transaction was starting for a very long time.

I just wanted to make sure that there is no way to prevent this behaviour? I mean, I can not delay somehow  clearing of this garbage?

As far as I understand this article: http://www.firebirdsql.org/manual/gfix-housekeeping.html

 

there is no such possibility becasue:

"Whenever a subsequent transaction reaches garbage from a committed transaction, that garbage is automatically cleared out."