Re: [PATCH] Transaction traceability - txid_status(bigint)
Robert Haas <robertmhaas@gmail.com>
From: Robert Haas <robertmhaas@gmail.com>
To: Craig Ringer <craig@2ndquadrant.com>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>,
Jim Nasby <Jim.Nasby@bluetreble.com>
Date: 2016-08-22T17:03:25Z
Lists: pgsql-hackers
On Sat, Aug 20, 2016 at 9:46 AM, Craig Ringer <craig@2ndquadrant.com> wrote: > Ahem. Forgot to squash in a fixup commit. Updated patch of > txid_status(bigint) attachd. > > A related patch follows, adding a new txid_current_ifassigned(bigint) > function as suggested by Jim Nasby. It's usefully connected to txid_status() > and might as well be added at the same time. > > Since it builds on the same history I've also attached an updated version of > txid_recent(bigint) now called txid_convert_ifrecent(bigint), per the > above-linked thread. > > Finally, and not intended for commit, is a useful test function I wrote to > cause extremely rapid xid wraparound, bundled up into a src/test/regress > test case. txid_incinerate() can jump the server about UINT32/2 xids in ~2 > seconds if fsync is off, making it handy for testing. Posting so others can > use it for their own test needs later and because it's useful for testing > these patches that touch on the xid epoch. I think you should use underscores to separate all of the words instead of only some of them. Also, note that the corresponding internal function is GetTopTransactionIdIfAny(), which might suggest txid_current_if_any() rather than txid_current_if_assigned(), but you could argue that your naming is better... -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
Commits
-
Add a txid_status function.
- 857ee8e391ff 10.0 landed
-
Track the oldest XID that can be safely looked up in CLOG.
- ea42cc18c353 10.0 landed