Horton

Re: Write Ahead Logging for Hash Indexes

Mark Kirkwood <mark.kirkwood@catalyst.net.nz>

View thread View on postgr.es
From: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
To: Amit Kapila <amit.kapila16@gmail.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2016-08-24T06:14:02Z
Lists: pgsql-hackers

Attachments

On 24/08/16 17:01, Mark Kirkwood wrote:
>
> ...actually I was wrong there, only 2 of them were the same. So I've 
> attached a new log of bt's of them all.
>
>
>

And I can reproduce with only 1 session, figured that might be a helpful 
piece of the puzzle (trace attached).

Commits

  1. Add a regression test for snapshot too old with hash indexes.

  2. hash: Add write-ahead logging support.

  3. Improve coding in _hash_addovflpage.

  4. Remove _hash_wrtbuf() in favor of calling MarkBufferDirty().

  5. Improve hash index bucket split behavior.