Re: vacuum and 24/7 uptime

Поиск
Список
Период
Сортировка
От Martín Marqués
Тема Re: vacuum and 24/7 uptime
Дата
Msg-id 01071216343500.08941@bugs
обсуждение исходный текст
Ответ на Re: vacuum and 24/7 uptime  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: vacuum and 24/7 uptime  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Thalis A. Kalfigopoulos"
Дата:
Сообщение: \df+ and pg_proc query
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Re: Pg7.2 (was: vacuum and 24/7 uptime)