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 16:38:43 +0100
Lines: 41
Message-ID: <k7dva3$v2f$1@ger.gmane.org>
References: <k7duab$fn4$1@ger.gmane.org>
	<370680F7-B322-4241-8C23-8EA528EFE159@teksol.info>
Mime-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="------------enig8CCE6B2350A5B4A2BD873372"
User-Agent: Mozilla/5.0 (X11; FreeBSD amd64;
	rv:14.0) Gecko/20120812 Thunderbird/14.0
In-Reply-To: <370680F7-B322-4241-8C23-8EA528EFE159@teksol.info>

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

On 07/11/2012 16:34, Fran=C3=A7ois Beausoleil wrote:
> Le 2012-11-07 =C3=A0 10:21, Ivan Voras a =C3=A9crit :

>> Barring that, what would you suggest for efficiently handing a classic=

>> structure like this (meaning documents with tags)?
>=20
> Can you structure it as the "classic" many to many pattern:
>=20
> documents <-> taggings <-> tags

Yes, that is as you said, a classic solution to a classic problem :)

If needed, this is the way I will do it, but for now I'm asking if
there's something that can be done to avoid creating another table or
two. The reason I'm asking is that I've often found that PostgreSQL can
do much more than I thought it can.


--------------enig8CCE6B2350A5B4A2BD873372
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/

iEYEARECAAYFAlCagIQACgkQ/QjVBj3/HSzougCfTu8pqT6rsJOLaxKxUsohmmzB
tIIAn0nUp5/E+I/o1cuzqtpyRhGRCH9y
=TTI9
-----END PGP SIGNATURE-----

--------------enig8CCE6B2350A5B4A2BD873372--