Re: pg_migrator and an 8.3-compatible tsvector data type

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