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

From Matthew T. O'Connor
Subject Re: Data loss, vacuum, transaction wrap-around
Date
Msg-id 421629AA.70406@zeut.net
Whole thread Raw
In response to Re: Data loss, vacuum, transaction wrap-around  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Data loss, vacuum, transaction wrap-around  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:

>pgsql@mohawksoft.com writes:
>  
>
>>In fact, I think it is so bad, that I think we need to back-port a fix to
>>previous versions and issue a notice of some kind.
>>    
>>
>
>They already do issue notices --- see VACUUM.
>
>A real fix (eg the forcible stop we were talking about earlier) will not
>be reasonable to back-port.
>

I hope this question isn't too stupid.... 

Is it be possible to create a "vacuum wraparound" or "vacuum xidreset" 
command which would do the work required to fix the wraparound problem, 
without being as expensive as a normal vacuum of an entire database?


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Data loss, vacuum, transaction wrap-around
Next
From: pgsql@mohawksoft.com
Date:
Subject: Re: Data loss, vacuum, transaction wrap-around