pgsql: Second pass at improving LIKE/regex estimation in non-C locales.

Поиск
Список
Период
Сортировка
От tgl@postgresql.org (Tom Lane)
Тема pgsql: Second pass at improving LIKE/regex estimation in non-C locales.
Дата
Msg-id 20071109201002.3BB507540F0@cvs.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Log Message:
-----------
Second pass at improving LIKE/regex estimation in non-C locales.  It turns
out that it's actually quite likely that a string that is an extension of
the given prefix will sort as larger than the "greater" string our previous
code created.  To provide some defense against that, do the comparisons
against a modified string instead of just the bare prefix.  We tack on
"Z", "z", "y", or "9", whichever is seen as largest in the current locale.
Testing suggests that this is sufficient at least for cases involving
ASCII data.

Modified Files:
--------------
    pgsql/src/backend/utils/adt:
        selfuncs.c (r1.238 -> r1.239)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/selfuncs.c?r1=1.238&r2=1.239)

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

Предыдущее
От: Gregory Stark
Дата:
Сообщение: Re: pgsql: If an index depends on no columns of its table, give it a
Следующее
От: tgl@postgresql.org (Tom Lane)
Дата:
Сообщение: pgsql: Second pass at improving LIKE/regex estimation in non-C locales.