On Wed, Nov 7, 2012 at 5:00 PM, Ivan Voras <ivoras@xxxxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
