best strategy for searching large text fields
От | Campbell, Lance |
---|---|
Тема | best strategy for searching large text fields |
Дата | |
Msg-id | B75CD08C73BD3543B97E4EF3964B7D701FC6EC81@CITESMBX1.ad.uillinois.edu обсуждение исходный текст |
Ответы |
Re: best strategy for searching large text fields
|
Список | pgsql-sql |
<div class="WordSection1"><p class="MsoNormal">PostgreSQL 9.3.x<p class="MsoNormal">I am looking for really good documentationon how to do the following.<p class="MsoNormal"> <p class="MsoNormal">Use Case<p class="MsoNormal">I have aweb application that will be storing into a table large blocks of HTML web content. Users will then want to search thesefields for phrases. What is the best strategy for handling this in PostgreSQL? <p class="MsoNormal"> <p class="MsoNormal">Whatwould the SQL look like? <p class="MsoNormal">What data type should the web content field be in thetable? <p class="MsoNormal">Is there a way to set up the SQL so that matches are best match to least accurate match?<pclass="MsoNormal">Etc…<p class="MsoNormal"> <p class="MsoNormal"> <p class="MsoNormal"> <p class="MsoNormal"> <pclass="MsoNormal">Thanks,<p class="MsoNormal"> <p class="MsoNormal"><a href="http://illinois.edu/person/lance">LanceCampbell</a><p class="MsoNormal">Software Architect<p class="MsoNormal">WebServices at Public Affairs<p class="MsoNormal">217-333-0382 <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><ahref="http://illinois.edu/"><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:blue;text-decoration:none"><imgalt="University of Illinoisat Urbana-Champaign logo" border="0" height="25" id="Picture_x0020_1" src="cid:image001.png@01CFF4F1.3F732480" width="150"/></span></a><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:blue"></span><p class="MsoNormal"> <pclass="MsoNormal"> </div>
В списке pgsql-sql по дате отправления: