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-00BzkH-4y 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-OH 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 1sYWKh-002cGw-1U for pgsql-committers@lists.postgresql.org; Mon, 29 Jul 2024 19:46:59 +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-0027SL-54 for pgsql-committers@lists.postgresql.org; Mon, 29 Jul 2024 19:46:58 +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-006Xqu-6R 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-001mzV-Dt for pgsql-committers@lists.postgresql.org; Mon, 29 Jul 2024 19:46:53 +0000 Content-Type: multipart/mixed; boundary="===============8793354584333418959==" 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 --===============8793354584333418959== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VXNlIERFTEVURSBpbnN0ZWFkIG9mIFVQREFURSB0byBzcGVlZCB1cCB2YWN1dW0gdGVzdAoKZTJl OTkyODIwZjEwNGRlZiBpbnRyb2R1Y2VkIGEgdGVzdCB3aGljaCBnZW5lcmF0ZWQgZGVhZCB0dXBs ZXMgZm9yCnZhY3V1bSB3aXRoIGFuIFVQREFURS4gVGhlIHRlc3Qgb25seSByZXF1aXJlZCBlbm91 Z2ggZGVhZCBUSURzIGZvciB0d28Kcm91bmRzIG9mIGluZGV4IHZhY3V1bWluZy4gVGhpcyBjYW4g YmUgYWNjb21wbGlzaGVkIHdpdGggYSBERUxFVEUKaW5zdGVhZCBvZiBhbiBVUERBVEUgLS0gd2hp Y2ggZ2VuZXJhdGVzIGFib3V0IDUwJSBsZXNzIFdBTCBhbmQgbWFrZXMgdGhlCnRlc3QgMjAlIGZh c3RlciBpbiBtYW55IGNhc2VzLiBUaGUgdGVzdCB0YWtlcyBzZXZlcmFsIHNlY29uZHMgKG1vcmUg b24Kc2xvdyBidWlsZGZhcm0gYW5pbWFscykgYmVjYXVzZSB3ZSBuZWVkIHF1aXRlIGEgZmV3IHR1 cGxlcyB0byB0cmlnZ2VyCnR3byByb3VuZHMgb2YgaW5kZXggdmFjdXVtaW5nOyBzbyBpdCBpcyB3 b3J0aCBhIGZvbGxvdy1vbiBjb21taXQgdG8Kc3BlZWQgaXQgdXAuCgpTdWdnZXN0ZWQtYnk6IE1h c2FoaWtvIFNhd2FkYQpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL0NBQUtSdV9iV21N am1xTCUyQk9aMmR1RVE4MHU3Y1J2cHNFeExOWk5qemstcFhYNXNrd01RJTQwbWFpbC5nbWFpbC5j b20KQmFja3BhdGNoLXRocm91Z2g6IDE0LCB0aGUgZmlyc3QgdmVyc2lvbiBjb250YWluaW5nIHRo aXMgdGVzdC4KCkJyYW5jaAotLS0tLS0KUkVMXzE1X1NUQUJMRQoKRGV0YWlscwotLS0tLS0tCmh0 dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvOTc0NGZlMjQxMThiYTU3Mzhk ZGE5MDA4NTMzZWQwMDIyN2Y1ZDA2OQoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3Jj L3Rlc3QvcmVjb3ZlcnkvdC8wNDNfdmFjdXVtX2hvcml6b25fZmxvb3IucGwgfCAyICstCjEgZmls ZSBjaGFuZ2VkLCAxIGluc2VydGlvbigrKSwgMSBkZWxldGlvbigtKQoK --===============8793354584333418959==--