On Sat, Feb 17, 2007 at 11:48:55AM -0500, Tom Lane wrote:
> "Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> > RPK wrote:
> >> Future versions of PostgreSQL must have similar features which enable users
> >> to bring Table(s) and/or Database(s) to a desired Time Stamp.
> > We can do it with databases, we can't do it with tables. Nor should we
> > do it with tables as it would require that all tables in relation are
> > also flashed backed.
> AFAICT this is a request to re-instate Time Travel, which is a feature
> we removed more than ten years ago because the overhead was utterly
> unacceptable. And the project's idea of acceptable performance then
> was orders of magnitude weaker than it is now. So it's not going to
> happen, at least not in the general release. You might take a look at
> contrib/spi/README.timetravel, though, for a prototype of how something
> similar can be achieved without any changes to the core system. That
> module is a bit unmaintained and could doubtless do with some updates
> --- for starters, it should be using timestamptz instead of the old
> deprecated abstime. If you're interested, feel free to work on it.
> No one else has taken an interest in a long time.
For other recent time travel ideas see:
Time travel is not cheap, though.
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?