Postgres Pro
Downloads
Home   >   mailing lists

Re: Data loss, vacuum, transaction wrap-around - Mailing list pgsql-hackers

From pgsql@mohawksoft.com
Subject Re: Data loss, vacuum, transaction wrap-around
Date
Msg-id 16811.24.91.171.78.1108749639.squirrel@mail.mohawksoft.com
Whole thread Raw
In response to Data loss, vacuum, transaction wrap-around  (pgsql@mohawksoft.com)
Responses Re: Data loss, vacuum, transaction wrap-around
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: "Matthew T. O'Connor"
Date:
Subject: Re: Data loss, vacuum, transaction wrap-around
Next
From: Tom Lane
Date:
Subject: Re: Data loss, vacuum, transaction wrap-around