From: | Andrew <archa(at)pacific(dot)net(dot)au> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Full Text Search - i18n |
Date: | 2008-06-25 06:18:58 |
Message-ID: | 4861E352.5050206@pacific.net.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Apologies if this question has been previously covered, but I was not
able to find something similar in any of the mailing list archives.
With full text search, if you need to support a table where the content
of individual tuples/rows may be in different languages with the
language of the content known, and the content of any individual row
does _not_ contain a mixture of languages, what is the best way to
design for this?
Would you create a different GIN/GiST index of the tsvector for each
language? Or if using columns to store the tsvector, would you have a
different column per language, or the one column with the associated
trigger using the appropriate language when building the tsvector for
that row?
Are there better alternatives than what I have listed?
Thanks,
Andy
From | Date | Subject | |
---|---|---|---|
Next Message | Asko Oja | 2008-06-25 06:20:27 | Re: replication |
Previous Message | Ow Mun Heng | 2008-06-25 06:15:26 | Re: LIKE not using indexes (due to locale issue?) |