Re: Write Ahead Logging for Hash Indexes

Amit Kapila <amit.kapila16@gmail.com>

From: Amit Kapila <amit.kapila16@gmail.com>

To: Robert Haas <robertmhaas@gmail.com>

Cc: Jesper Pedersen <jesper.pedersen@redhat.com>, Jeff Janes <jeff.janes@gmail.com>, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2017-02-17T07:25:01Z

Lists: pgsql-hackers

Attachments

0006-Enable-WAL-for-Hash-Indexes.patch (application/octet-stream) patch 0006

On Thu, Feb 16, 2017 at 8:16 PM, Amit Kapila <amit.kapila16@gmail.com> wrote:
> On Thu, Feb 16, 2017 at 7:15 AM, Robert Haas <robertmhaas@gmail.com> wrote:
>
> Attached are refactoring patches.  WAL patch needs some changes based
> on above comments, so will post it later.
>

Attached is a rebased patch to enable WAL logging for hash indexes.
Note, that this needs to be applied on top of refactoring patches [1]
sent in the previous e-mail.

[1]  - https://www.postgresql.org/message-id/CAA4eK1JCk-abtsVMMP8xqGZktUH73ZmLaZ6b_%2B-oCRtRkdqPrQ%40mail.gmail.com

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

Commits

Add a regression test for snapshot too old with hash indexes.
- 42bdaebf1618 10.0 landed
hash: Add write-ahead logging support.
- c11453ce0aea 10.0 landed
Improve coding in _hash_addovflpage.
- e898437460f5 10.0 cited
Remove _hash_wrtbuf() in favor of calling MarkBufferDirty().
- 25216c989384 10.0 cited
Improve hash index bucket split behavior.
- 6d46f4783efe 10.0 cited