| 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: | Whole Thread | Raw Message | 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 |
| 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 |