Re: [firebird-support] Firebird 3 - Auto Garbage collection with Sweep interval = 0

2018-02-19 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
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

Re: [firebird-support] Firebird 3 - Auto Garbage collection with Sweep interval = 0

2018-02-18 Thread hv...@users.sourceforge.net [firebird-support]
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

Re: [firebird-support] Firebird 3 - Auto Garbage collection with Sweep interval = 0

2018-02-16 Thread Arnaldo Caliari arnaldo.cali...@studiosoft.info [firebird-support]
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,

Re: [firebird-support] Firebird 3 - Auto Garbage collection with Sweep interval = 0

2018-02-16 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
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

Re: [firebird-support] Firebird 3 - Auto Garbage collection with Sweep interval = 0

2018-02-16 Thread Norman Dunbar nor...@dunbar-it.co.uk [firebird-support]
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

[firebird-support] Firebird 3 - Auto Garbage collection with Sweep interval = 0

2018-02-15 Thread Arnaldo Caliari arnaldo.cali...@studiosoft.info [firebird-support]
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