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 1fSb1l-0006Fr-JM for pgadmin-hackers@arkaria.postgresql.org; Tue, 12 Jun 2018 04:35:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fSb1k-0002NL-AA for pgadmin-hackers@arkaria.postgresql.org; Tue, 12 Jun 2018 04:35:28 +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.89) (envelope-from ) id 1fSb1k-0002N3-0r for pgadmin-hackers@lists.postgresql.org; Tue, 12 Jun 2018 04:35:28 +0000 Received: from mail-ot0-x229.google.com ([2607:f8b0:4003:c0f::229]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1fSb1b-0007vV-KM for pgadmin-hackers@postgresql.org; Tue, 12 Jun 2018 04:35:27 +0000 Received: by mail-ot0-x229.google.com with SMTP id i19-v6so26526170otk.10 for ; Mon, 11 Jun 2018 21:35:18 -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=CbNhsXXs/CH6IqKCsyAYfaIjaJSXDcQR8UnbaGvUEB4=; b=HM6eHQUhzg/AStlg1wZ5cqYMB2+/5KOyBpdqx0YcIljV/k9DGrAKyjMuThT+4/aHFi fUnbasIn+oUSUNDHTgBGCJ2MDQIsdxT29V94TgpqD9whmRO/RlSMJkGOwvrttRbhinza z0ok63rJ3MT0X5fv7rKUi8OPCTJ4xnziKlFssOtwyfcMccljPRM2NxzDoyIBEgRJwRIr WPe5Y4iRzcRXwAvT5tB+fD5FMimIjog6iFOsSt1aRbjt6510R29sqiq2jaeXxFRfq8nC 4cTdvd8sHfmf7kbZLsWjul4y1dFydpLrkfL5zlJute3zEOFFNrNtVTNk24/6gnyAQuo7 dL4Q== 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=CbNhsXXs/CH6IqKCsyAYfaIjaJSXDcQR8UnbaGvUEB4=; b=H1JLUGp6oE+xNFw20z55+0UA0bjdK1KCR5cxf+nKmb8qGwVDWy9qCTNoV176fkQXkk KZEC7ievUxUjka/A5Job/DbKM853U/v7141PgTs6Epoh1WTzJn9rhOQRCJglrMyGHrvi 3qbNyYA9KGqEU1KR6hlBP8MzPaJsWeFOupOUNLals/vZT86iNTXxEu1Y4RCivXT9bpBS AMGfhDI9ZRjw/dJ8QM8PJtqfwVVCs0lESyX7A7T20SCW5Ai9hpvui5Z1lLYubYf6td+V f92MrIaH2opWh0UMOlr4wk9Uu8FHmFc4IZr+qzOtxBE0LAReUSKb6QFko7wAtuhLv2bh xbyA== X-Gm-Message-State: APt69E1/9iAf0J3ThFpgZneR/FmPemf3Y5GU3HEnyFg4gf2ExAiJoPh+ ietshXvvhhCYHNMRsHOronhLskqUGkCrG2Vy59pYnA== X-Google-Smtp-Source: ADUXVKKx+JLyeeudeP8dCvHaGrqNB64EPxFJvAouP1OI9W/71RFrN+5uPXuEXkGyw15H3Osnnug8HBUAGHvlASMENIM= X-Received: by 2002:a9d:14db:: with SMTP id r27-v6mr1330521otr.190.1528778117133; Mon, 11 Jun 2018 21:35:17 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:ac9:7a54:0:0:0:0:0 with HTTP; Mon, 11 Jun 2018 21:34:56 -0700 (PDT) In-Reply-To: References: From: Ashesh Vashi Date: Tue, 12 Jun 2018 10:04:56 +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="0000000000009ccbb5056e6a64ba" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --0000000000009ccbb5056e6a64ba Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tue, Jun 12, 2018 at 10:02 AM, Robert Eckhardt wrote: > > > On Tue, Jun 12, 2018, 12:27 AM Ashesh Vashi > 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 curren= t > query in Postgres performant. > Ok. Changes looks good to me. -- Thanks, Ashesh > > Rob > > >> -- Thanks, Ashesh >> >> =E2=80=8B >>> Thanks >>> Joao >>> >> >> --0000000000009ccbb5056e6a64ba Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
<= div style=3D"margin:0pt 0pt 8px">

On Tue, Jun 12, 20= 18 at 10:02 AM, Robert Eckhardt <reckhardt@pivotal.io> wr= ote:



On Tue, Jun 12, 2018, 12:27 AM As= hesh Vashi <ashesh.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 und= erstand correctly, you're disabling the privileges for GPDB.
= Is that correct?

It should be only for Greenplu= m.
Yeah - I got that.
=C2= =A0
There was a performance optimization in Postgres 9.2 that make the cu= rrent query in Postgres performant.=C2=A0
Ok.<= /div>

Changes looks good to me.
=C2=A0
-- Thanks, Ashesh=C2=A0

Rob=C2=A0<= /div>


-- Thank= s, Ashesh

=E2=80=8B
Thanks
Joao


--0000000000009ccbb5056e6a64ba--