Re: WAL Consistency checking for hash indexes

From: Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>
To: Kuntal Ghosh <kuntalghosh(dot)2007(at)gmail(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: WAL Consistency checking for hash indexes
Date: 2017-03-16 07:45:19
Message-ID: CAE9k0PnQtOJ+YmyQ+gdcM912On+x+HH_4Pfq_uBuwHB_QfUgYA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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(dot)2007(at)gmail(dot)com> wrote:
> On Wed, Mar 15, 2017 at 12:32 AM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
>> On Mon, Mar 13, 2017 at 10:36 AM, Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)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

Attachment Content-Type Size
0001-Allow-WAL-consistency-tool-to-mask-LH_PAGE_HAS_DEAD_.patch application/x-download 1.2 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Ashutosh Bapat 2017-03-16 07:47:01 Re: Partitioned tables and relfilenode
Previous Message Ashutosh Sharma 2017-03-16 07:32:54 Re: Microvacuum support for Hash Index