Re: pg_migrator and an 8.3-compatible tsvector data type - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: pg_migrator and an 8.3-compatible tsvector data type
Date
Msg-id 4A1F0E1B.7060704@agliodbs.com
Whole thread Raw
In response to Re: pg_migrator and an 8.3-compatible tsvector data type  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom,

> 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.

Ah, ok, that's pretty significant.  It makes a huge difference for some 
users, one of whom will be quoted on the press release.

-- 
Josh Berkus
PostgreSQL Experts Inc.
www.pgexperts.com


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_migrator and an 8.3-compatible tsvector data type
Next
From: Bruce Momjian
Date:
Subject: Re: pg_migrator and an 8.3-compatible tsvector data type