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?

Saludos.... :-)

--
Cualquiera administra un NT.
Ese es el problema, que cualquiera administre.
-----------------------------------------------------------------
Martin Marques                  |        mmarques@unl.edu.ar
Programador, Administrador      |       Centro de Telematica
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------