Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jLCaP-0002PO-Mi for pgsql-bugs@arkaria.postgresql.org; Sun, 05 Apr 2020 21:13:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jLCZq-0006WL-Ay for pgsql-bugs@arkaria.postgresql.org; Sun, 05 Apr 2020 21:13:10 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jLCW0-0006M2-9P for pgsql-bugs@lists.postgresql.org; Sun, 05 Apr 2020 21:09:12 +0000 Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jLCVt-00020n-AG for pgsql-bugs@lists.postgresql.org; Sun, 05 Apr 2020 21:09:11 +0000 Content-Type: multipart/mixed; boundary="===============5678313192914678861==" MIME-Version: 1.0 Subject: BUG #16344: json_agg slow performance vs jsonb_agg, truncate table for master table with remote partition To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: zhangh3@aetna.com Reply-To: zhangh3@aetna.com, pgsql-bugs@lists.postgresql.org Date: Sun, 05 Apr 2020 21:08:08 +0000 Message-ID: <16344-edc88bfde0736876@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============5678313192914678861== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjM0NApMb2dnZWQgYnk6ICAgICAgICAgIEhvbmd5YW4gKEhlYXRoZXIp IFpoYW5nCkVtYWlsIGFkZHJlc3M6ICAgICAgemhhbmdoM0BhZXRuYS5jb20KUG9zdGdyZVNRTCB2 ZXJzaW9uOiAxMi4yCk9wZXJhdGluZyBzeXN0ZW06ICAgUG9zdGdyZVNRTCAxMi4wIG9uIHg4Nl82 NC1wYy1saW51eC1nbnUsIGNvbXBpbGVkCkRlc2NyaXB0aW9uOiAgICAgICAgCgpqc29uX2FnZyB2 cyBqc29uYl9hZ2cgZm9yIGEgcGFydGl0aW9uZWQgdGFibGUsIEkgZm91bmQganNvbl9hZ2cKc2ln aW5pZmljYW50bHkgc2xvdyAoNiBzZWNzKSBhcyBqc29uYiAoMm1pbnMpDQpjcmVhdGUgdGFibGUg YWdndGFiIGFzIHNlbGVjdCBpZCwganNvbl9hZ2coY29sKSBmcm9tIHRhYiBncm91cCBieSBpZA0K DQp0cnVuY2F0ZSB0YWJsZSA8bWFzdGVyIHRhYmxlIG9mIDIgcGFydGl0aW9ucywgMSBsb2NhbCwg YW5vdGhlciByZW1vdGU+DQplcnJvcjogPHJlbW90ZSB0YWJsZT4gaXMgbm90IGEgdGFibGUKCg== --===============5678313192914678861==--