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 16585.24.91.171.78.1108780763.squirrel@mail.mohawksoft.com
Whole thread Raw
In response to Re: Data loss, vacuum, transaction wrap-around  (Russell Smith <mr-russ@pws.com.au>)
Responses Re: Data loss, vacuum, transaction wrap-around
List pgsql-hackers
> On Sat, 19 Feb 2005 04:10 am, 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.
>>
> Not to be rude, but if backporting is not an option, why do we not just
> focus on the job of getting autovacuum into 8.1, and not have to think
> about how a patch that will warn users will work?

Unless I'm mistaken, even "autovacuum" may not be enough. AFAIK,
autovacuum depends on the statistics daemon, and some admins may turn that
off for performance. Even so, how unlikely is it that autovacuum doesn't
run.

I think there should be a 100% no data loss fail safe. Anything less is a
cop-out. I can't see one successful argument that starts with data loss
and ends with maintenence.



pgsql-hackers by date:

Previous
From: Russell Smith
Date:
Subject: Re: Data loss, vacuum, transaction wrap-around
Next
From: Andrew Dunstan
Date:
Subject: Re: Data loss, vacuum, transaction wrap-around