Re: Unique values across a table of arrays - documents and tags

Поиск
Список
Период
Сортировка
Искать
От
Ivan Voras
Тема
Re: Unique values across a table of arrays - documents and tags
Дата
Msg-id
k7e0jp$b94$1@ger.gmane.org
Ответ на
Список
Дерево обсуждения
Unique values across a table of arrays - documents and tags Ivan Voras <ivoras@freebsd.org>
Re: Unique values across a table of arrays - documents and tags François Beausoleil <francois@teksol.info>
Re: Unique values across a table of arrays - documents and tags Ivan Voras <ivoras@freebsd.org>
Re: Unique values across a table of arrays - documents and tags Florent Guillaume <fg@nuxeo.com>
Re: Unique values across a table of arrays - documents and tags Ivan Voras <ivoras@freebsd.org>
Re: Unique values across a table of arrays - documents and tags Florent Guillaume <fg@nuxeo.com>
On 07/11/2012 16:54, Florent Guillaume wrote:
> Maybe you could store the tags as fulltext words, query them using
> fulltext search, and use ts_stat to gather the list of words? Needs to
> be benched of course.
> You'll probably need to change the config to avoid stemming and stop words.

I have thought of that but decided not to even try because fts will also
use GIN and the combination of fts on a text field + GIN cannot possibly
be faster than just GIN on an array...

В списке pgsql-performance по дате отправления
От: Florent Guillaume
Дата:
От: Merlin Moncure
Дата:
FAQ