[GRLUG] DBMAIL

[Ben DeMott]

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)...

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 :).

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

> On Thu, Jul 16, 2009 at 10:19 PM, Ben DeMott<ben.demott at gmail.com> wrote:
> > 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)
>
> Do I sense a topic for a presentation at next month's meeting? :P
>
> --
> :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/36d85d2f/attachment.htm