From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
---|---|
To: | Gokulakannan Somasundaram <gokul007(at)gmail(dot)com> |
Cc: | Hans-Juergen Schoenig <postgres(at)cybertec(dot)at>, "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>, Martijn van Oosterhout <kleptog(at)svana(dot)org>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Proposal: Select ... AS OF Savepoint |
Date: | 2007-11-05 06:51:31 |
Message-ID: | 1194245491.4258.75.camel@ebony.site |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Mon, 2007-11-05 at 11:58 +0530, Gokulakannan Somasundaram wrote:
> The idea was to write a syncpoint every N seconds where we
> record the
> time and a snapshot of what's in progress.
>
> What exactly is getting recorded here? Will the Syncpoint be similar
> to the Undo Log at distinct intervals?
Postgres needs to record the snapshot to allow visibility checks. There
is no Undo log; the database records themselves represent the logical
equivalent of an Undo log in other databases.
But as I said, I'm not working on this, so I'm not going into detailed
design anytime soon.
--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com
From | Date | Subject | |
---|---|---|---|
Next Message | Gokulakannan Somasundaram | 2007-11-05 09:48:00 | Fwd: Clarification about HOT |
Previous Message | Gokulakannan Somasundaram | 2007-11-05 06:28:37 | Re: Proposal: Select ... AS OF Savepoint |