Re: solving wraparound

From: "Lic(dot) Martin Marques" <martin(at)bugs(dot)unl(dot)edu(dot)ar>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Martijn van Oosterhout <kleptog(at)svana(dot)org>, Jaime Casanova <systemguards(at)gmail(dot)com>, pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Re: solving wraparound
Date: 2005-12-27 11:27:36
Message-ID: Pine.LNX.4.61.0512270824310.8592@bugs.unl.edu.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 26 Dec 2005, Tom Lane wrote:
>
> This might be a good time to press your buddy to move to 8.1 ;-)
> PG 8.1 contains logic that should positively prevent a wraparound, by
> shutting down the server if wraparound gets too close.

But if VACUUM fixes the wraparound issue, shouldn't even a badly
configured autovacuum make the wraparound not be a problem in 8.1? Or did
I miss understand how this works?

--
08:20:01 up 4 days, 19:32, 1 user, load average: 0.04, 0.08, 0.15
---------------------------------------------------------
Lic. Martín Marqués | SELECT 'mmarques' ||
Centro de Telemática | '@' || 'unl.edu.ar';
Universidad Nacional | DBA, Programador,
del Litoral | Administrador
---------------------------------------------------------

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michelle Konzack 2005-12-27 12:55:25 Re: Toolkit for creating editable grid
Previous Message Ingo van Lil 2005-12-26 23:39:58 Adding columns to a view