Re: Lazy Snapshots

Gokulakannan Somasundaram <gokul007@gmail.com> writes:
>    I have given some thought in this direction. I am just providing my idea.

> a) Have a structure similar to 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

The maintenance costs and update contention for such a datastructure
would render this completely impractical, even if consulting it were
free.
        regards, tom lane