Re: WAL Consistency checking for hash indexes

Amit Kapila <amit.kapila16@gmail.com>

From: Amit Kapila <amit.kapila16@gmail.com>
To: Ashutosh Sharma <ashu.coek88@gmail.com>
Cc: Kuntal Ghosh <kuntalghosh.2007@gmail.com>, Robert Haas <robertmhaas@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2017-03-17T12:30:52Z
Lists: pgsql-hackers
On Fri, Mar 17, 2017 at 12:30 PM, Ashutosh Sharma <ashu.coek88@gmail.com> wrote:
> On Fri, Mar 17, 2017 at 9:03 AM, Amit Kapila <amit.kapila16@gmail.com> wrote:
>> On Thu, Mar 16, 2017 at 1:15 PM, Ashutosh Sharma <ashu.coek88@gmail.com> wrote:
>>> 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.
>>>
>>
>> + * unlogged. So, mask it. See _hash_kill_items(), MarkBufferDirtyHint()
>> + * for
>> details.
>> + */
>>
>> I think in above comment, a reference to _hash_kill_items is
>> sufficient.  Other than that patch looks okay.
>
> Okay, I have removed the reference to MarkBufferDirtyHint() from above
> comment. Attached is the v2 version of patch.
>

Thanks, this version looks good to me.



-- 
With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com


Commits

  1. Another fix for single-page hash index vacuum.

  2. hash: Support WAL consistency checking.