Re: Transaction Id wraparounds

Amin Abdulghani <amin@quantiva.com> writes:
> 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.

So?  You don't have to do it often, and it doesn't lock your
tables against normal operations ... so I don't really see the
objection.  I would not bother with FREEZE unless you are trying
to make a template database.

> what should be the criteria to check when this issue needs
> to be addressed.

When age(datfrozenxid) approaches 2 billion, it's time.  I believe
vacuum will start warning you well before that.

            regards, tom lane