Indexing Hostnames with tsearch2 and fti.c

From: Robert Landrum <rlandrum(at)aol(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Indexing Hostnames with tsearch2 and fti.c
Date: 2007-07-31 19:15:27
Message-ID: 46AF8A4F.20105@aol.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We're currently using the old fti.c code for searching our database.
It's indexing a mixed bag of hostnames, employee names, ticket subjects,
and the like. We hacked it to make it work correctly for hostnames,
ignoring whitespace and periods as word boundaries.

Since were moving to 8.2, we noticed fti.c was no longer included in the
distro. Our hacked version still compiles, bit it appears that everyone
is switching to tsearch2, and now is a good time to update.

Has anyone used tsearch2 for indexing/searching hostnames? What's
involved? I believe it's possible with a custom dictionary, but don't
have any experience with writing them.

We currently index about 500000 records. Will tsearch2 have any trouble
sifting through that many records?

Thanks,

Rob

Browse pgsql-general by date

  From Date Subject
Next Message Mike Haberman 2007-07-31 19:19:49 FOREIGN KEY migration of syntax, help needed
Previous Message mwsenecal 2007-07-31 19:00:43 Re: Require entry of MD5 hash instead of plaintext password?