Skip site navigation (1) Skip section navigation (2)

From: jaimelima(at)al(dot)uap(dot)edu(dot)ar
To: pgsql-hackers(at)postgresql(dot)org
Subject:
Date: 2007-10-31 16:10:36
Message-ID: 1193847036.4728a8fcebb66@correo.al.uap.edu.ar (view raw or flat)
Thread:
Lists: pgsql-hackers
I want to unsubscrib me please,



Mensaje citado por Hans-Juergen Schoenig <postgres(at)cybertec(dot)at>:

> hello ...
>
> i guess there is no formal proposal yet but there are some ideas
> around and some major challenges have been discussed already.
> i think simon riggs was planning to work on it in the future.
> the basic idea here is to have the option to create a "snapshot"
> which then stays in the database. the main challenge is that PostgreSQL
> should not keep all version of a row since the snapshot but VACUUM
> should be able to clean out all rows which are not seen by any
> snapshot or any ongoing transaction.
> this should be a quite fancy solution which is quite space efficient.
>
> internally we had the idea of tweaking VACUUM a little:
>
> 	VACUUM BEFORE timestamp;
> and ...
> 	SET current_snapshot TO '2007-10-10 ...';
>
> this would allow a queries to use any snapshot after the timestamp
> defined by VACUUM (if data is around).
> the downside here: you might potentially eat up more space.
> flashback data should be read only, of course.
>
> 	best regards,
>
> 		hans
>
>
>
> On Oct 31, 2007, at 11:31 AM, Gokulakannan Somasundaram wrote:
>
> > Hi,
> >    I went through the mailing list and couldn't get answer to the
> > question.
> >
> > a) Is there a proposal in place for going back in time within a
> > transaction?
> >
> >
> >
> > --
> > Thanks,
> > Gokul.
> > CertoSQL Project,
> > Allied Solution Groups.
> > (www.alliedgroups.com)
>
>
>
> --
> Cybertec Schönig & Schönig GmbH
> Gröhrmühlgasse 26, 2700 Wiener Neustadt
> Tel: +43/1/205 10 35 / 340
> www.postgresql.at, www.cybertec.at
>
>
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
>




----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.

In response to

Responses

  • Re: at 2007-10-31 17:29:19 from Andrew Dunstan
  • Re: at 2007-10-31 17:38:04 from Michael Glaesemann

pgsql-hackers by date

Next:From: Heikki LinnakangasDate: 2007-10-31 16:34:15
Subject: Re: Postgresql 8.3 beta crash
Previous:From: Tom LaneDate: 2007-10-31 13:18:26
Subject: Re: UTF-8 for SGML docs?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group