Re: [Firebird-docs] gstat OST - OIT and Sweep
Hi Norman, no problem. I just had some problems to understand it right. It was formulated a bit strange. At the end of the part I didn’t know if the statement was right or wrong (or whatever). ;-) Regards Martin ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
Re: [Firebird-docs] gstat OST - OIT and Sweep
Oh dear, I wrote that! Originally, if I remember correctly, I might have mentioned that the sweep would be started when OAT - OIT was greater than the sweep interval. This was s I had seen in books, online, etc. Vlad, complained to me that I had written wrongly, and that the sweep would be started when OST - OIT was greater than the sweep interval. OAT = Oldest Active Transaction. OIT = Oldest Interesting Transaction. OST = Oldest Snapshot Transaction. Cheers, Norm. -- Sent from my Android device with K-9 Mail. Please excuse my brevity.___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
Re: [Firebird-docs] gstat OST - OIT and Sweep
Martin, <> Note The automatic sweep is kicked off if the difference between OST (Oldest Snapshot Transaction) and OIT is greater than the sweep interval defined. The user's process that tried to start the transaction that exceeds the sweep interval by one will sweep the entire database before actually starting the transaction they requested. From: https://www.ibphoenix.com/resources/documents/search/doc_67 Regards Paul ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
Re: [Firebird-docs] gstat OST - OIT and Sweep
Hello Martin, I spoke with Vlad about section devoted to garbage, and we agreed it is difficult. I plan to rewrite it with pictures explaining records versions, garbage and sweep, but it really needs courage :) I suggest to let ost-oit phrases as is. Regards, Alexey Kovyazin IBSurgeon пт, 31 июл. 2020 г., 12:56 Köditz, Martin : > Hi, > > > > I’m currently working on gstat-de. I struggled with following part: > > > > Many web sites, books, manuals (previously including this one) explain > that the automatic sweep is activated when OAT - OIT is greater than the > sweep interval. > > This is _not_ the case as explained by Vlad Khorsun, one of the Firebird > developers, who explained that it is when OST -- OIT is greater than the > threshold that the sweep is activated. > > > > What does the last sentence exactly mean? Can someone „tidy“ it? > > > > Regards > > Martin > ___ > Firebird-docs mailing list > Firebird-docs@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-docs > ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
[Firebird-docs] gstat OST - OIT and Sweep
Hi, I’m currently working on gstat-de. I struggled with following part: Many web sites, books, manuals (previously including this one) explain that the automatic sweep is activated when OAT - OIT is greater than the sweep interval. This is _not_ the case as explained by Vlad Khorsun, one of the Firebird developers, who explained that it is when OST -- OIT is greater than the threshold that the sweep is activated. What does the last sentence exactly mean? Can someone „tidy“ it? Regards Martin ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs