On Thu, Jul 21, 2016 at 3:29 PM, David G. Johnston <[email protected]> wrote: > On Thu, Jul 21, 2016 at 2:24 PM, Claudio Freire <[email protected]> > wrote: >> >> That cross join doesn't look right. It has no join condition. > > > That is that the definition of a "CROSS JOIN"... > > David J.
Well, maybe it shouldn't be. A cross join I mean. I see the query and a cross join there doesn't make much sense. There's no filtering of the output rows on the where clause either AFAICT, and it's producing a lot of intermediate rows that don't seem to be necessary. That was my point. -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
