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 1sYWKh-00BzPF-I8 for pgsql-committers@arkaria.postgresql.org; Mon, 29 Jul 2024 19:46:59 +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 1sYWKg-002cBP-30 for pgsql-committers@arkaria.postgresql.org; Mon, 29 Jul 2024 19:46:58 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sYWKf-002cBH-SJ for pgsql-committers@lists.postgresql.org; Mon, 29 Jul 2024 19:46:57 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sYWKc-0025V7-Ns for pgsql-committers@lists.postgresql.org; Mon, 29 Jul 2024 19:46:56 +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 1sYWKb-006Xqs-TW for pgsql-committers@lists.postgresql.org; Mon, 29 Jul 2024 19:46:53 +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-001mzR-Cw for pgsql-committers@lists.postgresql.org; Mon, 29 Jul 2024 19:46:53 +0000 Content-Type: multipart/mixed; boundary="===============3625667119028425123==" 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 --===============3625667119028425123== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VXNlIERFTEVURSBpbnN0ZWFkIG9mIFVQREFURSB0byBzcGVlZCB1cCB2YWN1dW0gdGVzdAoKMDFl MmI3ZjBmZDAyYTQ0ZSBpbnRyb2R1Y2VkIGEgdGVzdCB3aGljaCBnZW5lcmF0ZWQgZGVhZCB0dXBs ZXMgZm9yCnZhY3V1bSB3aXRoIGFuIFVQREFURS4gVGhlIHRlc3Qgb25seSByZXF1aXJlZCBlbm91 Z2ggZGVhZCBUSURzIGZvciB0d28Kcm91bmRzIG9mIGluZGV4IHZhY3V1bWluZy4gVGhpcyBjYW4g YmUgYWNjb21wbGlzaGVkIHdpdGggYSBERUxFVEUKaW5zdGVhZCBvZiBhbiBVUERBVEUgLS0gd2hp Y2ggZ2VuZXJhdGVzIGFib3V0IDUwJSBsZXNzIFdBTCBhbmQgbWFrZXMgdGhlCnRlc3QgMjAlIGZh c3RlciBpbiBtYW55IGNhc2VzLiBUaGUgdGVzdCB0YWtlcyBzZXZlcmFsIHNlY29uZHMgKG1vcmUg b24Kc2xvdyBidWlsZGZhcm0gYW5pbWFscykgYmVjYXVzZSB3ZSBuZWVkIHF1aXRlIGEgZmV3IHR1 cGxlcyB0byB0cmlnZ2VyCnR3byByb3VuZHMgb2YgaW5kZXggdmFjdXVtaW5nOyBzbyBpdCBpcyB3 b3J0aCBhIGZvbGxvdy1vbiBjb21taXQgdG8Kc3BlZWQgaXQgdXAuCgpTdWdnZXN0ZWQtYnk6IE1h c2FoaWtvIFNhd2FkYQpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL0NBQUtSdV9iV21N am1xTCUyQk9aMmR1RVE4MHU3Y1J2cHNFeExOWk5qemstcFhYNXNrd01RJTQwbWFpbC5nbWFpbC5j b20KQmFja3BhdGNoLXRocm91Z2g6IDE0LCB0aGUgZmlyc3QgdmVyc2lvbiBjb250YWluaW5nIHRo aXMgdGVzdC4KCkJyYW5jaAotLS0tLS0KUkVMXzE2X1NUQUJMRQoKRGV0YWlscwotLS0tLS0tCmh0 dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvNTcxZTBlZTQwZWJkYWYwYzc1 YjExNzU2NjIwYzljOWQ0NTNjYzY0NAoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3Jj L3Rlc3QvcmVjb3ZlcnkvdC8wNDNfdmFjdXVtX2hvcml6b25fZmxvb3IucGwgfCAyICstCjEgZmls ZSBjaGFuZ2VkLCAxIGluc2VydGlvbigrKSwgMSBkZWxldGlvbigtKQoK --===============3625667119028425123==--