Re: Data loss, vacuum, transaction wrap-around

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mark Kirkwood <markir(at)coretech(dot)co(dot)nz>
Cc: Andrew Dunstan <andrew(at)dunslane(dot)net>, pgsql(at)mohawksoft(dot)com, Jaime Casanova <systemguards(at)gmail(dot)com>, Russell Smith <mr-russ(at)pws(dot)com(dot)au>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Data loss, vacuum, transaction wrap-around
Date: 2005-02-20 05:30:17
Message-ID: 11421.1108877417@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Mark Kirkwood <markir(at)coretech(dot)co(dot)nz> writes:
> To be fair to Mark, there does seem to be an increasing number of
> reports of this issue. In spite of the in-the-works fix for 8.1, it
> would be a pity to see customers losing data from xid wrap-around.

The question is whether we are willing to back-patch a fairly large
amount of not-very-well-tested code into 8.0. See
http://archives.postgresql.org/pgsql-patches/2005-02/msg00123.php
http://archives.postgresql.org/pgsql-committers/2005-02/msg00127.php
http://archives.postgresql.org/pgsql-committers/2005-02/msg00131.php

I personally don't think it's worth the risk. The code works well
enough to commit to development tip, but it's fundamentally alpha
quality code.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-02-20 05:38:49 Re: Fwd: Apple Darwin disabled fsync?
Previous Message Tom Lane 2005-02-20 05:25:13 Re: Get rid of system attributes in pg_attribute?