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@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026