Re: vacuum and 24/7 uptime

From: Martín Marqués <martin(at)bugs(dot)unl(dot)edu(dot)ar>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: vacuum and 24/7 uptime
Date: 2001-07-12 19:34:35
Message-ID: 01071216343500.08941@bugs
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

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(at)unl(dot)edu(dot)ar
Programador, Administrador | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2001-07-12 19:42:41 Re: vacuum and 24/7 uptime
Previous Message Thalis A. Kalfigopoulos 2001-07-12 19:34:08 \df+ and pg_proc query

Browse pgsql-jdbc by date

  From Date Subject
Next Message Bruce Momjian 2001-07-12 19:42:41 Re: vacuum and 24/7 uptime
Previous Message dennis@zserve.com 2001-07-12 18:26:41 Re: vacuum and 24/7 uptime