Efficient Searching of Large Text Fields

From: "Aaron Bono" <postgresql(at)aranya(dot)com>
To: PostgreSQL <pgsql-sql(at)postgresql(dot)org>
Subject: Efficient Searching of Large Text Fields
Date: 2006-06-13 20:30:44
Message-ID: bf05e51c0606131330w75fd9b84ke63778a22ee0b2d9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

In another post on a different topic, Rod Taylor said the following:

"A\tcat in the\nhat" might be stored as ARRAY['A', 'cat', 'in', 'the', 'hat'].

This got me thinking. I have a discussion forum for gamers and want
to provide searching capabilities so the user can type in a phrase
like "magical bow" and get all posts, sorted by relevance that contain
these words.

My questions are:
1. Will storing the posts in an ARRAY help improve performance of
these searches? If so, by how much?
2. What functions or libraries are available to make such searching
easy to implement well?
3. What is the best way to sort by relevance?

Thanks,
Aaron Bono

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Rod Taylor 2006-06-13 20:43:41 Re: Efficient Searching of Large Text Fields
Previous Message operationsengineer1 2006-06-13 18:31:41 Re: COPY to table with array columns (Longish)