Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1icVVg-0007g6-Iw for pgsql-bugs@arkaria.postgresql.org; Wed, 04 Dec 2019 14:20:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1icVVf-0005Mh-B5 for pgsql-bugs@arkaria.postgresql.org; Wed, 04 Dec 2019 14:20:07 +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_SHA1:256) (Exim 4.89) (envelope-from ) id 1icVVf-0005Jv-1B for pgsql-bugs@lists.postgresql.org; Wed, 04 Dec 2019 14:20:07 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1icVVc-00084e-O8 for pgsql-bugs@lists.postgresql.org; Wed, 04 Dec 2019 14:20:06 +0000 Content-Type: multipart/mixed; boundary="===============6069270139169118872==" MIME-Version: 1.0 Subject: BUG #16148: Query on Large table hangs in ETL flows and gives out of memory when run in pgAdmin4 To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: scottvolkers@gmail.com Reply-To: scottvolkers@gmail.com, pgsql-bugs@lists.postgresql.org Date: Wed, 04 Dec 2019 14:19:56 +0000 Message-ID: <16148-ed1cc02fdf2200ec@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============6069270139169118872== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjE0OApMb2dnZWQgYnk6ICAgICAgICAgIFNjb3R0IFZvbGtlcnMKRW1h aWwgYWRkcmVzczogICAgICBzY290dHZvbGtlcnNAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lv bjogOS41LjE1Ck9wZXJhdGluZyBzeXN0ZW06ICAgUG9zdGdyZVNRTCA5LjUuMTUgb24geDg2XzY0 LXBjLWxpbnV4LWdudSwgY29tcGlsZWQKRGVzY3JpcHRpb246ICAgICAgICAKCldlIGhhdmUgYSBs YXJnZSB0YWJsZSBhbmQgdGhlIGVycm9yIG9jY3VycyB3aXRoIHRoaXMgd2hlcmUgY2xhdXNlOg0K RlJPTSAiZWxsaWVkYiIuImRvY3VtZW50bG9nIiBXSEVSRSBkY21vZGlmaWVkdXRjPihleHRyYWN0 KGVwb2NoIGZyb20KVElNRVNUQU1QICcyMDE5LTExLTE1IDExOjMwOjUxJykqMTAwMCkNCg0KV2hl biB3ZSByZWR1Y2UgdGhlIHNjb3BlIHRvIGN1cnJlbnQgdGltZSAtIDQgaG91cnMgdGhlIHF1ZXJ5 IHdvcmtzIHdpdGhpbiA0NApzZWNvbmRzLg0Kd2hlcmUgZGNtb2RpZmllZHV0YyA+ICcxNTc1Mjgy NjUxMDAwJw0KDQpJcyB0aGlzIGV4cGVjdGVkPyAgIElzIHRoaXMgYSB2ZXJzaW9uIGlzc3VlIGJl aW5nIG9ubHkgOS41PyAgICBJdCBzZWVtcyB0aGUKdGltZXN0YW1wIGNvbnZlcnNpb24gd291bGQg YmUgZG9uZSBvbmNlIGFuZCBhcHBsaWVkIHRvIHRoZSBmaWx0ZXIsIGJ1dCBpdApzZWVtcyB0byBi YWxsb29uaW5nIHRoZSBxdWVyeSByZXN1bHQgYmVpbmcgYWdncmVnYXRlZCBmb3IgdGhlIHdoZXJl CmNsYXVzZT8NClRoYW5rIHlvdS4KCg== --===============6069270139169118872==--