Re: 64-bit XIDs in deleted nbtree pages

Peter Geoghegan <pg@bowt.ie>

From: Peter Geoghegan <pg@bowt.ie>

To: Masahiko Sawada <sawada.mshk@gmail.com>

Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, Heikki Linnakangas <hlinnaka@iki.fi>

Date: 2021-03-21T22:27:40Z

Lists: pgsql-hackers

On Wed, Mar 10, 2021 at 5:34 PM Peter Geoghegan <pg@bowt.ie> wrote:
> Here is another bitrot-fix-only revision, v9. Just the recycling patch again.

I committed the final nbtree page deletion patch just now -- the one
that attempts to make recycling happen for newly deleted pages. Thanks
for all your work on patch review, Masahiko!

I'll close out the CF item for this patch series now.

-- 
Peter Geoghegan

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Recycle nbtree pages deleted during same VACUUM.
- 9dd963ae2534 14.0 landed
VACUUM VERBOSE: Count "newly deleted" index pages.
- 237636183909 14.0 landed
Use full 64-bit XIDs in deleted nbtree pages.
- e5d8a9990304 14.0 landed
Fix nbtree cleanup-only VACUUM stats inaccuracies.
- 48e1291342dd 14.0 cited
Fix undercounting in VACUUM VERBOSE output.
- 73a076b03f1c 13.0 cited
Delete empty pages in each pass during GIST VACUUM.
- 4e514c6180fb 13.0 cited
Use full 64-bit XID for checking if a deleted GiST page is old enough.
- 6655a7299d83 13.0 cited
Allow VACUUM to be run with index cleanup disabled.
- a96c41feec6b 12.0 cited
Skip full index scan during cleanup of B-tree indexes when possible
- 857f9c36cda5 11.0 cited
Do index FSM vacuuming sooner.
- c79f6df75dd3 11.0 cited
Avoid early reuse of btree pages, causing incorrect query results.
- d3abbbebe52e 9.2.0 cited
Clean up API for ambulkdelete/amvacuumcleanup as per today's discussion.
- e57345975cf8 8.2.0 cited