Kris Gale <krisgale(at)gmail(dot)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