Horton

Fixes for single-page hash index vacuum.

Robert Haas <rhaas@postgresql.org>

View on postgr.es
Commit: 953477ca3526e28f9aeeb41d23b16eed0084c7d2
Author: Robert Haas <rhaas@postgresql.org>
Date: 2017-03-20T19:49:09Z
Releases: 10.0 
Fixes for single-page hash index vacuum.

Clear LH_PAGE_HAS_DEAD_TUPLES during replay, similar to what gets done
for btree.  Update hashdesc.c for xl_hash_vacuum_one_page.

Oversights in commit 6977b8b7f4dfb40896ff5e2175cad7fdbda862eb spotted
by Amit Kapila.  Patch by Ashutosh Sharma.

Bump WAL version.  The original patch to make hash indexes write-ahead
logged probably should have done this, and the single page vacuuming
patch probably should have done it again, but better late than never.

Discussion: http://postgr.es/m/CAA4eK1Kd=mJ9xreovcsh0qMiAj-QqCphHVQ_Lfau1DR9oVjASQ@mail.gmail.com

Files

PathChange+/−
src/backend/access/hash/hash.c modified +6 −1
src/backend/access/hash/hashinsert.c modified +8 −0
src/backend/access/hash/hash_xlog.c modified +21 −0
src/backend/access/rmgrdesc/hashdesc.c modified +10 −1
src/include/access/hash_xlog.h modified +2 −0
src/include/access/xlog_internal.h modified +1 −1

Discussion