Re: [Firebird-docs] gstat OST - OIT and Sweep

2020-07-31 Thread Köditz , Martin
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

Re: [Firebird-docs] gstat OST - OIT and Sweep

2020-07-31 Thread Norman Dunbar
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

Re: [Firebird-docs] gstat OST - OIT and Sweep

2020-07-31 Thread Paul Beach
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

Re: [Firebird-docs] gstat OST - OIT and Sweep

2020-07-31 Thread Alexey Kovyazin (ak)
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 пт,

[Firebird-docs] gstat OST - OIT and Sweep

2020-07-31 Thread 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