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 пт,