| From: | "Campbell, Lance" <lance(at)illinois(dot)edu> |
|---|---|
| To: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | best strategy for searching large text fields |
| Date: | 2014-10-31 14:59:48 |
| Message-ID: | B75CD08C73BD3543B97E4EF3964B7D701FC6EC81@CITESMBX1.ad.uillinois.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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<http://illinois.edu/person/lance>
Software Architect
Web Services at Public Affairs
217-333-0382
[University of Illinois at Urbana-Champaign logo]<http://illinois.edu/>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ktm@rice.edu | 2014-10-31 15:15:10 | Re: INT8 / float casting question |
| Previous Message | Filip Rembiałkowski | 2014-10-31 14:58:06 | INT8 / float casting question |