Re: Efficient Searching of Large Text Fields - Mailing list pgsql-sql

From Rod Taylor
Subject Re: Efficient Searching of Large Text Fields
Date
Msg-id 1150231421.777.167.camel@home
Whole thread Raw
In response to Efficient Searching of Large Text Fields  ("Aaron Bono" <postgresql@aranya.com>)
Responses Re: Efficient Searching of Large Text Fields
List pgsql-sql
On Tue, 2006-06-13 at 15:30 -0500, Aaron Bono wrote:
> 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?

It won't help at all. Fast partial matches against arrays is nearly
impossible. You might take a look at tsearch though.

-- 



pgsql-sql by date:

Previous
From: "Aaron Bono"
Date:
Subject: Efficient Searching of Large Text Fields
Next
From: PFC
Date:
Subject: Re: Efficient Searching of Large Text Fields