To: pgsql-performance@postgresql.org
From: Ivan Voras <ivoras@freebsd.org>
Subject: Re: Unique values across a table of arrays - documents and tags
Date: Wed, 07 Nov 2012 17:00:59 +0100
Lines: 32
Message-ID: <k7e0jp$b94$1@ger.gmane.org>
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>
Mime-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="------------enigA42A7E10829082AE397047C3"
User-Agent: Mozilla/5.0 (X11; FreeBSD amd64;
	rv:14.0) Gecko/20120812 Thunderbird/14.0
In-Reply-To: 
 <CAF-4BpNpeE9+0mYFqRPjaTbe1mkKgAk8HzmcPykHUqJf2mtt6Q@mail.gmail.com>

This is an OpenPGP/MIME signed message (RFC 2440 and 3156)
--------------enigA42A7E10829082AE397047C3
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

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 wo=
rds.

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...


--------------enigA42A7E10829082AE397047C3
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.19 (FreeBSD)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAlCahbsACgkQ/QjVBj3/HSx2BwCfZM3kb70svpRo3mZd5fnVO9Bf
fPAAoIvwV7CYSQv5Y4nUSPt5v6RP68cp
=IFPZ
-----END PGP SIGNATURE-----

--------------enigA42A7E10829082AE397047C3--