Subject RE: [firebird-support] file size and transactions
Author Paul Beach
> I read somewhere that the "read only" transactions are absolutelly harmless to the GC and sweeping. Is that so?

>>Read only transactions only physically have an impact on the TIP/Header page(s), however a long running read only transaction
>>will have the same effect as a long running read write transaction in that it will block GC and sweeps until it
>>commits.

<<may i ask why readonly readcommited transaction block GC?
Is this true?>>

Karol,

I was referring to the default transaction state of snapshot (repeatable read)....
Other transaction states will have different effects. In your case
read commited needs only the newest record version (or record versions created by
the transaction itself) so its not going to block anything.

Paul