Re: Lazy Snapshots

Hi,<br />   I have given some thought in this direction. I am just providing my idea.<br /><br />a) Have a structure
similarto commit log, which should also store, transaction id at which the transaction got committed. Every
transaction,after committing should update the transaction id at which the commit has happened<br /> b) All the
transactions-when it starts should have two figures - xmin and also a transaction id after which nothing has got
committed<br/>c) So whenever it sees the records, which are not inside the window, it can make decision by itself. <br
/>       i) The ones below xmin and committed are visible<br />       ii) the ones after xmax and committed are not
visible<br/>       iii) When its something in between, then check the time at which the commit happened in the
structureand make the decision.<br /><br />Ideally, it would be better to change the structure of commit log itself.
Butmaintaining an another structure also would help.<br /><br />Thanks,<br />Gokul.<br />