On Tue, Mar 25, 2014 at 4:12 PM, David Johnston <polobo@xxxxxxxxx> wrote: > 2 - and the one I'd use by default) Use an INNER JOIN That's where I started, but Postgres is smart enough to know that this is equivalent to what I'm doing, and still picks the nested loop. I went to IN in the hopes of tricking it. I haven't tried EXISTS. I'll have to try that tomorrow. --Brian -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
