Re: Vacuum full

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Andrew Bartley <abartley(at)evolvosystems(dot)com>
Cc: Justin Clift <justin(at)postgresql(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: Vacuum full
Date: 2002-11-06 04:18:07
Message-ID: 20021106041807.GA32380@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Nov 06, 2002 at 14:14:23 +1100,
Andrew Bartley <abartley(at)evolvosystems(dot)com> wrote:
>
> I suppose the reason for the question is related to the limit on the number
> trans before there is a problem.

This is covered in the documentation. It is recommended that you vacuum
at least every billion (10^9) transactions. Problems occur after about
2 billion transactions. The documentation covers this in more detail.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Fred 2002-11-06 06:33:46 out parameters ( oracle 2 pg )
Previous Message Andrew Bartley 2002-11-06 03:52:11 Re: Vacuum full