>
> I have problems with queries over tsearch index.I have a table of books, with
> 1200000 registers. I have created an GIST index over the title and subtitle,
> CREATE INDEX "idxts2_titsub_idx" ON "public"."libros" USING gist
("idxts2_titsub");
Your query didn't use index that you are created..
After CREATE INDEX you mast ran VACUUM (FULL recomended) and REINDEX
The query is: select userid,msg,idxfti from _my_msg0 where idxfti @@
to_tsquery('utf8_russian','хочу & трахаться');
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
