| From: | Fabian Kreitner <fabian(dot)kreitner(at)ainea-ag(dot)de> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Improving simple textsearch? |
| Date: | 2003-08-27 14:36:14 |
| Message-ID: | 5.1.0.14.0.20030827162734.03b77c58@195.145.148.245 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
Hi,
can anyone point me to information regarding this please?
Objective is to find entries that match one (or more) supplied strings in
two tables. The first has about 20.000 entries with 1 varchar field to
check, the other about 40.000 with 5 varchar fields to check. The currently
used sequential scan is getting too expensive.
Thanks,
Fabian
| From | Date | Subject | |
|---|---|---|---|
| Next Message | matt | 2003-08-27 14:37:14 | Re: Hardware recommendations to scale to silly load |
| Previous Message | Vivek Khera | 2003-08-27 14:22:02 | Re: Buglist |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | matt | 2003-08-27 14:37:14 | Re: Hardware recommendations to scale to silly load |
| Previous Message | Bill Moran | 2003-08-27 14:17:46 | Re: Hardware recommendations to scale to silly load |