Improving simple textsearch?

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

In response to

Browse pgsql-hackers by date

  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

Browse pgsql-performance by date

  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