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 1rNr81-00GNMz-Nl for pgsql-bugs@arkaria.postgresql.org; Thu, 11 Jan 2024 09:13:34 +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 1rNr80-00AQa3-TW for pgsql-bugs@arkaria.postgresql.org; Thu, 11 Jan 2024 09:13:32 +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 1rNorJ-009u5W-8K for pgsql-bugs@lists.postgresql.org; Thu, 11 Jan 2024 06:48:09 +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 1rNorG-000xgv-DL for pgsql-bugs@lists.postgresql.org; Thu, 11 Jan 2024 06:48:08 +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=DsrGLpZn0bu0fHia5TihGPM8Gj1BFNVD5BalBZSvs9E=; b=Baqum8cneYZPiWVfEVH8vMz69c MlRDYqfuREmp2+9NYmFhYh4jDsawZLN3NPY2iF5FMe30Jnl+fQR0U4rwAqAqmWTaOZsC9ImqyZ4sC AmOiHlbq9lWT8qsgp/NJsed2PkTCJ9RC0bXyMmDfBjvRHjGA6hozJSu2uAbKUPirG6iPO89rPTu1F YoAnULhIS465hCkwqxymMo5WnQmFg5v5DN+LEk4x/dGBXQumR8v4VXJRHdOTCntwonnogcB27Urfh 7qvDpOGaQIYBeG3vTMAroA+TDX6drobWy3q6ReA3I7Yses1ALFNQ9Ub9OuTP2jy+i4i6FO4vob2Am iSp1lzKA==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rNorD-002tce-OM for pgsql-bugs@lists.postgresql.org; Thu, 11 Jan 2024 06:48:04 +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 1rNorC-006FGy-KD for pgsql-bugs@lists.postgresql.org; Thu, 11 Jan 2024 06:48:02 +0000 Content-Type: multipart/mixed; boundary="===============5255654483329409692==" MIME-Version: 1.0 Subject: BUG #18283: vacuum full use a large amount of memory (may cause OOM) To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: fairyfar@msn.com Reply-To: fairyfar@msn.com, pgsql-bugs@lists.postgresql.org Date: Thu, 11 Jan 2024 06:47:43 +0000 Message-ID: <18283-72dcaf4228caf47e@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 --===============5255654483329409692== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODI4MwpMb2dnZWQgYnk6ICAgICAgICAgIFpodSBZYW5nCkVtYWlsIGFk ZHJlc3M6ICAgICAgZmFpcnlmYXJAbXNuLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDE2LjEKT3Bl cmF0aW5nIHN5c3RlbTogICBSZWQgSGF0IEVudGVycHJpc2UgTGludXggU2VydmVyIDcuNiAoTWFp cG8pCkRlc2NyaXB0aW9uOiAgICAgICAgCgpVbmRlciBjZXJ0YWluIGNvbmRpdGlvbnMsIGEgdmFj dXVtIGZ1bGwgd2lsbCB1c2UgYSBsb3Qgb2YgbWVtb3J5LiBUaGUgbWVtb3J5CnVzYWdlIGlzIG91 dCBvZiBjb250cm9sLCBhbmQgYW4gT09NIG1heSBvY2N1ci4NCg0KU3RlcCB0byByZXByb2R1Y2Ug dGhlIGJlaGF2aW9yOg0KDQpTdGVwIDEuIENyZWF0ZSBhIG5ldyBzZXNzaW9uKCJTZXNzIDEiKSwg dGhlbiBleGVjdXRlIHRoZSBmb2xsb3dpbmcgcXVlcnkgYW5kCmtlZXAgdGhlIGNvbm5lY3Rpb246 DQpgYGBzcWwNCi0tIGNyZWF0ZSB0YWJsZSBhbmQgaW5zZXJ0IGRhdGEgZm9yIHRlc3RpbmcuDQpj cmVhdGUgdGFibGUgdDEgKA0KCWMxIGNoYXJhY3RlciB2YXJ5aW5nKDEwMCksDQoJYzIgY2hhcmFj dGVyIHZhcnlpbmcoMTAwKSwNCgljMyBjaGFyYWN0ZXIgdmFyeWluZygxMDApLA0KCWM0IGNoYXJh Y3RlciB2YXJ5aW5nKDEwMCksDQoJYzUgY2hhcmFjdGVyIHZhcnlpbmcoMTAwKSwNCgljNiBjaGFy YWN0ZXIgdmFyeWluZygxMDApDQopOw0KDQpjcmVhdGUgZnVuY3Rpb24gcmFuZG9tdGV4dChsZW4g aW50KSByZXR1cm5zIHRleHQgYXMgJCQNCnNlbGVjdCBzdHJpbmdfYWdnKG1kNShyYW5kb20oKTo6 dGV4dCksJycpIGZyb20gZ2VuZXJhdGVfc2VyaWVzKDEsJDEvMzIpDQokJCBsYW5ndWFnZSBzcWw7 DQoNCmluc2VydCBpbnRvIHQxIHNlbGVjdApyYW5kb210ZXh0KDM0KSxyYW5kb210ZXh0KDM0KSxy YW5kb210ZXh0KDM0KSxyYW5kb210ZXh0KDM0KSxyYW5kb210ZXh0KDM0KSwnUlNUJwpmcm9tIGdl bmVyYXRlX3NlcmllcygxLDEwMDAwMDApOw0KYGBgDQoNClN0ZXAgMi4gQ3JlYXRlIGFub3RoZXIg c2Vzc2lvbigiU2VzcyAyIikuIFN0YXJ0IGEgbG9uZyB0cmFuc2FjdGlvbiwgdGhlbgpjcmVhdGUg YW55IHRhYmxlLCBhbmQga2VlcCB0aGUgY29ubmVjdGlvbjoNCg0KYGBgc3FsDQpCRUdJTjsNCmNy ZWF0ZSB0YWJsZSB0MihhIGludCk7DQpgYGANCg0KU3RlcCAzLiBHbyBiYWNrIHRvICJTZXNzIDEi IGFuZCBjb250aW51ZToNCg0KYGBgc3FsDQotLSBHZXQgdGhlIFBJRCBvZiB0aGUgY3VycmVudCBi YWNrZW5kDQpwb3N0Z3Jlcz0jIHNlbGVjdCBwZ19iYWNrZW5kX3BpZCgpOw0KIHBnX2JhY2tlbmRf cGlkDQotLS0tLS0tLS0tLS0tLS0tDQogICAgICAgICAgMTA1MTENCigxIHJvdykNCg0KLS0gQ2Fu IHVwZGF0ZSBtdWx0aXBsZSB0aW1lcw0KdXBkYXRlIHQxIHNldCBjMj1yYW5kb210ZXh0KDM0KSB3 aGVyZSBrMT0nUlNUJzsNCnVwZGF0ZSB0MSBzZXQgYzI9cmFuZG9tdGV4dCgzNCkgd2hlcmUgazE9 J1JTVCc7DQoNCnZhY3V1bSBmdWxsIHQxOw0KYGBgDQoNClN0ZXAgNC4gQ3JlYXRlIGEgbmV3IGJh c2ggdGVybWluYWwgYW5kIHZpZXcgdGhlIG1lbW9yeSB1c2FnZSBvZiBQSUQgMTA1MTEKZHVyaW5n IHRoZSBleGVjdXRpb24gb2YgJ3ZhY3VtbSBmdWxsJzoNCg0KYGBgYmFzaA0KW3l6QGJvZ29uIH5d JCB0b3AgLXAgMTA1MTENCg0KICBQSUQgVVNFUiAgICAgIFBSICBOSSAgICBWSVJUICAgIFJFUyAg ICBTSFIgUyAgJUNQVSAlTUVNICAgICBUSU1FKwpDT01NQU5EDQoxMDUxMSB5eiAgICAgICAgMjAg ICAwIDE4NTMzNDAgICAxLjZnIDE0MTQ4OCBEICAxNS43IDIxLjQgICAwOjE0LjkyCnBvc3RncmVz DQpgYGANCg0KWW91IGNhbiBvYnNlcnZlIHRoYXQgJ3ZhY3VtbSBmdWxsJyBtZW1vcnkgdXNhZ2Ug KFZJUlQgJiBSRVMpIGlzIHZlcnkgaGlnaCwKd2l0aCB0aGUgcGVhayBtZW1vcnkgdXNhZ2UgaW5j cmVhc2luZyB3aXRoIGVhY2ggU3RlcCAzIGV4ZWN1dGlvbi4NCg0KQWZ0ZXIgYW5hbHlzaXMsIHRo ZSBNZW1vcnlDb250ZXh0IHRoYXQgY29uc3VtZXMgc2lnbmlmaWNhbnQgbWVtb3J5IGlzICJUYWJs ZQpyZXdyaXRlIiwgYW5kIHRoZSBzdGFjayBpczoNCg0KYGBgDQojMCAgMHgwMDAwMDAwMDAwNTBm NzAwIGluIGhlYXBfY29weXR1cGxlICgpDQojMSAgMHgwMDAwMDAwMDAwNTRmNDUyIGluIHJld3Jp dGVfaGVhcF90dXBsZSAoKQ0KIzIgIDB4MDAwMDAwMDAwMDU0ODQ0ZiBpbiByZWZvcm1fYW5kX3Jl d3JpdGVfdHVwbGUuaXNyYS4wICgpDQojMyAgMHgwMDAwMDAwMDAwNTQ4OGUwIGluIGhlYXBhbV9y ZWxhdGlvbl9jb3B5X2Zvcl9jbHVzdGVyICgpDQojNCAgMHgwMDAwMDAwMDAwNjE2NzYwIGluIGNv cHlfdGFibGVfZGF0YSAoKQ0KIzUgIDB4MDAwMDAwMDAwMDYxNzg0NiBpbiBjbHVzdGVyX3JlbCAo KQ0KIzYgIDB4MDAwMDAwMDAwMDY3Njk3MyBpbiB2YWN1dW1fcmVsICgpDQojNyAgMHgwMDAwMDAw MDAwNjc3YjljIGluIHZhY3V1bSAoKQ0KIzggIDB4MDAwMDAwMDAwMDY3ODJkYyBpbiBFeGVjVmFj dXVtICgpDQojOSAgMHgwMDAwMDAwMDAwODA4ODU5IGluIHN0YW5kYXJkX1Byb2Nlc3NVdGlsaXR5 ICgpDQojMTAgMHgwMDAwMDAwMDAwODA2ZjVmIGluIFBvcnRhbFJ1blV0aWxpdHkgKCkNCiMxMSAw eDAwMDAwMDAwMDA4MDcwOGIgaW4gUG9ydGFsUnVuTXVsdGkgKCkNCiMxMiAweDAwMDAwMDAwMDA4 MDc1NWQgaW4gUG9ydGFsUnVuICgpDQojMTMgMHgwMDAwMDAwMDAwODAzYjI4IGluIGV4ZWNfc2lt cGxlX3F1ZXJ5ICgpDQouLi4NCmBgYA0KDQpUaGUgY29kZSB0aGF0IGNhdXNlcyB0aGUgcHJvYmxl bSBpcyBpbgpzcmMvYmFja2VuZC9hY2Nlc3MvaGVhcC9yZXdyaXRlaGVhcC5jOg0KDQpgYGBjDQp2 b2lkDQpyZXdyaXRlX2hlYXBfdHVwbGUoUmV3cml0ZVN0YXRlIHN0YXRlLA0KCQkJCSAgIEhlYXBU dXBsZSBvbGRfdHVwbGUsIEhlYXBUdXBsZSBuZXdfdHVwbGUpDQp7DQoJLi4uDQoJaWYgKCEoKG9s ZF90dXBsZS0+dF9kYXRhLT50X2luZm9tYXNrICYgSEVBUF9YTUFYX0lOVkFMSUQpIHx8DQoJCSAg SGVhcFR1cGxlSGVhZGVySXNPbmx5TG9ja2VkKG9sZF90dXBsZS0+dF9kYXRhKSkgJiYNCgkJIUhl YXBUdXBsZUhlYWRlckluZGljYXRlc01vdmVkUGFydGl0aW9ucyhvbGRfdHVwbGUtPnRfZGF0YSkg JiYNCgkJIShJdGVtUG9pbnRlckVxdWFscygmKG9sZF90dXBsZS0+dF9zZWxmKSwNCgkJCQkJCQkm KG9sZF90dXBsZS0+dF9kYXRhLT50X2N0aWQpKSkpDQoJew0KCQkvLyBJZiB0aGUgY29kZSBleGVj dXRlcyBpbnNpZGUgdGhpcyBibG9jaywgdGhlIGFsbG9jYXRlZCBtZW1vcnkgd2lsbCBub3QKYmUg ZnJlZWQgdW50aWwgdGhlIHF1ZXJ5IGVuZHMuDQoJCS4uLg0KYGBgCgo= --===============5255654483329409692==--