Re: Data loss, vacuum, transaction wrap-around

From: pgsql(at)mohawksoft(dot)com
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Data loss, vacuum, transaction wrap-around
Date: 2005-02-18 18:00:39
Message-ID: 16811.24.91.171.78.1108749639.squirrel@mail.mohawksoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

More suggestions:

(1) At startup, postmaster checks for an XID, if it is close to a problem,
force a vacuum.

(2) At "sig term" shutdown, can the postmaster start a vacuum?

(3) When the XID count goes past the "trip wire" can it spontaneously
issue a vacuum?

NOTE:
Suggestions 1 and 2 are for 8.0 and prior. 3 is for later than 8.0.1

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-02-18 18:03:26 Re: Data loss, vacuum, transaction wrap-around
Previous Message Matthew T. O'Connor 2005-02-18 17:45:14 Re: Data loss, vacuum, transaction wrap-around