pgsql: Fix deduplication "single value" strategy bug.
От | Peter Geoghegan |
---|---|
Тема | pgsql: Fix deduplication "single value" strategy bug. |
Дата | |
Msg-id | E1jmJPs-0004yH-RZ@gemulon.postgresql.org обсуждение исходный текст |
Список | pgsql-committers |
Fix deduplication "single value" strategy bug. It was possible for deduplication's single value strategy to mistakenly believe that a very small duplicate tuple counts as one of the six large tuples that it aims to leave behind after the page finally splits. This could cause slightly suboptimal space utilization with very low cardinality indexes, though only under fairly narrow conditions. To fix, be particular about what kind of tuple counts as a maxpostingsize-capped tuple. This avoids confusion in the event of a small tuple that gets "wedged" between two large tuples, where all tuples on the page are duplicates of the same value. Discussion: https://postgr.es/m/CAH2-Wz=Y+sgSFc-O3LpiZX-POx2bC+okec2KafERHuzdVa7-rQ@mail.gmail.com Backpatch: 13-, where deduplication was introduced (by commit 0d861bbb) Branch ------ REL_13_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/dedb92d4a3adc6b5165a619383739ab05d24b24d Modified Files -------------- src/backend/access/nbtree/nbtdedup.c | 41 ++++++++++++++++++++++++------------ src/backend/access/nbtree/nbtsort.c | 2 ++ src/backend/access/nbtree/nbtxlog.c | 1 + src/include/access/nbtree.h | 1 + 4 files changed, 32 insertions(+), 13 deletions(-)
В списке pgsql-committers по дате отправления: