From: | Jesper Pedersen <jesper(dot)pedersen(at)redhat(dot)com> |
---|---|
To: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> |
Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, Mithun Cy <mithun(dot)cy(at)enterprisedb(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Hash Indexes |
Date: | 2016-09-27 19:06:14 |
Message-ID: | 572845af-2a62-ff9b-5b5d-2b8e6555dd33@redhat.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 09/20/2016 09:02 AM, Amit Kapila wrote:
> On Fri, Sep 16, 2016 at 11:22 AM, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
>>
>> I do want to work on it, but it is always possible that due to some
>> other work this might get delayed. Also, I think there is always a
>> chance that while doing that work, we face some problem due to which
>> we might not be able to use that optimization. So I will go with your
>> suggestion of removing hashscan.c and it's usage for now and then if
>> required we will pull it back. If nobody else thinks otherwise, I
>> will update this in next patch version.
>>
>
> In the attached patch, I have removed the support of hashscans. I
> think it might improve performance by few percentage (especially for
> single row fetch transactions) as we have registration and destroy of
> hashscans.
>
>
I have been running various tests, and applications with this patch
together with the WAL v5 patch [1].
As I havn't seen any failures and doesn't currently have additional
feedback I'm moving this patch to "Ready for Committer" for their feedback.
If others have comments, move the patch status back in the CommitFest
application, please.
Best regards,
Jesper
From | Date | Subject | |
---|---|---|---|
Next Message | Jesper Pedersen | 2016-09-27 19:08:30 | Re: Write Ahead Logging for Hash Indexes |
Previous Message | Tom Lane | 2016-09-27 19:01:53 | Re: Detect supported SET parameters when pg_restore is run |