Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qtz4D-00FOxl-MP for pgsql-bugs@arkaria.postgresql.org; Fri, 20 Oct 2023 23:38:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qtz4B-009WtZ-L1 for pgsql-bugs@arkaria.postgresql.org; Fri, 20 Oct 2023 23:38:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qtxh4-008TGm-IZ for pgsql-bugs@lists.postgresql.org; Fri, 20 Oct 2023 22:10:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qtxh0-001nSO-Ai for pgsql-bugs@lists.postgresql.org; Fri, 20 Oct 2023 22:10:10 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=1pSrQQJqxr4IehFt+JjoRjmKz14d5tp4Xo5TL7gzfcQ=; b=tQ4sixb1iNSA2mzACu2BZ6SSwD wIrkr4ey1/UuXs8Q9pQvXufhvpQezIaWZAsCvkGVlJFJYM2TZUMd/uBtpipyyHWqgzaPFxwc6KKxc uFuzy9T6xa/sE1wFtS4Enoeyd5X78vthOiyXQ9WQUeiH/wIpOyqcKXZLegOfrM4QAQEOhrR/zOPqg jzl6YT7CeP2wvVI9MAa7vcS5uLSBWomDuDUkiGUagoWGFLtY8sZdmZZfasterqtZ32UOY6l5Y3SMj xDCW67qKHIuxvrS9OeZCkg6dBVN1o1Osw4uwt9i0NhDPNeoeMHi0Yosz/VgSP4QPvC1jO1UBhHEjE O9nwOErg==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qtxgy-0005qn-Ih for pgsql-bugs@lists.postgresql.org; Fri, 20 Oct 2023 22:10:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qtxgv-005b8s-KF for pgsql-bugs@lists.postgresql.org; Fri, 20 Oct 2023 22:10:02 +0000 Content-Type: multipart/mixed; boundary="===============4287565596996141628==" MIME-Version: 1.0 Subject: BUG #18166: 100 Gb 18000000 records table update To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: ruslan.ganeev@list.ru Reply-To: ruslan.ganeev@list.ru, pgsql-bugs@lists.postgresql.org Date: Fri, 20 Oct 2023 22:09:18 +0000 Message-ID: <18166-8d0f3718572475ef@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4287565596996141628== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODE2NgpMb2dnZWQgYnk6ICAgICAgICAgIFJ1c2xhbiBHYW5lZXYKRW1h aWwgYWRkcmVzczogICAgICBydXNsYW4uZ2FuZWV2QGxpc3QucnUKUG9zdGdyZVNRTCB2ZXJzaW9u OiAxMi42Ck9wZXJhdGluZyBzeXN0ZW06ICAgQ2VudE9TIDgKRGVzY3JpcHRpb246ICAgICAgICAK CkdyZWV0aW5ncw0KQ291bGQgeW91IGhlbHAgdXMgd2l0aCB0aGUgZm9sbG93aW5nIA0KDQpXZSBo YXZlIGEgdGFibGUgd2l0aCBuYW1lIMKrc3ZqdWzCuywgdGhhdCBjb250YWlucyAxOCBtaWxsaW9u IHJlY29yZHMsIDEwMCBHYgpkaXNrIHNwYWNlIG9jY3VwaWVkIA0KDQpUaGUgdGFibGUgwqtzdmp1 bMK7IGNvbnRhaW5zIDMgY29sdW1ucyANCi0gIElEIChUeXBlOiBJbnRlZ2VyKSDigJMgaXTigJlz IGEga2V5DQotICBlbmRkYXRlIChUeXBlOiBEYXRlKSANCi0gIERhdGEgKFR5cGU6IEpTT05CKS4g VGhhdCBjb2x1bW4gY29udGFpbnMgZmllbGRzIMKrT0dSTsK7IGFuZCDCq0RhdGFWaXDCuy4gVGhl CnZhbHVlIGluIGEgcm93IMKrT0dSTsK7IGlzIG5vdCB1bmlxdWU6IHNldmVyYWwgcmVjb3JkcyBt YXkgY29udGFpbiB0aGUgc2FtZQpPR1JOLg0KDQpXZSB0cmllZCB0byBtYWtlIGEgc2NyaXB0LCB3 aGljaCBzZXRzIGVuZGRhdGUgPSAnMjAyMi0xMi0zMScgZm9yIGFsbApyZWNvcmRzLCBoYXZpbmcg dGhlIHZhbHVlIGluIMKrRGF0YVZpcMK7IHRoYXQgaXMgbm90IG1heGltYWwuICBGb3Igb3RoZXIK cmVjb3JkcyB0aGUgc2NyaXB0IHNldCBzIGVuZGRhdGUgPSBudWxsDQpUaGUgcHJvYmxlbSBpcyB0 aGF0IHRoZSBzY3JpcHQgaXMgcnVubmluZyBmb3IgNiBob3VycywgdGhlIG1haW4gcGVyY2VudGFn ZQpvZiB0aW1lIGlzIHRha2VuIGJ5IHRoZSByZWJ1aWxkaW5nIG9mIGluZGV4ZXMuDQoNCldvdWxk IHlvdSBiZSBzbyBraW5kIHRvIGhlbHAgdXMgd2l0aCB0aGUgaW5mb3JtYXRpb24gd2hldGhlciB0 aGVyZSBpcyBhbnkKcG9zc2liaWxpdHkgdG8gdXBkYXRlIHJlY29yZCB3aXRob3V0IHJlYnVpbGRp bmcgaW5kZXhlcy4gT3IgbWF5IGJlIHRoZXJlIGlzCnNvbWUgcHJvZ3JhbW1pbmcgdGVjaG5pcXVl IHRvIHNvbHZlIHRoZSBwcm9ibGVtIG9mIHRoaXMga2luZC4NCg0KU29ycnkgZm9yIG15IEVuZ2xp c2gsIEnigJltIG5vdCBhIG5hdGl2ZSBzcGVha2VyDQoNCkJlc3QgcmVnYXJkcw0KDQotLU91ciBz Y3JpcHQtLQ0KDQotLSAwIG1pbnV0ZQ0KZHJvcCB0YWJsZSBpZiBleGlzdHMgdGVtcHN2anVsMTsN CmNyZWF0ZSB0YWJsZSB0ZW1wc3ZqdWwxIChpZCBiaWdpbnQgbm90IG51bGwsIGNvZGUgdGV4dCBu b3QgbnVsbCwgZGF0YXBvc3R1Y2gKdGV4dCwgZGF0YXZpcCB0ZXh0LCBjb25zdHJhaW50IHRlbXBz dmp1bDFfcGtleSBwcmltYXJ5IGtleSAoaWQpKTsNCg0KLS0gMzAgbWludXRlDQppbnNlcnQgaW50 byB0ZW1wc3ZqdWwxKGlkLCBjb2RlLCBkYXRhcG9zdHVjaCwgZGF0YXZpcCkgc2VsZWN0IGlkLApk YXRhLT4+J09HUk4nLCBkYXRhIC0+ICdTdlVjaGV0Tk8nIC0+PiAnRGF0YVBvc3RVY2gnLCBkYXRh IC0+PiAnRGF0YVZpcCcKZnJvbSBzdmp1bDsNCg0KLS0gMSBtaW51dGUNCmNyZWF0ZSBpbmRleCBp ZHhfZGVkdXBsaWNhdGVfdGVtcHN2anVsMV9idHJlZV9jb2RlZHBvc3RkdmlwaWQgb24gdGVtcHN2 anVsMQp1c2luZyBidHJlZSAoY29kZSwgZGF0YXBvc3R1Y2ggZGVzYywgZGF0YXZpcCBkZXNjLCBp ZCBkZXNjKTsNCg0KLS0gMCBtaW51dGUNCmRyb3AgdGFibGUgaWYgZXhpc3RzIHRlbXBzdmp1bDI7 DQpjcmVhdGUgdGFibGUgdGVtcHN2anVsMihpZCBiaWdpbnQgbm90IG51bGwsIGNvbnN0cmFpbnQg dGVtcHN2anVsMl9wa2V5CnByaW1hcnkga2V5IChpZCkpOw0KDQotLSAyIG1pbnV0ZQ0KaW5zZXJ0 IGludG8gdGVtcHN2anVsMihpZCkgc2VsZWN0IGRpc3RpbmN0IG9uIChjb2RlKSBpZCBmcm9tIHRl bXBzdmp1bDEKb3JkZXIgYnkgY29kZSwgZGF0YXBvc3R1Y2ggZGVzYywgZGF0YXZpcCBkZXNjLCBp ZCBkZXNjOw0KDQotLSA0IG1pbnV0ZSB3aXRob3V0IGluZGV4ZXMgNiBob3VyIHdpdGggaW5kZXhl cw0KdXBkYXRlIHN2anVsIHNldA0KICAgIGNvZGUgPSBjb2FsZXNjZSgoc2VsZWN0IHRlbXBzdmp1 bDEuY29kZSBmcm9tIHRlbXBzdmp1bDEgd2hlcmUKdGVtcHN2anVsMS5pZCA9IHN2anVsLmlkKSwg Jz8/PycpLA0KICAgIGVuZGRhdGUgPSBjYXNlIHdoZW4gZXhpc3RzKHNlbGVjdCAxIGZyb20gdGVt cHN2anVsMiB3aGVyZSB0ZW1wc3ZqdWwyLmlkCj0gc3ZqdWwuaWQpIHRoZW4gbnVsbCBlbHNlICcy MDIzLTEwLTA1Jzo6ZGF0ZSBlbmQ7DQoNCi0tIDAgbWludXRlDQpkcm9wIHRhYmxlIHRlbXBzdmp1 bDE7DQpkcm9wIHRhYmxlIHRlbXBzdmp1bDI7Cgo= --===============4287565596996141628==--