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 1fSayn-0005zd-O8 for pgadmin-hackers@arkaria.postgresql.org; Tue, 12 Jun 2018 04:32:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fSaym-0001rF-7v for pgadmin-hackers@arkaria.postgresql.org; Tue, 12 Jun 2018 04:32:24 +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 1fSaym-0001r5-2d for pgadmin-hackers@lists.postgresql.org; Tue, 12 Jun 2018 04:32:24 +0000 Received: from mx0b-00296801.pphosted.com ([148.163.153.148]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fSayh-0007ru-2D for pgadmin-hackers@postgresql.org; Tue, 12 Jun 2018 04:32:22 +0000 Received: from pps.filterd (m0114585.ppops.net [127.0.0.1]) by mx0b-00296801.pphosted.com (8.16.0.22/8.16.0.22) with SMTP id w5C4UY3L017265 for ; Tue, 12 Jun 2018 04:32:15 GMT Received: from mail-ua0-f200.google.com (mail-ua0-f200.google.com [209.85.217.200]) by mx0b-00296801.pphosted.com with ESMTP id 2jg7262qfu-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128 verify=NOT) for ; Tue, 12 Jun 2018 04:32:15 +0000 Received: by mail-ua0-f200.google.com with SMTP id k23-v6so7718145uao.17 for ; Mon, 11 Jun 2018 21:32:15 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=2AtIWgAno/sHU1ZO51bS9+TjHpGMEV+oLADwD0vRePA=; b=ChHNyA6e5nia3Cwygt3Qk8J7/MLVIBhIn6m6XqhDelKt924W/drlCpqlFMwaYIIkBW jidYEOUov8ZGc5aAk4NUGmnHYsntRNiRoTOg+m19/lUPSvM81EAD0AWWfiOdlfHyQb2p rHY2glJZftKcQYBu7qCLfuiE4tmIlgmFe/E5cL8C7Wxfs/cqZy2n3ixNj9frPoW3vz8j f9oUaSEEs1Rx+TcHDTY5NvP5V4/L4JvpuQOxJF+1pdz0Br9WRUNxL3ru1/sW+Z558UMV L01mHxB33U84KsKsaMt3sORsA+torBkvv6VxRads1CR1yRIPfU6zkQYh1mxOj9iCLAFy eqAA== X-Gm-Message-State: APt69E1AFJoiEI0t+wuGPcjwSdjCleekfDGkaPR8WDWSamKGbhVir7go JmUMHuTk/OWnjJObSPgi1j2xeUMU3IcqXIUNEx7lQauvwWcgnKfSt7hEWAZx55JHkI5cM5iPjbd epqjSsafmSutFWXp7uL8cWDC6xOmRlMDk4X5/Bqncxyrf9nToBRevmeK16vCygDgumR8j X-Received: by 2002:a1f:62c4:: with SMTP id w187-v6mr1191779vkb.112.1528777934509; Mon, 11 Jun 2018 21:32:14 -0700 (PDT) X-Google-Smtp-Source: ADUXVKIs0+8dp5w6buvON46QR0SF8rjczjI18WMXOOg5NqdDgBfwy4gpviooW8ZX0dwRP1vsPINBnsCvdkADJkfxyLw= X-Received: by 2002:a1f:62c4:: with SMTP id w187-v6mr1191775vkb.112.1528777934154; Mon, 11 Jun 2018 21:32:14 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Robert Eckhardt Date: Tue, 12 Jun 2018 00:32:01 -0400 Message-ID: Subject: Re: [pgadmin4][patch][GreenPlum] Display SQL for tables takes 15 minutes to execute To: Ashesh Vashi Cc: Joao Pedro De Almeida Pereira , pgadmin-hackers Content-Type: multipart/alternative; boundary="000000000000b4e90f056e6a59cd" X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10434:,, definitions=2018-06-12_01:,, signatures=0 X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 priorityscore=1501 malwarescore=0 suspectscore=1 phishscore=0 bulkscore=0 spamscore=0 clxscore=1015 lowpriorityscore=0 mlxscore=0 impostorscore=0 mlxlogscore=999 adultscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.0.1-1805220000 definitions=main-1806120051 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --000000000000b4e90f056e6a59cd Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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. There was a performance optimization in Postgres 9.2 that make the current query in Postgres performant. Rob > -- Thanks, Ashesh > > =E2=80=8B >> Thanks >> Joao >> > > --000000000000b4e90f056e6a59cd Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


= 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 Alm= eida Pereira <jdealmeidapereira@pivotal.io> wrote:
If I understand correctly, you= 're disabling the privileges for GPDB.
Is that correct?
=

It should be only for Greenplum. There was a performance opti= mization in Postgres 9.2 that make the current query in Postgres performant= .=C2=A0=C2=A0

Rob=C2=A0<= /div>


-- Thanks, Ashesh

=E2=80=8B
Thanks
Joao
<= /font>

--000000000000b4e90f056e6a59cd--