pgsql: Prevent growth of simplehash tables when they're "too empty". - Mailing list pgsql-committers

From Andres Freund
Subject pgsql: Prevent growth of simplehash tables when they're "too empty".
Date
Msg-id E1egF41-0004rH-DA@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Prevent growth of simplehash tables when they're "too empty".

In cases where simplehash tables where filled with either a lot of
conflicting hash-values, or values that hash to consecutive
values (i.e. build "chains") the growth heuristics in
d4c62a6b623d6eef88218158e9fa3cf974c6c7e5 could trigger rather
explosively.

To fix that, address some of the reasons (see previous commit) of why
the growth heuristics where needed, and only allow growth when the
table isn't too empty. While that means there's a few cases of bad
input that can be slower, that seems a lot better than running very
quickly out of memory.

Author: Tomas Vondra and Andres Freund, with additional input by
    Thomas Munro, Tom Lane Todd A. Cook
Reported-By: Todd A. Cook, Tomas Vondra, Thomas Munro
Discussion: https://postgr.es/m/20171127185700.1470.20362@wrigleys.postgresql.org
Backpatch: 10, where simplehash was introduced

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/ab9f2c429d8fbd3580cd2ae5f2054ba6956b1f60

Modified Files
--------------
src/include/lib/simplehash.h | 19 +++++++++++++++----
1 file changed, 15 insertions(+), 4 deletions(-)


pgsql-committers by date:

Previous
From: Peter Eisentraut
Date:
Subject: pgsql: psql documentation fixes
Next
From: Andres Freund
Date:
Subject: pgsql: Backport: Add inline murmurhash32(uint32) function.