Skip site navigation (1) Skip section navigation (2)

Re: nested select query failing

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: SZUCS Gábor <surrano(at)mailbox(dot)hu>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: nested select query failing
Date: 2003-05-15 14:56:49
Message-ID: 20030515075032.B60859-100000@megazone23.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Thu, 15 May 2003, [iso-8859-1] SZUCS Gbor wrote:

> Basically, is it true that IN's can be converted to RIGHT JOIN's quite
> simply? Is it always worth?

I'm not sure you want to convert to an outer join (since you want to throw
away the rows on either side that don't match in an IN).  You also have to
be careful not to get duplicate entries from what was the subquery.

As for whether it's worth doing, in 7.3 and earlier, almost
certainly, in 7.4 almost certainly not. :)




In response to

Responses

pgsql-performance by date

Next:From: Stephan SzaboDate: 2003-05-15 15:08:52
Subject: Re: [ADMIN] nested query too expensive
Previous:From: Sub Director - Sistemas InformáticosDate: 2003-05-15 13:20:01
Subject: nested query too expensive

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group