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 20:12:04
Message-ID: 01071217120402.08941@bugs
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

On Jue 12 Jul 2001 16:42, Bruce Momjian wrote:
> > On Mi? 11 Jul 2001 20:49, Bruce Momjian wrote:
> >
> > 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?
>
> UNDO was discussed as a solution for subtransactions and for row reuse
> of aborted transactions. I have not heard it for clearing out expire
> rows caused by DELETE or UPDATE.

But the discussion started with a long mail from Tom who dropped the a
posible solution of the row reuse of the ones which have been expired by
DELETE or UPDATE.

Saludos... :-)

P.D.: If there is someone interested in the mail Tom send:

http://fts.postgresql.org/db/mw/msg.html?mid=118484

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

Browse pgsql-general by date

  From Date Subject
Next Message Morgan Curley 2001-07-12 20:27:44 Visual Modeling programs
Previous Message Bruce Momjian 2001-07-12 20:06:03 Re: Postgresql revisited. Some questions about the product

Browse pgsql-jdbc by date

  From Date Subject
Next Message Bruce Momjian 2001-07-12 20:12:44 Re: [PATCHES] Re: [PATCH] Cleanup of JDBC character encoding
Previous Message Bruce Momjian 2001-07-12 20:09:39 Re: [PATCH] Cleanup of JDBC character encoding