pgsql: Fix the overrun in hash index metapage for smaller block sizes.

Поиск
Список
Период
Сортировка
От Amit Kapila
Тема pgsql: Fix the overrun in hash index metapage for smaller block sizes.
Дата
Msg-id E1fxmQQ-0006Y0-LS@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Fix the overrun in hash index metapage for smaller block sizes.

The commit 620b49a1 changed the value of HASH_MAX_BITMAPS with the intent
to allow many non-unique values in hash indexes without worrying to reach
the limit of the number of overflow pages.  At that time, this didn't
occur to us that it can overrun the block for smaller block sizes.

Choose the value of HASH_MAX_BITMAPS based on BLCKSZ such that it gives
the same answer as now for the cases where the overrun doesn't occur, and
some other sufficiently-value for the cases where an overrun currently
does occur.  This allows us not to change the behavior in any case that
currently works, so there's really no reason for a HASH_VERSION bump.

Author: Dilip Kumar
Reviewed-by: Amit Kapila
Backpatch-through: 10
Discussion: https://postgr.es/m/CAA4eK1LtF4VmU4mx_+i72ff1MdNZ8XaJMGkt2HV8+uSWcn8t4A@mail.gmail.com

Branch
------
REL_10_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/916afca45d99c8e736eb45aeec9ef256967bc1e2

Modified Files
--------------
src/include/access/hash.h | 7 +++++--
1 file changed, 5 insertions(+), 2 deletions(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Andrew Gierth
Дата:
Сообщение: pgsql: Allow extensions to install built as well as unbuilt headers.
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: pgsql: Allow extensions to install built as well as unbuiltheaders.