I sadly have yet to grace a meeting - my life is crazy busy, I'd like to meet everyone so maybe that would be a good reason for me to show up :) instead of just being a shadow of the internets (TUBES)...<br><br>If people are interested in how and why lexemes / fast full text / porter stemmer algorithm works (or just want to make a search engine) I have lots of code and experience wrapped up in my brain to share :).<br>
<br><div class="gmail_quote">On Thu, Jul 16, 2009 at 10:56 PM, Michael Mol <span dir="ltr"><<a href="mailto:mikemol@gmail.com">mikemol@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="im">On Thu, Jul 16, 2009 at 10:19 PM, Ben DeMott<<a href="mailto:ben.demott@gmail.com">ben.demott@gmail.com</a>> wrote:<br>
> I've implemented FAST full text search quite a few times.<br>
> Postgre's is great at it, and it's built in and simple to use.<br>
> Create Vector's data types as the searchable columns.\<br>
> Create GIN indexes on the Vector columns (this is the FAST part)<br>
> put triggers on the source columns to add vectors to the searchable columns<br>
> - or have a program occasionally update the vectors (not a big deal)<br>
><br>
> A few side notes:<br>
> Disable Auto Vacuum on this database during large vector modifications<br>
> Re-Index after Vector changes<br>
> Use the db schema to monitor the vectors - (this would take more time to<br>
> explain)<br>
<br>
</div>Do I sense a topic for a presentation at next month's meeting? :P<br>
<font color="#888888"><br>
--<br>
</font><div><div></div><div class="h5">:wq<br>
_______________________________________________<br>
grlug mailing list<br>
<a href="mailto:grlug@grlug.org">grlug@grlug.org</a><br>
<a href="http://shinobu.grlug.org/cgi-bin/mailman/listinfo/grlug" target="_blank">http://shinobu.grlug.org/cgi-bin/mailman/listinfo/grlug</a><br>
</div></div></blockquote></div><br>