best strategy for searching large text fields - Mailing list pgsql-sql

From Campbell, Lance
Subject best strategy for searching large text fields
Date
Msg-id B75CD08C73BD3543B97E4EF3964B7D701FC6EC81@CITESMBX1.ad.uillinois.edu
Whole thread Raw
Responses Re: best strategy for searching large text fields
List pgsql-sql

PostgreSQL 9.3.x

I am looking for really good documentation on how to do the following.

 

Use Case

I have a web application that will be storing into a table large blocks of HTML web content.  Users will then want to search these fields for phrases.  What is the best strategy for handling this in PostgreSQL? 

 

What would the SQL look like? 

What data type should the web content field be in the table? 

Is there a way to set up the SQL so that matches are best match to least accurate match?

Etc…

 

 

 

 

Thanks,

 

Lance Campbell

Software Architect

Web Services at Public Affairs

217-333-0382

University of Illinois at Urbana-Champaign logo

 

 

pgsql-sql by date:

Previous
From: Filip Rembiałkowski
Date:
Subject: INT8 / float casting question
Next
From: "ktm@rice.edu"
Date:
Subject: Re: INT8 / float casting question