Re: Vacuum/visibility is busted

On 2013-06-19 15:01:44 -0700, Jeff Janes wrote:
> On Thu, Feb 7, 2013 at 12:01 PM, Andres Freund <andres(at)2ndquadrant(dot)com>wrote:
>
> > On 2013-02-07 11:15:46 -0800, Jeff Janes wrote:
> > >
> > > 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.
> >
> > I had various plpgsql functions to do that, but those still took quite
> > some time. As I needed it before I just spent some minutes hacking up a
> > contrib module to do the job.
> >
>
> Hi Andres,
>
> Your patch needs the file "xidfuncs--1.0.sql", but does not include it.
>
> I could probably guess what needs to be in that file, but do you still have
> a copy of it?

Hm. Sorry. Not sure how that happened. The commit in my local branch for
that seems to have it ;). Attached.

> > I doubt it really think it makes sense as a contrib module on its own
> > though?

> Maybe PGXN?

Hm. As of now I am not yet that convinced of PGXN for C containing
extensions.

Greetings,

Andres Freund

--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services