From: | "Mitch Vincent" <mitch(at)venux(dot)net> |
---|---|
To: | "Vassili A Akimov" <vassili(at)erols(dot)com>, <pgsql-sql(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Need to improve performance |
Date: | 2000-06-23 14:53:41 |
Message-ID: | 006d01bfdd22$d3129460$0300000a@doot.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
> vacuum;
> vacuum analyze;
> select f1.id from app_fti f1, app_fti f2 where f1.string~*'visual' and
> f2.string~*'basic' and f1.id=f2.id;
Use ~*'^basic'
It will use the indexes I believe. Also, enable likeplanning (look in
contrib/likeplanning) -- it will speed things up too.. If that doesn't help
then use EXPLAIN to get your query plan and post it, I'll try to help
further... I'm doing this exact thing, so have some experience on tweaking
it (Thanks again Tom!) :-)
I'd bet what's happening is you're doing a seq scan, not something you want
to do on that big of a table. (I know that's what's happening with using
~*'whatever' )
Make good use of the stop words in fti.c too (be sure to order them, it's a
binary search).
Hope that helps..
-Mitch
From | Date | Subject | |
---|---|---|---|
Next Message | Luiz Antonio | 2000-06-23 15:20:33 | Show tables! |
Previous Message | Jim Mercer | 2000-06-23 14:49:28 | followup to SELECT/INSERT problem |
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Hoffmann | 2000-06-23 15:42:26 | Re: Merging two columns into one |
Previous Message | Mitch Vincent | 2000-06-23 14:29:59 | Orderby two different columns |