pgsql: Improve GiST index search performance for trigram regex queries.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема pgsql: Improve GiST index search performance for trigram regex queries.
Дата
Msg-id E1URmb3-0004ak-NM@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Improve GiST index search performance for trigram regex queries.

The initial coding just descended the index if any of the target trigrams
were possibly present at the next level down.  But actually we can apply
trigramsMatchGraph() so as to take advantage of AND requirements when there
are some.  The input data might contain false positive matches, but that
can only result in a false positive result, not false negative, so it's
safe to do it this way.

Alexander Korotkov

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/410bed2ab8c3864d7f34f9694d080adcaf446352

Modified Files
--------------
contrib/pg_trgm/trgm_gist.c |   20 +++++++++++++-------
1 files changed, 13 insertions(+), 7 deletions(-)


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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: pgsql: Add serial comma
Следующее
От: Andrew Dunstan
Дата:
Сообщение: pgsql: Correct handling of NULL arguments in json funcs.