[GRLUG] DBMAIL

[Michael Mol]

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