Horton

Port single-page btree vacuum logic to hash indexes.

Robert Haas <rhaas@postgresql.org>

View on postgr.es
Commit: 6977b8b7f4dfb40896ff5e2175cad7fdbda862eb
Author: Robert Haas <rhaas@postgresql.org>
Date: 2017-03-16T02:18:56Z
Releases: 10.0 
Port single-page btree vacuum logic to hash indexes.

This is advantageous for hash indexes for the same reasons it's good
for btrees: it accelerates space recycling, reducing bloat.

Ashutosh Sharma, reviewed by Amit Kapila and by me.  A bit of
additional hacking by me.

Discussion: http://postgr.es/m/CAE9k0PkRSyzx8dOnokEpUi2A-RFZK72WN0h9DEMv_ut9q6bPRw@mail.gmail.com

Files

PathChange+/−
src/backend/access/hash/hash.c modified +44 −9
src/backend/access/hash/hashinsert.c modified +118 −3
src/backend/access/hash/hashsearch.c modified +8 −0
src/backend/access/hash/hashsort.c modified +2 −2
src/backend/access/hash/hashutil.c modified +68 −0
src/backend/access/hash/hash_xlog.c modified +237 −0
src/backend/access/hash/README modified +4 −1
src/backend/access/rmgrdesc/hashdesc.c modified +2 −0
src/include/access/hash.h modified +15 −2
src/include/access/hash_xlog.h modified +19 −0

Discussion