Re: [GENERAL] Matching on keyword or phrases within a field that is delimited with an "or" operator "|"

2012-03-13 Thread Jim Ostler
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

[GENERAL] Matching on keyword or phrases within a field that is delimited with an "or" operator "|"

2012-03-12 Thread Jim Ostler
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