pgsql: Remove btree page items after page unlink - Mailing list pgsql-committers

From Alexander Korotkov
Subject pgsql: Remove btree page items after page unlink
Date
Msg-id E1k36AS-0003x1-Ov@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Remove btree page items after page unlink

Currently, page unlink leaves remaining items "as is", but replay of
corresponding WAL-record re-initializes page leaving it with no items.
For the sake of consistency, this commit makes primary delete all the items
during page unlink as well.

Thanks to this change, we now don't mask contents of deleted btree page for
WAL consistency checking.

Discussion: https://postgr.es/m/CAPpHfdt_OTyQpXaPJcWzV2N-LNeNJseNB-K_A66qG%3DL518VTFw%40mail.gmail.com
Author: Alexander Korotkov
Reviewed-by: Peter Geoghegan

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/f47b5e139579a77c1f7c63400f01ea39d515e8c8

Modified Files
--------------
contrib/amcheck/verify_nbtree.c     |  7 ++-----
src/backend/access/nbtree/nbtpage.c |  9 +++++++++
src/backend/access/nbtree/nbtxlog.c | 10 +---------
3 files changed, 12 insertions(+), 14 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Increase hard-wired timeout values in ecpg regression tests.
Next
From: Tom Lane
Date:
Subject: pgsql: Fix matching of sub-partitions when a partitioned plan is stale.