Path: csiph.com!usenet.pasdenom.info!weretis.net!feeder1.news.weretis.net!news.solani.org!.POSTED!not-for-mail From: Mladen Gogala Newsgroups: comp.databases.postgresql Subject: Re: Joining two tables using *two* columns (instead of one) Date: Sun, 8 Apr 2012 19:01:50 +0000 (UTC) Organization: solani.org Lines: 14 Message-ID: References: <4f7d9c45$0$1745$426a34cc@news.free.fr> <4f7dc1f1$0$21932$426a74cc@news.free.fr> <9u6gdcF6d7U1@mid.individual.net> <9u857kF70mU1@mid.individual.net> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Trace: solani.org 1333911710 13017 eJwNyMkBwCAMA7CVcpowToB4/xFaPZUOxV2BRCST0xuc1/8uWp+5rTVPZKxSXQpK14y3ibATHzHQES0= (8 Apr 2012 19:01:50 GMT) X-Complaints-To: abuse@news.solani.org NNTP-Posting-Date: Sun, 8 Apr 2012 19:01:50 +0000 (UTC) User-Agent: Pan/0.135 (Tomorrow I'll Wake Up and Scald Myself with Tea; GIT 30dc37b master) X-User-ID: eJwFwYEBwCAIA7CXBFqEc5wr/59gwkjLu5FMcDiCZmhmuh1yXzrI6ghiw8sx69tVof90h/UDFHcQVA== Cancel-Lock: sha1:79q9q/EqkcWVsm3Xyola6xIHcB4= X-NNTP-Posting-Host: eJwFwYEBwCAIA7CXBqVFzpnO/n/CEkKh0yWqaHo8mIHy3rsz66ViIeTZvR72BxRpNcDI4x8EzA/9 Xref: csiph.com comp.databases.postgresql:349 On Fri, 06 Apr 2012 14:17:48 +0200, Robert Klemme wrote: > I hinted at the badly chosen subject above. OP apparently really wants > two joins. And now it seems the problem has shifted towards long > execution time. Well, controlling the execution plan is not one of the strong points of PostgreSQL. This is as far as I am willing to go in this discussion. -- http://mgogala.byethost5.com