From: | Ares <abaidulin(at)rambler(dot)ru> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Having performance problems with TSearch2 |
Date: | 2007-03-05 12:59:59 |
Message-ID: | loom.20070305T135429-492@post.gmane.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-performance |
>
> 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','хочу & трахаться');
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2007-03-05 13:20:49 | Re: PostgreSQL 8.2.3 VACUUM Timings/Performance |
Previous Message | pascalvdg | 2007-03-05 12:47:32 | Permission problem using lo_export |
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2007-03-05 13:20:49 | Re: PostgreSQL 8.2.3 VACUUM Timings/Performance |
Previous Message | Bruce McAlister | 2007-03-05 12:33:18 | PostgreSQL 8.2.3 VACUUM Timings/Performance |