Re: WAL Consistency checking for hash indexes
Ashutosh Sharma <ashu.coek88@gmail.com>
From: Ashutosh Sharma <ashu.coek88@gmail.com>
To: Kuntal Ghosh <kuntalghosh.2007@gmail.com>
Cc: Robert Haas <robertmhaas@gmail.com>,
Amit Kapila <amit.kapila16@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2017-03-16T07:45:19Z
Lists: pgsql-hackers
Attachments
- 0001-Allow-WAL-consistency-tool-to-mask-LH_PAGE_HAS_DEAD_.patch (application/x-download) patch 0001
Hi, Attached is the patch that allows WAL consistency tool to mask 'LH_PAGE_HAS_DEAD_TUPLES' flag in hash index. The flag got added as a part of 'Microvacuum support for Hash index' patch . I have already tested it using Kuntal's WAL consistency tool and it works fine. -- With Regards, Ashutosh Sharma EnterpriseDB:http://www.enterprisedb.com On Wed, Mar 15, 2017 at 11:27 AM, Kuntal Ghosh <kuntalghosh.2007@gmail.com> wrote: > On Wed, Mar 15, 2017 at 12:32 AM, Robert Haas <robertmhaas@gmail.com> wrote: >> On Mon, Mar 13, 2017 at 10:36 AM, Ashutosh Sharma <ashu.coek88@gmail.com> wrote: >>> Couple of review comments,, >>> >>> You may also need to update the documentation as now we are also going >>> to support wal consistency check for hash index. The current >>> documentation does not include hash index. >>> >>> + only records originating from those resource managers. Currently, >>> + the supported resource managers are <literal>heap</>, >>> + <literal>heap2</>, <literal>btree</>, <literal>gin</>, >>> + <literal>gist</>, <literal>sequence</>, <literal>spgist</>, >>> + <literal>brin</>, and <literal>generic</>. Only >> >> Did that, committed this. Also ran pgindent over hash_mask() and >> fixed an instance of dubious capitalization. > Thanks Robert for the commit. > > > -- > Thanks & Regards, > Kuntal Ghosh > EnterpriseDB: http://www.enterprisedb.com
Commits
-
Another fix for single-page hash index vacuum.
- 9abbf4727de7 10.0 landed
-
hash: Support WAL consistency checking.
- bb4a39637ac6 10.0 landed