[GENERAL] PostgreSQL GIN index not used when ts_query language is fetched from a column

2016-09-15 Thread Jaap Roes
I've got a table that stores some multilingual content: CREATE TABLE search ( content text NOT NULL, language regconfig NOT NULL, fulltext tsvector ); CREATE INDEX search_fulltext ON search USING GIN(fulltext); INSERT INTO search (language, content) VALUES

Re: [GENERAL] PostgreSQL GIN index not used when ts_query language is fetched from a column

2016-09-15 Thread Jaap Roes
> On 15 Sep 2016, at 14:46, Jaap Roes wrote: > > I've got a table that stores some multilingual content: > >CREATE TABLE search ( > content text NOT NULL, > language regconfig NOT NULL, > fulltext tsvector >); >CREATE INDEX