Re: Page Scan Mode in Hash Index

Ashutosh Sharma <ashu.coek88@gmail.com>

View thread View on postgr.es

From: Ashutosh Sharma <ashu.coek88@gmail.com>

To: Jesper Pedersen <jesper.pedersen@redhat.com>

Cc: pgsql-hackers <pgsql-hackers@postgresql.org>, Robert Haas <robertmhaas@gmail.com>

Date: 2017-04-01T07:07:24Z

Lists: pgsql-hackers

Attachments

0001-Rewrite-hash-index-scans-to-work-a-page-at-a-timev5.patch (text/x-patch) patch 0001
0002-Remove-redundant-function-_hash_step-and-some-of-the.patch (text/x-patch) patch 0002
0003-Improve-locking-startegy-during-VACUUM-in-Hash-Index.patch (text/x-patch) patch 0003

Hi,

>
> On 03/29/2017 09:16 PM, Ashutosh Sharma wrote:
>>>
>>> This patch needs a rebase.
>>
>>
>> Please try applying these patches on top of [1]. I think you should be
>> able
>> to apply it cleanly. Sorry, I think I forgot to mention this point in my
>> earlier mail.
>>
>> [1] -
>>
>> https://www.postgresql.org/message-id/CAE9k0P%3DV2LhtyeMXd295fhisp%3DNWUhRVJ9EZQCDowWiY9rSohQ%40mail.gmail.com
>>
>
> Thanks, that works !
>
> As you have provided a patch for Robert's comments, and no other review have
> been posted I'm moving this patch to "Ready for Committer" for additional
> committer feedback.

Please find the attached new version of patches for page scan mode in
hash index rebased on top of - [1].

[1] - https://www.postgresql.org/message-id/CAE9k0P%3D3rtgUtxopG%2BXQVxgASFzAnGd9sNmYUaj_%3DKeVsKGUdA%40mail.gmail.com

Commits

Remove lsn from HashScanPosData.
- 22c5e73562c5 11.0 landed
Fix trivial mistake in README.
- 79a4a665c046 11.0 landed
hash: Implement page-at-a-time scan.
- 7c75ef571579 11.0 landed
Reduce pinning and buffer content locking for btree scans.
- 2ed5b87f96d4 9.5.0 cited