pgsql: Fixes for single-page hash index vacuum.

From: Robert Haas <rhaas(at)postgresql(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Fixes for single-page hash index vacuum.
Date: 2017-03-20 19:54:35
Message-ID: E1cq3Nz-0006BN-E1@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/953477ca3526e28f9aeeb41d23b16eed0084c7d2

Modified Files
--------------
src/backend/access/hash/hash.c | 7 ++++++-
src/backend/access/hash/hash_xlog.c | 21 +++++++++++++++++++++
src/backend/access/hash/hashinsert.c | 8 ++++++++
src/backend/access/rmgrdesc/hashdesc.c | 11 ++++++++++-
src/include/access/hash_xlog.h | 2 ++
src/include/access/xlog_internal.h | 2 +-
6 files changed, 48 insertions(+), 3 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Robert Haas 2017-03-20 19:58:24 pgsql: Another fix for single-page hash index vacuum.
Previous Message Tom Lane 2017-03-20 17:35:37 pgsql: Add configure test to see if the C compiler has gcc-style comput