Re: Improve Search - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Improve Search
Date
Msg-id dcc563d10711012032wee9f457n28ced62137e8edb2@mail.gmail.com
Whole thread Raw
In response to Improve Search  (carter ck <carterck32@hotmail.com>)
Responses Re: Improve Search  (carter ck <carterck32@hotmail.com>)
List pgsql-general
On 11/1/07, carter ck <carterck32@hotmail.com> wrote:
>
> Hi all,
>
> Has anyone come across a solution for faster and powerful search stored procedure in a table that contains more than
500Kof records? 
>
> I am currently trying to work around with it. All helps are appreciated.

Are you using the tsearch2 full text engine?  If not, you're missing
the boat for fast searching text.  But you didn't really tell us what
exactly you're searching on, so I'm just guessing.

pgsql-general by date:

Previous
From: Ow Mun Heng
Date:
Subject: Re: Calculation for Max_FSM_pages : Any rules of thumb?
Next
From: Kevin Hunter
Date:
Subject: young guy wanting (Postgres DBA) ammo