From: Ivan Voras <ivoras@freebsd.org>
To: pgsql-performance@postgresql.org
Subject: Re: Unique values across a table of arrays - documents and tags
Date: Wed, 07 Nov 2012 17:00:59 +0100
Message-ID: <k7e0jp$b94$1@ger.gmane.org> (raw)
In-Reply-To: <CAF-4BpNpeE9+0mYFqRPjaTbe1mkKgAk8HzmcPykHUqJf2mtt6Q@mail.gmail.com>
References: <k7duab$fn4$1@ger.gmane.org>
<370680F7-B322-4241-8C23-8EA528EFE159@teksol.info>
<k7dva3$v2f$1@ger.gmane.org>
<CAF-4BpNpeE9+0mYFqRPjaTbe1mkKgAk8HzmcPykHUqJf2mtt6Q@mail.gmail.com>
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...
Attachments:
signature.asc (application/pgp-signature, 259B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ivoras@freebsd.org
Subject: Re: Unique values across a table of arrays - documents and tags
In-Reply-To: <k7e0jp$b94$1@ger.gmane.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox