Re: Unique values across a table of arrays - documents and tags - Mailing list pgsql-performance

From Ivan Voras
Subject Re: Unique values across a table of arrays - documents and tags
Date
Msg-id k7e0jp$b94$1@ger.gmane.org
Whole thread Raw
In response to Re: Unique values across a table of arrays - documents and tags  (Florent Guillaume <fg@nuxeo.com>)
Responses Re: Unique values across a table of arrays - documents and tags
List 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...


Attachment

pgsql-performance by date:

Previous
From: Florent Guillaume
Date:
Subject: Re: Unique values across a table of arrays - documents and tags
Next
From: Merlin Moncure
Date:
Subject: Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2