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
>> From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Jim Ostler
>> Sent: Monday, March 12, 2012 6:57 PM
>> To: pgsql-general@postgresql.org
>> Subject: [GENERAL] Matching on keyword or phrases within a field that is
delimit
On Mon, 2012-03-12 at 15:57 -0700, Jim Ostler wrote:
> 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 "|"
7 PM
Subject: RE: [GENERAL] Matching on keyword or phrases within a field that is
delimited with an "or" operator "|"
>> From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Jim Ostler
>> Sent: Monday, March 12, 2012 6:57 P