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 1sYWNi-00BzkI-64 for pgsql-committers@arkaria.postgresql.org; Mon, 29 Jul 2024 19:50:06 +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 1sYWNg-002eOI-Oy for pgsql-committers@arkaria.postgresql.org; Mon, 29 Jul 2024 19:50:04 +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 1sYWKi-002cft-Un for pgsql-committers@lists.postgresql.org; Mon, 29 Jul 2024 19:47:00 +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 1sYWKe-0027SM-6Q for pgsql-committers@lists.postgresql.org; Mon, 29 Jul 2024 19:47:00 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sYWKc-006Xqv-6C for pgsql-committers@lists.postgresql.org; Mon, 29 Jul 2024 19:46:54 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sYWKb-001mzX-ER for pgsql-committers@lists.postgresql.org; Mon, 29 Jul 2024 19:46:53 +0000 Content-Type: multipart/mixed; boundary="===============8493715965057989004==" MIME-Version: 1.0 From: Melanie Plageman To: pgsql-committers@lists.postgresql.org Subject: pgsql: Use DELETE instead of UPDATE to speed up vacuum test X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 29 Jul 2024 19:46:53 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8493715965057989004== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VXNlIERFTEVURSBpbnN0ZWFkIG9mIFVQREFURSB0byBzcGVlZCB1cCB2YWN1dW0gdGVzdAoKZDQy ZjYwY2NmMDdkODljIGludHJvZHVjZWQgYSB0ZXN0IHdoaWNoIGdlbmVyYXRlZCBkZWFkIHR1cGxl cyBmb3IgdmFjdXVtCndpdGggYW4gVVBEQVRFLiBUaGUgdGVzdCBvbmx5IHJlcXVpcmVkIGVub3Vn aCBkZWFkIFRJRHMgZm9yIHR3byByb3VuZHMKb2YgaW5kZXggdmFjdXVtaW5nLiBUaGlzIGNhbiBi ZSBhY2NvbXBsaXNoZWQgd2l0aCBhIERFTEVURSBpbnN0ZWFkIG9mIGFuClVQREFURSAtLSB3aGlj aCBnZW5lcmF0ZXMgYWJvdXQgNTAlIGxlc3MgV0FMIGFuZCBtYWtlcyB0aGUgdGVzdCAyMCUKZmFz dGVyIGluIG1hbnkgY2FzZXMuIFRoZSB0ZXN0IHRha2VzIHNldmVyYWwgc2Vjb25kcyAobW9yZSBv biBzbG93CmJ1aWxkZmFybSBhbmltYWxzKSBiZWNhdXNlIHdlIG5lZWQgcXVpdGUgYSBmZXcgdHVw bGVzIHRvIHRyaWdnZXIgdHdvCnJvdW5kcyBvZiBpbmRleCB2YWN1dW1pbmc7IHNvIGl0IGlzIHdv cnRoIGEgZm9sbG93LW9uIGNvbW1pdCB0byBzcGVlZCBpdAp1cC4KClN1Z2dlc3RlZC1ieTogTWFz YWhpa28gU2F3YWRhCkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vQ0FBS1J1X2JXbU1q bXFMJTJCT1oyZHVFUTgwdTdjUnZwc0V4TE5aTmp6ay1wWFg1c2t3TVElNDBtYWlsLmdtYWlsLmNv bQpCYWNrcGF0Y2gtdGhyb3VnaDogMTQsIHRoZSBmaXJzdCB2ZXJzaW9uIGNvbnRhaW5pbmcgdGhp cyB0ZXN0LgoKQnJhbmNoCi0tLS0tLQpSRUxfMTRfU1RBQkxFCgpEZXRhaWxzCi0tLS0tLS0KaHR0 cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi85MjRhMDhiNzZmNWQ5Zjg5YjI1 NjljYWVkMjYxMTNmMGEwMjBjNjQ0CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMv dGVzdC9yZWNvdmVyeS90LzA0M192YWN1dW1faG9yaXpvbl9mbG9vci5wbCB8IDIgKy0KMSBmaWxl IGNoYW5nZWQsIDEgaW5zZXJ0aW9uKCspLCAxIGRlbGV0aW9uKC0pCgo= --===============8493715965057989004==--