Re: Vacuum full - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Vacuum full
Date
Msg-id 20021106041807.GA32380@wolff.to
Whole thread Raw
In response to Re: Vacuum full  ("Andrew Bartley" <abartley@evolvosystems.com>)
List pgsql-general
On Wed, Nov 06, 2002 at 14:14:23 +1100,
  Andrew Bartley <abartley@evolvosystems.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.

pgsql-general by date:

Previous
From: "Andrew Bartley"
Date:
Subject: Re: Vacuum full
Next
From: Justin Clift
Date:
Subject: Romanian version of the PostgreSQL "Advocacy and Marketing" site is ready