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
Ответ на
Re: Unique values across a table of arrays - documents and tags (Florent Guillaume)
Список
Дерево обсуждения
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
Дата: