X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 13D4CD8094
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Sun, 11 Sep 2005 18:00:28 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 31766-10
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Sun, 11 Sep 2005 21:00:21 +0000 (GMT)
Received: from ns.snowman.net (ns.snowman.net [66.92.160.21])
	by svr1.postgresql.org (Postfix) with ESMTP id 59065D8220
	for <pgsql-performance@postgresql.org>;
	Sun, 11 Sep 2005 18:00:09 -0300 (ADT)
Received: by ns.snowman.net (Postfix, from userid 1000)
	id 6B91717AD3; Sun, 11 Sep 2005 17:00:36 -0400 (EDT)
Date: Sun, 11 Sep 2005 17:00:36 -0400
From: Stephen Frost <sfrost@snowman.net>
To: Ksenia Marasanova <ksenia.marasanova@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: LEFT JOIN optimization
Message-ID: <20050911210035.GC6026@ns.snowman.net>
Mail-Followup-To: Ksenia Marasanova <ksenia.marasanova@gmail.com>,
	pgsql-performance@postgresql.org
References: <130df19305091110125a2d174f@mail.gmail.com>
Mime-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="RTNKHHDM+1AXWjxM"
Content-Disposition: inline
In-Reply-To: <130df19305091110125a2d174f@mail.gmail.com>
X-Editor: Vim http://www.vim.org/
X-Info: http://www.snowman.net
X-Operating-System: Linux/2.4.24ns.3.0 (i686)
X-Uptime: 16:59:06 up 92 days, 13:15, 9 users, load average: 0.05, 0.07, 0.08
User-Agent: Mutt/1.5.9i
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.004 required=5 tests=[AWL=0.004]
X-Spam-Level: 
X-Archive-Number: 200509/131
X-Sequence-Number: 14439


--RTNKHHDM+1AXWjxM
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

* Ksenia Marasanova (ksenia.marasanova@gmail.com) wrote:
> Any tips are greatly appreciated.

EXPLAIN ANALYZE of the same queries would be much more useful.

	Thanks,

		Stephen

--RTNKHHDM+1AXWjxM
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFDJJrzrzgMPqB3kigRAgurAKCF+rAqT0tVdckcoTYp2CM/PDbDsgCfXdzS
uUVp88enOJ66xRcnBZqor2Q=
=alwG
-----END PGP SIGNATURE-----

--RTNKHHDM+1AXWjxM--