Re: [POC] A better way to expand hash indexes.

Mithun Cy <mithun.cy@enterprisedb.com>

From: Mithun Cy <mithun.cy@enterprisedb.com>

To: Robert Haas <robertmhaas@gmail.com>

Cc: Bruce Momjian <bruce@momjian.us>, Amit Kapila <amit.kapila16@gmail.com>, David Steele <david@pgmasters.net>, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2017-04-01T07:29:47Z

Lists: pgsql-hackers

Attachments

sortbuild_hash_A_2.patch (application/octet-stream) patch
yet_another_expand_hashbucket_efficiently_15.patch (application/octet-stream) patch

On Sat, Apr 1, 2017 at 12:31 PM, Mithun Cy <mithun.cy@enterprisedb.com> wrote:

> Also adding a patch which implements the 2nd way.
Sorry, I forgot to add sortbuild_hash patch, which also needs similar
changes for the hash_mask.


-- 
Thanks and Regards
Mithun C Y
EnterpriseDB: http://www.enterprisedb.com

Commits

Fix formula in _hash_spareindex.
- b38006ef6d1b 10.0 landed
Expand hash indexes more gradually.
- ea69a0dead51 10.0 landed
Change hash indexes to store only the hash code rather than the whole indexed
- 4adc2f72a4cc 8.4.0 cited