Re: vacuum and 24/7 uptime

> On Mi? 11 Jul 2001 20:49, Bruce Momjian wrote:
> > > On Mi? 11 Jul 2001 13:46, Ryan Mahoney wrote:
> > > > Hi Mark, This is being worked on now. I believe the 7.2 release will
> > > > have enable you to run a vacuum with no downtime.
> > >
> > > AFAIK, if UNDO is implemented, no vacuum will be needed to free space.
> > >
> > > It would be great if UNDO would clean indexes.
> >
> > UNDO is for rolling back aborted transactions. I have not heard it used
> > to eliminate vacuum.
>
> I most have read badly, but I'm almost sure that I heard that UNDO was gonna
> solve the overload that vacuum does on big DB.
> Which is, in that case, the real status of the future of UNDO?

UNDO was discussed as a solution for subtransactions and for row reuse
of aborted transactions. I have not heard it for clearing out expire
rows caused by DELETE or UPDATE.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026