Re: Vacuum/visibility is busted - Mailing list pgsql-hackers

From Jeff Janes
Subject Re: Vacuum/visibility is busted
Date
Msg-id CAMkU=1wO_Pt=mCYyu9gv_eS2KKm86v8_xEbR31KM5nnY3Oheag@mail.gmail.com
Whole thread Raw
In response to Re: Vacuum/visibility is busted  (Pavan Deolasee <pavan.deolasee@gmail.com>)
Responses Re: Vacuum/visibility is busted
Re: Vacuum/visibility is busted
Re: Vacuum/visibility is busted
Re: Vacuum/visibility is busted
List pgsql-hackers
On Thu, Feb 7, 2013 at 10:09 AM, Pavan Deolasee
<pavan.deolasee@gmail.com> wrote:
>
> Right. I don't have the database handy at this moment, but earlier in
> the day I ran some queries against it and found that most of the
> duplicates which are not accessible via indexes have xmin very close
> to 2100345903. In fact, many of them are from a consecutive range.

Does anyone have suggestions on how to hack the system to make it
fast-forward the current transaction id? It would certainly make
testing this kind of thing faster if I could make transaction id
increment by 100 each time a new one is generated.  Then wrap-around
could be approached in minutes rather than hours.

Thanks,

Jeff



pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: [COMMITTERS] pgsql: Fast promote mode skips checkpoint at end of recovery.
Next
From: Andres Freund
Date:
Subject: Re: Vacuum/visibility is busted