Re: Problem with OID wrap - Mailing list pgsql-general

From Tom Lane
Subject Re: Problem with OID wrap
Date
Msg-id 3929.1008345249@sss.pgh.pa.us
Whole thread Raw
In response to Problem with OID wrap  (Martin Weinberg <weinberg@osprey.astro.umass.edu>)
Responses Re: Problem with OID wrap
List pgsql-general
Martin Weinberg <weinberg@osprey.astro.umass.edu> writes:
> It seems that OID in one of our databases wrapped during a data
> load from tape.
> The wrap is quite plausible based on the volume of the database and
> the number of tables that have been loaded and reloaded.  I would have
> thought that an OID wrap would be harmless (except in the loss of
> uniqueness and meaning for any query which depended on this).
> However, the user complains that part of the table disappeared?  Is
> this possible?

I'd be wondering about transaction ID wrap, myself.  You might care
to consult the discussion of transaction ID wrap in the 7.2 development
docs (under admin guide "routine maintenance", IIRC).

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [CORE] report a bug
Next
From: Tom Lane
Date:
Subject: Re: alias question