Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fT153-0001Ot-QC for pgadmin-hackers@arkaria.postgresql.org; Wed, 13 Jun 2018 08:24:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fT151-0003D2-Lp for pgadmin-hackers@arkaria.postgresql.org; Wed, 13 Jun 2018 08:24:35 +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.89) (envelope-from ) id 1fT151-0003Cd-7u for pgadmin-hackers@lists.postgresql.org; Wed, 13 Jun 2018 08:24:35 +0000 Received: from mail-wm0-x233.google.com ([2a00:1450:400c:c09::233]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1fT14w-0002wu-Tf for pgadmin-hackers@postgresql.org; Wed, 13 Jun 2018 08:24:33 +0000 Received: by mail-wm0-x233.google.com with SMTP id r15-v6so3168764wmc.1 for ; Wed, 13 Jun 2018 01:24:30 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pgadmin-org.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=bvU0FROwaGy7dJkAaghIxad6S/z3WqTDUZa6jhx93ZY=; b=mpu/0NLrzItUUozKRbdNCr2h9njawMet79VVvzT+cu7r+8kyWTvkW82zxcrivKzn0n Z4y5BimAFgr9DBtvKJbARaSeLFyekVKuwe39GESmzYR8ICbZsbvzv2sePN2Qvbd0/EFw ixdZM9trIHbg6d+5gq4WXrjaWFB2gualgZfjrWOP4G+aj03E0CFaC/rmoqM09cj63Yrv s+yZ+5e+w7wj+295xBOX713jv8DbGoRa31+PemqEiozL596uyDI1KoddS9s5A8VKYonq xRrCUhV9LgwORoNgoNra2ddS7tD2nkKLllw0tRbujQTi3wRl+/hvVAsVJNHOEN2F8TcO bwHg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=bvU0FROwaGy7dJkAaghIxad6S/z3WqTDUZa6jhx93ZY=; b=iTUdyUjXY8WUVZmNGIQu+rcGt5ELtkSf7TryK5u/c8lpKLaCEGx3mLzLhNFq+ZJ2QQ qy+6u5nx/qO7IIdyc/6r2fWfxHveE09ob++rJMMH1duP5ndsy/yuAXJOEtyqjXhH4zRt 2bw5VIYQOQnhlLLFX2H4Y4OxPxbj+VubMmgHGfuHp9448NN/orZqs4q4qW0aCqtQYxcD N0YW84ZkEYB24Gcbi2nwOMNqlcVUrPNkgmTd9+wbhzcmhnWtOY7fjfuNyBSkkz9WMn/d I6DQlQnJpBmxWIu4C0FxecOISuWNkcQq+5aAs1vG6NZapf21iIiiPK3EvEu2znsz5xMO p8Hw== X-Gm-Message-State: APt69E3TTSHFTGzoTQT+i095MQ9uI2pnvXHhB5L02XavESULm2SwwKS1 q6DVYx6IeMKNAO7mtdXrk5A1WCD4jCPVoQaUhtIyvw== X-Google-Smtp-Source: ADUXVKIQHseISUSAnZynCswESfY2tL9Jv0xgRcJol16OC+LpFG+l7lTFRztWv4e28cI3V34/J2xy3tkPQjhDd1e/Kqw= X-Received: by 2002:a1c:ec84:: with SMTP id h4-v6mr2899295wmi.154.1528878267990; Wed, 13 Jun 2018 01:24:27 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a1c:2907:0:0:0:0:0 with HTTP; Wed, 13 Jun 2018 01:24:27 -0700 (PDT) In-Reply-To: References: From: Dave Page Date: Wed, 13 Jun 2018 09:24:27 +0100 Message-ID: Subject: Re: [pgadmin4][patch][GreenPlum] Display SQL for tables takes 15 minutes to execute To: Ashesh Vashi Cc: Robert Eckhardt , Joao Pedro De Almeida Pereira , pgadmin-hackers Content-Type: multipart/alternative; boundary="000000000000118d88056e81b60b" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --000000000000118d88056e81b60b Content-Type: text/plain; charset="UTF-8" On Tue, Jun 12, 2018 at 6:34 AM, Ashesh Vashi wrote: > On Tue, Jun 12, 2018 at 10:04 AM, Ashesh Vashi < > ashesh.vashi@enterprisedb.com> wrote: > >> On Tue, Jun 12, 2018 at 10:02 AM, Robert Eckhardt >> wrote: >> >>> >>> >>> On Tue, Jun 12, 2018, 12:27 AM Ashesh Vashi < >>> ashesh.vashi@enterprisedb.com> wrote: >>> >>>> Hi Joao, >>>> >>>> On Tue, Jun 12, 2018 at 1:50 AM, Joao De Almeida Pereira < >>>> jdealmeidapereira@pivotal.io> wrote: >>>> >>>>> Hi Hackers, >>>>> >>>>> Attached you can find the diff file that corrects RM 3415 >>>>> >>>>> >>>> If I understand correctly, you're disabling the privileges for GPDB. >>>> Is that correct? >>>> >>> >>> It should be only for Greenplum. >>> >> Yeah - I got that. >> >> >>> There was a performance optimization in Postgres 9.2 that make the >>> current query in Postgres performant. >>> >> Ok. >> >> Changes looks good to me. >> > Committed! > Should this have included an updated to the release notes? -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company --000000000000118d88056e81b60b Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


On Tue, Jun 12, 2018 at 6:34 AM, Ashesh Vashi <ashesh.vash= i@enterprisedb.com> wrote:
=
On = Tue, Jun 12, 2018 at 10:04 AM, Ashesh Vashi <ashesh.vashi@en= terprisedb.com> wrote:
=

On Tue, Jun 12, 2018 at 10:02 AM, Rob= ert Eckhardt <reckhardt@pivotal.io> wrote:

<= /div>


On Tue, Jun 12, 2018, 12:27 AM Ashesh Vashi <ashesh.vas= hi@enterprisedb.com> wrote:
<= div dir=3D"ltr">
Hi Joao,

On Tue, Jun 12, 2018 at 1:50 AM, Joao De Alm= eida Pereira <jdealmeidapereira@pivotal.io> wrote:
If I understand correctly, you're di= sabling the privileges for GPDB.
Is that correct?

It should be only for Greenplum.
=
Yeah - I got that.
=C2=A0
There was a perfo= rmance optimization in Postgres 9.2 that make the current query in Postgres= performant.=C2=A0
Ok.

Changes looks good to me.
Committed!

= Should this have included an updated to the release notes?
=C2=A0=
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

Ent= erpriseDB UK: htt= p://www.enterprisedb.com
The Enterprise PostgreSQL Company
--000000000000118d88056e81b60b--