Re: Lazy Snapshots - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Lazy Snapshots
Date
Msg-id 8308.1250948611@sss.pgh.pa.us
Whole thread Raw
In response to Re: Lazy Snapshots  (Gokulakannan Somasundaram <gokul007@gmail.com>)
Responses Re: Lazy Snapshots  (Gokulakannan Somasundaram <gokul007@gmail.com>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: [PATCH] plpythonu datatype conversion improvements
Next
From: Tom Lane
Date:
Subject: Re: SIGUSR1 pingpong between master na autovacum launcher causes crash