On Thu, Jul 21, 2016 at 3:29 PM, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote: > On Thu, Jul 21, 2016 at 2:24 PM, Claudio Freire <klaussfreire@xxxxxxxxx> > 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 (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
