Transaction Id wraparounds

From: Amin Abdulghani <amin(at)quantiva(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Transaction Id wraparounds
Date: 2002-09-05 15:27:38
Message-ID: web-771883@quantiva.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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. Only selective vacuums on the modified
tables tend to be more effcient. However, there are also
tables (for example tables that are no long updated but
have heavy selects on them) in the DB that aren't touched
by a vacuum in weeks (probably never). In such a high
activity database what would then be the best way to take
care of the transaction id wraparounds (for example, would
shutting off and restarting the db do the trick). Also,
what should be the criteria to check when this issue needs
to be addressed. For example in one of our
databases age(datfrozenxid) is 1076913425.

Thanks..
Amin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Markus Wollny 2002-09-05 15:59:16 Re: Problem with restoring dump (may be tsearch-related)
Previous Message Patrick Fiche 2002-09-05 15:26:01 Problem with LEFT function...