Search Postgresql Archives

Re: Multicolumn index including tsvector.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

Perfect!  Thanks, Tom.  The query plan now shows it considering both columns in the index condition.

Kris

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux