Re: levenshtein_less_equal (was: multibyte charater set in levenshtein function)

Поиск
Список
Период
Сортировка
От Alexander Korotkov
Тема Re: levenshtein_less_equal (was: multibyte charater set in levenshtein function)
Дата
Msg-id AANLkTik5AkOahj3GL6ssZCOaRWgSmcc=Pp3kj4vdnZyb@mail.gmail.com
обсуждение исходный текст
Ответ на Re: levenshtein_less_equal (was: multibyte charater set in levenshtein function)  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: levenshtein_less_equal (was: multibyte charater set in levenshtein function)  (Alexander Korotkov <aekorotkov@gmail.com>)
Список pgsql-hackers
> No doubt, but the actual function runtime is only one component of the<br />> cost of applying it to a lot of
dictionaryentries --- I would think<br />> that the table read costs are the larger component anyway.<br /><br
/>Datadomain can be not only dictionary but also something like article titles, urls and so on. On such relatively long
strings(about 100 characters and more) this component will be significant (especially if most part of the table is
lyingin cache). In this case search of near strings can be accelerated in more than 10 times. I think that this use
casejustifies presence of separate leveshtein_less_equal function.<br /><br />----<br />With best regards,<br
/>AlexanderKorotkov.  

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: SQL command to edit postgresql.conf, with comments
Следующее
От: Alexander Korotkov
Дата:
Сообщение: Re: levenshtein_less_equal (was: multibyte charater set in levenshtein function)