Re: Transaction Id wraparounds

On Thu, Sep 05, 2002 at 11:27:38AM -0400, Amin Abdulghani wrote:
> Hi,
>
> What fast, efficient options are available for preventing
> transaction Id wraparounds for a growing database (mainly
> inserts). From the administrator's guide I understand a
> system wide VACUUM or VACUUM FREEZE would perform the job
> but for a large database (>10GB and growing) this takes a
> long time to run.

As I understand it, _only_ vacuum or dump and initdb will solve this
problem.

But who cares if vacuum takes a long time?  The transaction
wraparound stuff is only available in 7.2 and later, so oyu can use
the non-blocking vacuum in 7.2, and let it run for a week if it takes
that long.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110