Re: Multicolumn index including tsvector.

Kris Gale <krisgale@gmail.com> writes:
> So what I'm expecting here is that it'll be able to use one of those
> composite indexes to satisfy both the user_id and the vectors constraints.
> That doesn't seem to be the case, based on this query plan:

> explain analyze select body from example where user_id=1 and vectors @@
> to_tsquery('simple', 'when') limit 10;

Try coercing the '1' to a bigint.  I don't believe the btree_gist
opclasses have any support for cross-type operators.

            regards, tom lane