| 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: | Whole Thread | Raw Message | 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 |