| From: | Andreas Wenk <a(dot)wenk(at)netzmeister-st-pauli(dot)de> |
|---|---|
| To: | John Cheng <jlcheng(at)ymail(dot)com>, PG-General Mailing List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Problem search on text arrays, using the overlaps (&&) operator |
| Date: | 2009-07-03 09:12:46 |
| Message-ID: | 4A4DCB8E.50800@netzmeister-st-pauli.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
John Cheng schrieb:
> -----------
> For some reason, I am seeing a big difference in our real database. I
> don't want to just rewrite all of our queries yet. I'm guessing the
> data makes a big difference. What would be a good way to examine the
> data to figure out what's the best way to write our queries? Is there
> any features in PostgreSQL that can help me improve the performance?
>
> Any advice would be greatly appreciated!
Hi,
did you think about using the fulltext search integrated up from version 8.3. I never used
your approach and don't know if the fulltextsearch is suitable for your case ... just a hint.
http://www.postgresql.org/docs/8.4/interactive/textsearch.html
Cheers
Andy
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joost Kraaijeveld | 2009-07-03 09:18:02 | Howto get the contents of mystopwords/dictionary/synonym/thesaurus ? |
| Previous Message | Peter Eisentraut | 2009-07-03 08:37:16 | Re: Installing plpython on 8.4 |