pgsql: Make contrib/btree_gist's GiST penalty function a bit saner.
| От | Tom Lane |
|---|---|
| Тема | pgsql: Make contrib/btree_gist's GiST penalty function a bit saner. |
| Дата | |
| Msg-id | E1U3bcF-0004NY-UC@gemulon.postgresql.org обсуждение исходный текст |
| Список | pgsql-committers |
Make contrib/btree_gist's GiST penalty function a bit saner. The previous coding supposed that the first differing bytes in two varlena datums must have the same sign difference as their overall comparison result. This is obviously bogus for text strings in non-C locales, and probably wrong for numeric, and even for bytea I think it was wrong on machines where char is signed. When the assumption failed, the function could deliver a zero or negative penalty in situations where such a result is quite ridiculous, leading the core GiST code to make very bad page-split decisions. To fix, take the absolute values of the byte-level differences. Also, switch the code to using unsigned char not just char, so that the behavior will be consistent whether char is signed or not. Per investigation of a trouble report from Tomas Vondra. Back-patch to all supported branches. Branch ------ REL9_1_STABLE Details ------- http://git.postgresql.org/pg/commitdiff/cd3dfb02d8008ee4cca4b948172d3189d0163b06 Modified Files -------------- contrib/btree_gist/btree_utils_var.c | 24 ++++++++++-------------- 1 files changed, 10 insertions(+), 14 deletions(-)
В списке pgsql-committers по дате отправления: