[GENERAL] Having performance problems with TSearch2

I have problems with queries over tsearch index. I have a table of books, with 120 registers. I have created an GIST index over the title and subtitle, CREATE INDEX "idxts2_titsub_idx" ON "public"."libros" USING gist ("idxts2_titsub"); My problems started when i execute my queries. For examp

Re: [GENERAL] Having performance problems with TSearch2

Use GIN index instead of GiST I have a table of books, with 120 registers. I have created an GIST index over the title and subtitle, -- Teodor Sigaev E-mail: [EMAIL PROTECTED] WWW: http://www.sigaev.ru/ --

[GENERAL] Having performance problems with TSearch2

I have problems with queries over tsearch index. I have a table of books, with 120 registers. I have created an GIST index over the title and subtitle, CREATE INDEX "idxts2_titsub_idx" ON "public"."libros" USING gist ("idxts2_titsub"); My problems started when i execute my queries. For examp