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(-)
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 |