Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bQLH3-000806-A1 for pgsql-performance@arkaria.postgresql.org; Thu, 21 Jul 2016 21:12:53 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bQLH2-0005j2-9H for pgsql-performance@arkaria.postgresql.org; Thu, 21 Jul 2016 21:12:52 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bQLH1-0005gM-3Z for pgsql-performance@postgresql.org; Thu, 21 Jul 2016 21:12:51 +0000 Received: from mail-oi0-x22e.google.com ([2607:f8b0:4003:c06::22e]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1bQLGy-0002SP-A2 for pgsql-performance@postgresql.org; Thu, 21 Jul 2016 21:12:49 +0000 Received: by mail-oi0-x22e.google.com with SMTP id l65so136084033oib.1 for ; Thu, 21 Jul 2016 14:12: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=38hGFZ8GYrWW6zRNwjbJ7bKEGx4FworufaogFTg+5MI=; b=Ybj4DLPRIv2XeKqA4F1lA7m0CUFoafYoXjX1O9bKqHkU4G8Cm9GLRWuNBMp8RXt536 zrCjigeWzm/i07txjzGAETMBJaoI1ef14Ht3Twffg5wi3ziLUb6Ajh397uNqpSvUIPUx qeh7kxqmpTS0GC8ztONL/CbH97jAd5rh5HwPPBjoV7VKu1/j+5MWbsdSHtB/KdJfvmL4 JOqV+1+eEWtFlxmbmvgsGbXtrED1iPbIztfUyVRM4mNMOclMhkmTBYLuteFdYFkCzAOm uyg67ZDa+5aBsnEyx2FTHTUFnYhBmW8AFJBTyc6KeMx2PK3C7BYOxKkBLNHhrFu7NJTV W5CQ== 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=38hGFZ8GYrWW6zRNwjbJ7bKEGx4FworufaogFTg+5MI=; b=Vyng2njBW1PJMNVDNa/9wUTZAYi19Rx33RDjTy5XP/ythKONB/Ad6PYCFP6GiUQgDI la4eA//phoqgTrm2FNqmOgjVAjFlMncs1NN2GY0GOfh/cGW4vsMuEDo6td602y3cVv1/ jYAAVcC/8MEzeht6wa0sBgeKUnSPvYpQ+C8w6yOKTG4rNpb/Ps5KdeKh+it123pbfR6n RpGO7rdeW3CO4RUYt6NlVLpzncE/QwpNuMxtsCyhS42sxG5jts319rqzPdAIw/2VyrUE oK5PuUE8BLEX82pD3PReCn1tX8r9JQ094c0jArNs6jihCAv2/Oz54DoUv9VE2Fli/xix YGzA== X-Gm-Message-State: AEkoouvbMWbKav81O2dKXGJhtVvBz5FFfj1G7xVQr3MgbjcU9kJz0l3ywydt30+UpJHxrdLK61PVXwiVGLRNQA== X-Received: by 10.202.114.81 with SMTP id p78mr232605oic.16.1469135567554; Thu, 21 Jul 2016 14:12:47 -0700 (PDT) MIME-Version: 1.0 Received: by 10.202.77.149 with HTTP; Thu, 21 Jul 2016 14:12:47 -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: Claudio Freire Date: Thu, 21 Jul 2016 18:12:47 -0300 Message-ID: Subject: Re: Performance problems with 9.2.15 To: "David G. Johnston" Cc: Johan Fredriksson , postgres performance list Content-Type: text/plain; charset=UTF-8 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 On Thu, Jul 21, 2016 at 3:29 PM, David G. Johnston wrote: > On Thu, Jul 21, 2016 at 2:24 PM, Claudio Freire > 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance