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

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

--
  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

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: vacuum and 24/7 uptime
Next
From: Bruce Momjian
Date:
Subject: Re: Re: Debian's PostgreSQL packages