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

On Wed, Nov 7, 2012 at 5:00 PM, Ivan Voras <ivoras(at)freebsd(dot)org> wrote:
> 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...

Unless ts_stat itself is optimized to reach inside the index to fetch
its statistics, but I don't think that's the case.

Florent

--
Florent Guillaume, Director of R&D, Nuxeo
Open Source, Java EE based, Enterprise Content Management (ECM)
http://www.nuxeo.com http://www.nuxeo.org +33 1 40 33 79 87