Re: [HACKERS] Sequence nexvtal() and initdb/pg_proc problem - Mailing list pgsql-hackers

From Ole Gjerde
Subject Re: [HACKERS] Sequence nexvtal() and initdb/pg_proc problem
Date
Msg-id Pine.LNX.4.05.9905240142410.6022-100000@snowman.icebox.org
Whole thread Raw
In response to Re: [HACKERS] Sequence nexvtal() and initdb/pg_proc problem  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Sun, 23 May 1999, Tom Lane wrote:
[snip - nextval problem]
> Can't duplicate that here --- but it might well be related to your
> busted pg_proc table ...

Indeed that was the problem.

> But evidently that's not always true during initdb.  You must be running
> with a very low value of RELSEG_SIZE to have precipitated such a
> problem, however.

Yes, I removed one too many 0's from RELSEG_SIZE to do some testing.
I usually set it to 0x200000 / BLCKSZ for testing segment related things.

> Reasonable fixes would be either to force the appropriate cd during
> initdb, or to find and fix the place that's touching extension segments
> using a relative pathname.  But I can't get excited about spending much
> time on it, since the problem will never arise at realistic RELSEG_SIZE
> settings...

It's definately not worth the time right now.  I will probably take a
look at this in couple of weeks, since it probably should be checked.

Thanks,
Ole Gjerde



pgsql-hackers by date:

Previous
From: Ole Gjerde
Date:
Subject: Vacuum/mdtruncate() (was: RE: [HACKERS] Current TODO list)
Next
From: Vadim Mikheev
Date:
Subject: Re: Vacuum/mdtruncate() (was: RE: [HACKERS] Current TODO list)