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 - 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 explain)<br><br>--- I have a script where you give it a list of columns and it automatically makes FAST FULL TEXT INDEXED COLUMNS :)<br>
<br>In our company we are trying to create some 'synergy' (yes I just used that word) between our data.<br>We want to store mail messages in postgres so the messages can be 'tagged' and have relationships to other applications (like our customer management software) - Makes sense right?<br>
<br><br>If you want to see fast full text indexing in practice check out:<br><br><a href="http://craigscraper.openleaf.org">craigscraper.openleaf.org</a> - (CLICK ON SEARCH at the TOP) - things are still in development so my apologies for any quirks.<br>
(valid search operators are + AND OR NOT, search operators cannot be grouped - for the sake of speed)<br><br>If you want some code let me know I'd love to share it.<br><br><div class="gmail_quote">On Thu, Jul 16, 2009 at 10:10 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><div></div><div class="h5">On Thu, Jul 16, 2009 at 10:00 PM, Ben DeMott<<a href="mailto:ben.demott@gmail.com">ben.demott@gmail.com</a>> wrote:<br>
> Anyone have any experience with DBMAIL ?<br>
> I think I'm going to install it at work and to play with it.... The idea<br>
> seems good.<br>
<br>
</div></div>No, but looking at it makes me wonder what kinds of things I could do<br>
to make email more searchable. Body text search, per-header searches,<br>
etc. I'd have to put an insert trigger on dbmail's tables to automate<br>
the processing and push the indexing data into another table whose<br>
format I control, but it'd be interesting.<br>
<font color="#888888"><br>
--<br>
: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>
</font></blockquote></div><br>