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 <fg@nuxeo.com>)
Ответы Re: Unique values across a table of arrays - documents and tags  (Florent Guillaume <fg@nuxeo.com>)
Список pgsql-performance
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
Дата:
Сообщение: Re: Unique values across a table of arrays - documents and tags
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2