Hi Everyone,
Adding just a bit more detail to the description of garbage collection
in Firebird.
For those who know little about Firebird, when a record is updated,
Firebird
does not replace the old version with the new. Instead, it creates a new
version
and chains the old version behind
Hi, Helen
Good description, as always ;)
Let me add some details
> A GC run updates the record statistics but it does not remove the
> stubs of deleted records.
GC doesn't update record statistics (not sure i understand you correctly here)
and it removes delete stubs - when OST become
Hello Helen and Norman,
Ok, thanks to you, now is some way clearer...
we have set sweep = 0 and we make a scheduled "manual" sweep every
morning at 05:00. My fault is that, in my expectations, the sweep = 0
condition would suffice to disable completely the GC in daily hours. In
daily hours, s
Hello Arnaldo,
Friday, February 16, 2018, 2:19:19 AM, Arnaldo wrote:
> maybe i have always misunderstood the garbage collection mechanism, the
> sweep interval, etc.. and i'm realising only now, but:
> I have this database (Firebird 3.03 SuperServer x64)
> My question is : why garbage collection
Evening Arnaldo,
On 15/02/18 13:19, Arnaldo Caliari arnaldo.cali...@studiosoft.info
[firebird-support] wrote:
> Hi guys,
>
> maybe i have always misunderstood the garbage collection mechanism, the
> sweep interval, etc.. and i'm realising only now, but:
Welcome to my world! ;-)
> I have this d
Hi guys,
maybe i have always misunderstood the garbage collection mechanism, the
sweep interval, etc.. and i'm realising only now, but:
I have this database (Firebird 3.03 SuperServer x64)
Gstat execution time Thu Feb 15 05:00:01 2018
Database header page information:
Flags 0
