From: Sumeet <asumeet@gmail.com>
To: Andrew Sullivan <ajs@crankycanuck.ca>
Cc: pgsql-sql@postgresql.org
Subject: Re: Multiple DB join
Date: Fri, 18 Aug 2006 11:07:24 -0400
Message-ID: <7539aebb0608180807j4ca4da62l4e464f4ea4eaa984@mail.gmail.com> (raw)
In-Reply-To: <20060815144539.GE21939@phlogiston.dyndns.org>
References: <44E0EA72.2090505@indiana.edu>
<20060815103624.GA21634@phlogiston.dyndns.org>
<44E1D61D.4020400@indiana.edu>
<20060815141712.GB21939@phlogiston.dyndns.org>
<7539aebb0608150735l34e59630m25487549c8e6de2d@mail.gmail.com>
<20060815144539.GE21939@phlogiston.dyndns.org>
On 8/15/06, Andrew Sullivan <ajs@crankycanuck.ca> wrote:
> > I previously thought of doing the full text search indexing thing...but
> i
> > had a intution that the full text search thing is for fields which have
> very
> > large strings.......but in my case the strings are not above 200 chars
> in
>
> No, it's for data where you're going to be searching in random pieces
> of the text. I think you should look at tsearch2, probably.
Will the full text search indexing help me achive a good speed in searching
keywords???
If you had any way to enforce bounded searches, it'd be a different
> matter: strings with initial matches but an unbound end are fast.
> (You can do it the other way, too, by some tricks with reversing the
> strings.)
can someone plz ellaborate a little about ways we can enforce bounded
searches?. I'm basically trying a simple search
i.e. trying to find name of authors user enters into a interface against the
20 miliions records in my db. Can anyone suggest a good way to perform this
kind of search ?.
Thanks,
Sumeet.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: asumeet@gmail.com, ajs@crankycanuck.ca
Subject: Re: Multiple DB join
In-Reply-To: <7539aebb0608180807j4ca4da62l4e464f4ea4eaa984@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox