Postgres Pro
Downloads
Home   >   mailing lists

Improving simple textsearch? - Mailing list pgsql-performance

From Fabian Kreitner
Subject Improving simple textsearch?
Date
Msg-id 5.1.0.14.0.20030827162734.03b77c58@195.145.148.245
Whole thread Raw
In response to Re: Hardware recommendations to scale to silly load  (Bill Moran <wmoran@potentialtech.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: matt
Date:
Subject: Re: Hardware recommendations to scale to silly load
Next
From: Michael Guerin
Date:
Subject: Simple queries take forever to run