Re: Minimally avoiding Transaction Wraparound in VLDBs

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Cc: Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, Simon Riggs <simon(at)2ndquadrant(dot)com>
Subject: Re: Minimally avoiding Transaction Wraparound in VLDBs
Date: 2005-09-01 04:16:49
Message-ID: 200508312116.49401.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Gavin, Tom,

> Well, from my reading of some of the early papers, VACUUM was kind of
> different to what it is now. The idea was that expired data would be moved
> out the heap and stored else where. A timetravel mechanism could be used
> to see previous versions of the row.

And from talking to a couple of Stonebraker's former students at conferences,
this mechanism was never build satisfactorily; it always existed on paper, at
least at UCB. Illustra might have finished it. Elein around?

--
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew - Supernews 2005-09-01 04:18:37 Re: TODO item: set proper permissions on non-system schemas
Previous Message Josh Berkus 2005-09-01 04:14:42 Re: Remove xmin and cmin from frozen tuples