Subject Re: [firebird-support] Very long transaction start after deleting a big number of records.
Author Carlos H. Cantu
Post date 2014-07-25T14:08:14Z
Re: [firebird-support] Very long transaction start after deleting a big number of records. Sorry, it will not drop the table, but will empty it marking all pages as reusable.

[]s
Carlos H. Cantu
www.FireBase.com.br - www.firebirdnews.org
www.warmboot.com.br - blog.firebase.com.br


It seems that Firebird 3 may have TRUNCATE table statement, that will drop the table and avoid GC on its pages:

http://tracker.firebirdsql.org/browse/CORE-2479

Carlos
Firebird Performance in Detail - http://videos.firebirddevelopersday.com
www.firebirdnews.org - www.FireBase.com.br



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."