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...
Attachment:
signature.asc
Description: OpenPGP digital signature