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 1fSbxd-00026G-TB for pgadmin-hackers@arkaria.postgresql.org; Tue, 12 Jun 2018 05:35:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fSbxc-0006To-MY for pgadmin-hackers@arkaria.postgresql.org; Tue, 12 Jun 2018 05:35:16 +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 1fSbxc-0006TT-Cp for pgadmin-hackers@lists.postgresql.org; Tue, 12 Jun 2018 05:35:16 +0000 Received: from mail-oi0-x233.google.com ([2607:f8b0:4003:c06::233]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1fSbxZ-0006jX-0L for pgadmin-hackers@postgresql.org; Tue, 12 Jun 2018 05:35:15 +0000 Received: by mail-oi0-x233.google.com with SMTP id h79-v6so19976307oig.13 for ; Mon, 11 Jun 2018 22:35:12 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=p7MVnj6/z6vsdFYAFWntSoEfiWYRIB99nhinF6/TOnw=; b=kM7vQF5me4bN9iYK0IaOXsPOoetuynUPcE0/wX2aiijpsLQ/pe0K93QyabuMPjGkOs SAPLffNpPBGxIKn2f+bqoLV+cvyfQsTknZYQ2aBNuHVf1JRFVzLMyz5HRToIPiD6m5JL 7Sjv7kcT+YmY83/tZu7WStp4MSsTvd37CwVefIA3RpmbZIn26j/K+o79l9haiHPm6Q5l Kmfg2gIY95PVyhcr+DljUQLMiihD8MTARuoh40IDphK4I1mAUkwCW3DlqwEc0AKeFH9l vfYyDqtUMZg6NIr7eE0dXkulxuK/3Of03IpTNhlDnKOfx1CmeuBe/qr7NSGt8VzYgjsL 5iSw== 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=p7MVnj6/z6vsdFYAFWntSoEfiWYRIB99nhinF6/TOnw=; b=UwQ/aFGPh+vFjH0c2/KSM1K1uohgJDIT1lF5v1STvqKaX05CFAvM4ee8Pc1LiUNstY 8bnXBTZ3UipE5NYSTogFnDYemQBnCTmLE0RN1zL1sw0NHNk11jYWXx8drSzJNJfsUK9O +SvcjDPpe2FCBF8MQWObHEvt8IfD8ev3zceaR30BhtqYymRd0hfDoZ/4YiQdM291Nt0u 0w4k2D95wCDQbJtJzkMDQ+2/Iu8/LNg50+qP1UKom2u5uSnPSVSEE8jUseq54PnCT+Ys 3FNbeF+koRkob1/uFXvSQHC6FQZ5HcQKk63NvOORxXtnD+hKD12zzl3iqMJNy9bI4Pyn +CAg== X-Gm-Message-State: APt69E07WNo/DCupPIQFHLtXX4ZeeY5CrxQtMJtm5meinpRvFI4i3K1i Cdjlu9UcPLckaTo4BN1XAPB+CzbIM4U5ysC0o/RUEw== X-Google-Smtp-Source: ADUXVKK2bSC/IxU9BAZ3NekuJt2JzoltXpT06GklI6e0Gf48TSgkkdT96u7GE5tBtMqWzWBNY52aXCK+upuQuWJteZw= X-Received: by 2002:aca:e34b:: with SMTP id a72-v6mr1206386oih.117.1528781711926; Mon, 11 Jun 2018 22:35:11 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:ac9:7a54:0:0:0:0:0 with HTTP; Mon, 11 Jun 2018 22:34:51 -0700 (PDT) In-Reply-To: References: From: Ashesh Vashi Date: Tue, 12 Jun 2018 11:04:51 +0530 Message-ID: Subject: Re: [pgadmin4][patch][GreenPlum] Display SQL for tables takes 15 minutes to execute To: Robert Eckhardt Cc: Joao Pedro De Almeida Pereira , pgadmin-hackers Content-Type: multipart/alternative; boundary="000000000000e0fde5056e6b3a17" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --000000000000e0fde5056e6b3a17 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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! -- Thanks, Ashesh > > -- Thanks, Ashesh > >> >> Rob >> >> >>> -- Thanks, Ashesh >>> >>> =E2=80=8B >>>> Thanks >>>> Joao >>>> >>> >>> > --000000000000e0fde5056e6b3a17 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
<= div style=3D"margin:0pt 0pt 8px">On Tue, Jun 12, 2018 at 10:04 AM, Ashesh V= ashi <ashesh.vashi@enterprisedb.com> wrote:
<= /div>
=

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



On Tue, Jun 12, 2018, 12:27 AM Ashesh Vas= hi <a= shesh.vashi@enterprisedb.com> wrote:
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 disabling the privileges= for GPDB.
Is that correct?
<= /div>

It should b= e only for Greenplum.
Yeah - I got th= at.
=C2=A0
There was a performance opti= mization in Postgres 9.2 that make the current query in Postgres performant= .=C2=A0
Ok.

Ch= anges looks good to me.
Committed!=

-- Thanks, Ashesh=C2=A0
=C2=A0
-- Thanks, Ashesh=C2=A0

Rob=C2=A0

-- Thanks, Ashesh

=E2=80=8B
Thanks
Joao



--000000000000e0fde5056e6b3a17--