[GRLUG] DBMAIL

[Ben DeMott]

I've implemented FAST full text search quite a few times.
Postgre's is great at it, and it's built in and simple to use.
Create Vector's data types as the searchable columns.\
Create GIN indexes on the Vector columns (this is the FAST part)
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)

A few side notes:
Disable Auto Vacuum on this database during large vector modifications
Re-Index after Vector changes
Use the db schema to monitor the vectors - (this would take more time to
explain)

--- I have a script where you give it a list of columns and it automatically
makes FAST FULL TEXT INDEXED COLUMNS :)

In our company we are trying to create some 'synergy' (yes I just used that
word) between our data.
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?


If you want to see fast full text indexing in practice check out:

craigscraper.openleaf.org   -  (CLICK ON SEARCH at the TOP) - things are
still in development so my apologies for any quirks.
 (valid search operators are + AND OR NOT, search operators cannot be
grouped - for the sake of speed)

If you want some code let me know I'd love to share it.

On Thu, Jul 16, 2009 at 10:10 PM, Michael Mol <mikemol at gmail.com> wrote:

> On Thu, Jul 16, 2009 at 10:00 PM, Ben DeMott<ben.demott at gmail.com> wrote:
> > Anyone have any experience with DBMAIL ?
> > I think I'm going to install it at work and to play with it....  The idea
> > seems good.
>
> No, but looking at it makes me wonder what kinds of things I could do
> to make email more searchable.  Body text search, per-header searches,
> etc.  I'd have to put an insert trigger on dbmail's tables to automate
> the processing and push the indexing data into another table whose
> format I control, but it'd be interesting.
>
> --
> :wq
> _______________________________________________
> grlug mailing list
> grlug at grlug.org
> http://shinobu.grlug.org/cgi-bin/mailman/listinfo/grlug
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://shinobu.grlug.org/pipermail/grlug/attachments/20090716/966a0c46/attachment-0001.htm