Re: Tables dissapearing - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Tables dissapearing
Date
Msg-id 20070828080431.GA19715@svana.org
Whole thread Raw
In response to Re: Tables dissapearing  (Andrew Sullivan <ajs@crankycanuck.ca>)
List pgsql-general
On Mon, Aug 27, 2007 at 05:58:26PM -0400, Andrew Sullivan wrote:
> On Mon, Aug 27, 2007 at 11:44:38PM +0200, Kamil Srot wrote:
> > When this problem appeared for the first time, I had clearly the
> > wraparound problem... I did vacuum it and partially restored the data...
>
> I don't think vacuum would "fix" a wrap around problem in the way you
> describe.  I don't think you have a wrap problem.

Actually, it can: if you have just experienced wraparound (within 1
billion transactions or so) then vacuum will magically cause the
wrapped rows to reappear.

Ofcourse, your indexes may be invalid, your constraints may be
violated, but the data will still be there...

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment

pgsql-general by date:

Previous
From: Ow Mun Heng
Date:
Subject: Re: delete vs insert vs update due to primary key dups -> which is better
Next
From: Richard Huxton
Date:
Subject: Re: Tables dissapearing