rd set of keywords in the column 'diagnosis' I
don't think a GIN index would work.
Any ideas on other options I could try?
--Jim
________
From: David Johnston
To: 'Jim Ostler' ; pgsql-general@postgresql.org
Sent: Monday, March 12, 2012 5:2
I have a table that is around 20 GB, so I need to optimize as best as possible
the matching with another table on keywords across multiple fields. I have
around 10 fields that have keywords or phrases delimited with the "or"
operator "|". So it would be in the form of "a | b | and jack | cd