|From:||Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>|
|To:||Pg Hackers <pgsql-hackers(at)postgresql(dot)org>|
|Subject:||Re: pg_serial early wraparound|
|Views:||Raw Message | Whole Thread | Download mbox|
On Wed, Nov 9, 2016 at 11:07 AM, Thomas Munro
> The SLRU managed by predicate.c can wrap around and overwrite data if
> you have more than 1 billion active XIDs. That's because when SSI was
> implemented, slru.c was limited to four digit segment names, which
> implied a page limit that wasn't enough for pg_serial to have space
> for every possible XID. We should probably rip that code out, because
> SLRUs now support five digit segment names. Something like the
> attached. I'll post a test script to demonstrate correct wraparound
> behaviour around in time for one of the later CFs.
Here is a shell script that shows a full rotation through xid space if
you build PostgreSQL with TEST_OLDSERXID, which you can do by
uncommenting a line in predicate.c. On master we see the SLRU
segments go around the clock twice for each time xid goes around.
With the patch it goes around just once, adding an extra character to
the segment name to double the space.
By the way, I think the real number of xids it can hold today is
(65536 * 32 * 8192) / sizeof(uint64) = 2^31 xids, not 2^30 as
indicated by an existing comment. So I think there is actually enough
space and wrapping is probably harmess, but it seems cleaner and
simpler not to do that and to rip out the scary warning code, so I'll
add this to the CF.
|Next Message||Thomas Munro||2017-02-27 06:33:10||Re: pg_serial early wraparound|
|Previous Message||Beena Emerson||2017-02-27 06:27:33||Re: increasing the default WAL segment size|