Re: pg_migrator and an 8.3-compatible tsvector data type

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_migrator and an 8.3-compatible tsvector data type
Дата
Msg-id 1629.1243549016@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_migrator and an 8.3-compatible tsvector data type  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: pg_migrator and an 8.3-compatible tsvector data type  (Josh Berkus <josh@agliodbs.com>)
Re: pg_migrator and an 8.3-compatible tsvector data type  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
Josh Berkus <josh@agliodbs.com> writes:
> Bruce,
>> The ordering of the lexems was changed:

> What does that get us in terms of performance etc.?

It was changed to support partial-match tsvector queries.  Without it,
a partial match query would have to scan entire tsvectors instead
of applying binary search.  I don't know if Oleg and Teodor did any
actual performance tests on the size of the hit, but it seems like
it could be pretty awful for large documents.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Clean shutdown and warm standby
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_migrator and an 8.3-compatible tsvector data type