Re: vacuum and 24/7 uptime - Mailing list pgsql-general

From Martín Marqués
Subject Re: vacuum and 24/7 uptime
Date
Msg-id 01071216343500.08941@bugs
Whole thread Raw
In response to Re: vacuum and 24/7 uptime  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: vacuum and 24/7 uptime  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
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
-----------------------------------------------------------------

pgsql-general by date:

Previous
From: "Thalis A. Kalfigopoulos"
Date:
Subject: \df+ and pg_proc query
Next
From: Bruce Momjian
Date:
Subject: Re: Re: Pg7.2 (was: vacuum and 24/7 uptime)