Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bQIlB-0006oA-1h for pgsql-performance@arkaria.postgresql.org; Thu, 21 Jul 2016 18:31:49 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bQIlA-0007wG-L0 for pgsql-performance@arkaria.postgresql.org; Thu, 21 Jul 2016 18:31:48 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bQIjH-0003qh-8S for pgsql-performance@postgresql.org; Thu, 21 Jul 2016 18:29:51 +0000 Received: from mail-oi0-x233.google.com ([2607:f8b0:4003:c06::233]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1bQIjE-0000om-Cp for pgsql-performance@postgresql.org; Thu, 21 Jul 2016 18:29:50 +0000 Received: by mail-oi0-x233.google.com with SMTP id w18so130139795oiw.3 for ; Thu, 21 Jul 2016 11:29:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=gC4IY+fWygbWNOgUMc02pI8vNkSiafL5dIMifncDND8=; b=NZBdaZPr7qrDb8N/EQJ893JT77FfPIHzhlqEmd0Ckj0OvPUh01bxpk0vDSUMv6hVeF tK+gZVST1SYpACJ9HWHoaYaZD7+Cvtnzv6ut4x6vfzawFIFuFaOJMGT4ePX/SEIrK9YS TqnczEb1zj2nGhLadLX/++VZO8aob4JX0D/yStXnWKO5+0GNZQCg/yh4vx83o//h4VNc 1UDgPnPejKK22C/qTCyUuVo4/SGlKGs5WLL+dqGRUTs7y3h2K0abGmqCJaWKqOFBfnYt l8VLpRuJjZi0zF6vYk/VQkIqG59K5IpLRjWLIhXDhbVf7dbsfOUoPjkgcz7CPOOLNUN0 wefQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=gC4IY+fWygbWNOgUMc02pI8vNkSiafL5dIMifncDND8=; b=OYdw1r1X4MW/4S/EssLPAxigG9pi1+eKnJtbhCQE6moCyjE5COEoMpUtO8eD+ouR55 KeZdidbi9qerXlARG9/a7S6cyr0EGxZ3Xtrjcg8NNXXTR0iYguvp6MCUubvIru3Zkc4Q 9eWen4e4m4zu6jFSP263EhUbMBLtsmOQKQkd6K19W/es5VVdhLlxSuWOt/cdcavIQujq cLLtfK1dV3nn7nMntCjr06uYxugqKUq6cPMlgomhJ+zX/ufCdL/zzSkCZoptdF2GSl1s vak9dpy/8tlyZ+jD7Eb8F/PnE0zxyGu8QUE9BgAvGALZXVaC9Wi7VXdnrlANrcr/sewp YbsA== X-Gm-Message-State: ALyK8tKKB8i4ZuhDc3ctOJhxG8KFq38o7Pxj0GLYW1PKcfXmLqQWdPvFTxFAiRQLWTop8IQo9HwgQwDEtGf+WA== X-Received: by 10.157.21.38 with SMTP id u35mr25703921otf.54.1469125786612; Thu, 21 Jul 2016 11:29:46 -0700 (PDT) MIME-Version: 1.0 Received: by 10.157.0.7 with HTTP; Thu, 21 Jul 2016 11:29:46 -0700 (PDT) In-Reply-To: References: <1464351030.15267.14.camel@kth.se> <32524.1464356784@sss.pgh.pa.us> <1464593729.16712.2.camel@kth.se> <1464616618.19212.3.camel@kth.se> <1469112481.11501.12.camel@kth.se> From: "David G. Johnston" Date: Thu, 21 Jul 2016 14:29:46 -0400 Message-ID: Subject: Re: Performance problems with 9.2.15 To: Claudio Freire Cc: Johan Fredriksson , postgres performance list Content-Type: multipart/alternative; boundary=94eb2c1902eaa439e405382980ed X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org --94eb2c1902eaa439e405382980ed Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable On Thu, Jul 21, 2016 at 2:24 PM, Claudio Freire wrote: > That cross join doesn't look right. It has no join condition. =E2=80=8BThat is that the definition of a "CROSS JOIN"... David J. --94eb2c1902eaa439e405382980ed Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
On Thu, Ju= l 21, 2016 at 2:24 PM, Claudio Freire <klaussfreire@gmail.com> wrote:
<= div class=3D"gmail_quote">
That cross join do= esn't look right. It has no join condition.

=
=E2=80=8BThat is that the definition of a "CROS= S JOIN"...

David J.

=
--94eb2c1902eaa439e405382980ed--