Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1peRGF-0004LB-5h for pgsql-committers@arkaria.postgresql.org; Tue, 21 Mar 2023 01:58:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1peRGD-0001uA-42 for pgsql-committers@arkaria.postgresql.org; Tue, 21 Mar 2023 01:58:01 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1peRGC-0001u0-SD for pgsql-committers@lists.postgresql.org; Tue, 21 Mar 2023 01:58:00 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1peRGA-0000Ni-2j for pgsql-committers@lists.postgresql.org; Tue, 21 Mar 2023 01:57:59 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=6EAaiDFXxEDJgk0KWULGzKyBOpVcQwzqjpplfMLxdsk=; b=Ny0CDPadXWXVuj2ngSiDWmwcqr +VF5yUvBzKo/NftWLN5O3545r66xQ/il68osLbt5TlsKn8duCyvbfX931hWAKvS7mHW2RiRXHJzxw kF585+5TTvNLuuckfhpQjCVbwUAX++besTdDbwUajaPBMnP/BgP1PHofHQfE6dzyvnXe0m83rc8iC By4PXTL/iFICvlX6NZSoIh0+eydkfncwq5lMQEfCCXSgtSh2BV64jgwATp3wwpJ9I44nHRgKKm/vc ydLpGmCq+upzww6VFEmPCUL6/1WhmgtMiUR3A52d53b3dclXRYA5b+mOlpS4FbEvhatJIeirOnffQ 3YH1y5aQ==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1peRG9-00033f-EP for pgsql-committers@lists.postgresql.org; Tue, 21 Mar 2023 01:57:57 +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 1peRG8-004Zb7-86 for pgsql-committers@lists.postgresql.org; Tue, 21 Mar 2023 01:57:56 +0000 Content-Type: multipart/mixed; boundary="===============7093906837015444012==" MIME-Version: 1.0 From: Thomas Munro To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix race in parallel hash join batch cleanup, take II. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 21 Mar 2023 01:57:56 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7093906837015444012== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IHJhY2UgaW4gcGFyYWxsZWwgaGFzaCBqb2luIGJhdGNoIGNsZWFudXAsIHRha2UgSUkuCgpX aXRoIHVubHVja3kgdGltaW5nIGFuZCBwYXJhbGxlbF9sZWFkZXJfcGFydGljaXBhdGlvbj1vZmYg KG5vdCB0aGUKZGVmYXVsdCksIFBISiBjb3VsZCBhdHRlbXB0IHRvIGFjY2VzcyBwZXItYmF0Y2gg c2hhcmVkIHN0YXRlIGp1c3QgYXMgaXQKd2FzIGJlaW5nIGZyZWVkLiAgVGhlcmUgd2FzIGNvZGUg aW50ZW5kZWQgdG8gcHJldmVudCB0aGF0IGJ5IGNoZWNraW5nCmZvciBhIGNsZWFyZWQgcG9pbnRl ciwgYnV0IGl0IHdhcyByYWN5LiAgRml4LCBieSBpbnRyb2R1Y2luZyBhbiBleHRyYQpiYXJyaWVy IHBoYXNlLiAgVGhlIG5ldyBwaGFzZSBQSEpfQlVJTERfUlVOTklORyBtZWFucyB0aGF0IGl0J3Mg c2FmZSB0bwphY2Nlc3MgdGhlIHBlci1iYXRjaCBzdGF0ZSB0byBmaW5kIGEgYmF0Y2ggdG8gaGVs cCB3aXRoLCBhbmQKUEhKX0JVSUxEX0RPTkUgbWVhbnMgdGhhdCBpdCBpcyB0b28gbGF0ZS4gIFRo ZSBsYXN0IHRvIGRldGFjaCB3aWxsIGZyZWUKdGhlIGFycmF5IG9mIHBlci1iYXRjaCBzdGF0ZSBh cyBiZWZvcmUsIGJ1dCBub3cgaXQgd2lsbCBhbHNvIGF0b21pY2FsbHkKYWR2YW5jZSB0aGUgcGhh c2UsIHNvIHRoYXQgbGF0ZSBhdHRhY2hlcnMgY2FuIGF2b2lkIHRoZSBoYXphcmQuICBUaGlzCm1p cnJvcnMgdGhlIHdheSBwZXItYmF0Y2ggaGFzaCB0YWJsZXMgYXJlIGZyZWVkIChzZWUgcGhhc2Vz ClBISl9CQVRDSF9QUk9CSU5HIGFuZCBQSEpfQkFUQ0hfRE9ORSkuCgpBbiBlYXJsaWVyIGF0dGVt cHQgdG8gZml4IHRoaXMgKGNvbW1pdCAzYjg5ODFiNiwgbGF0ZXIgcmV2ZXJ0ZWQpIG1pc3NlZApv bmUgc3BlY2lhbCBjYXNlLiAgV2hlbiB0aGUgaW5uZXIgc2lkZSBpcyBlbXB0eSAodGhlICJlbXB0 eSBpbm5lcgpvcHRpbWl6YXRpb24pLCB0aGUgYnVpbGQgYmFycmllciB3b3VsZCBvbmx5IG1ha2Ug aXQgdG8KUEhKX0JVSUxEX0hBU0hJTkdfSU5ORVIgcGhhc2UgYmVmb3JlIHdvcmtlcnMgYXR0ZW1w dGVkIHRvIGRldGFjaCBmcm9tCnRoZSBoYXNodGFibGUuICBJbiB0aGF0IGNhc2UsIGZhc3QtZm9y d2FyZCB0aGUgYnVpbGQgYmFycmllciB0bwpQSEpfQlVJTERfUlVOTklORyBiZWZvcmUgcHJvY2Vl ZGluZywgc28gdGhhdCBvdXIgbGF0ZXIgYXNzZXJ0aW9ucyBob2xkCmFuZCB3ZSBjYW4gc3RpbGwg bmVnb3RpYXRlIHdobyBpcyBjbGVhbmluZyB1cC4KClJldmVhbGVkIGJ5IGJ1aWxkIGZhcm0gZmFp bHVyZXMsIHdoZXJlIEJhcnJpZXJBdHRhY2goKSBmYWlsZWQgYSBzYW5pdHkKY2hlY2sgYXNzZXJ0 aW9uLCBiZWNhdXNlIHRoZSBtZW1vcnkgaGFkIGJlZW4gY2xvYmJlcmVkIGJ5IGRzYV9mcmVlKCku CkluIG5vbi1hc3NlcnQgYnVpbGRzLCB0aGUgcmVzdWx0IGNvdWxkIGJlIGEgc2VnbWVudGF0aW9u IGZhdWx0LgoKQmFjay1wYXRjaCB0byBhbGwgc3VwcG9ydGVkIHJlbGVhc2VzLgoKQXV0aG9yOiBU aG9tYXMgTXVucm8gPHRob21hcy5tdW5yb0BnbWFpbC5jb20+CkF1dGhvcjogTWVsYW5pZSBQbGFn ZW1hbiA8bWVsYW5pZXBsYWdlbWFuQGdtYWlsLmNvbT4KUmVwb3J0ZWQtYnk6IE1pY2hhZWwgUGFx dWllciA8bWljaGFlbEBwYXF1aWVyLnh5ej4KUmVwb3J0ZWQtYnk6IERhdmlkIEdlaWVyIDxnZWlk YXYucGdAZ21haWwuY29tPgpUZXN0ZWQtYnk6IERhdmlkIEdlaWVyIDxnZWlkYXYucGdAZ21haWwu Y29tPgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzIwMjAwOTI5MDYxMTQyLkdBMjkw OTYlNDBwYXF1aWVyLnh5egoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpo dHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzhkNTc4YjliMmUzN2E0ZDlk NmY0MjJjZWQ1MTI2YWNlYzYyMzY1YTcKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNy Yy9iYWNrZW5kL2V4ZWN1dG9yL25vZGVIYXNoLmMgICAgIHwgNTAgKysrKysrKysrKysrKysrKysr KysrKystLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9leGVjdXRvci9ub2RlSGFzaGpvaW4uYyB8IDU0 ICsrKysrKysrKysrKysrKysrKysrKysrKysrLS0tLS0tLS0tLS0Kc3JjL2luY2x1ZGUvZXhlY3V0 b3IvaGFzaGpvaW4uaCAgICAgfCAgMyArKy0KMyBmaWxlcyBjaGFuZ2VkLCA3NCBpbnNlcnRpb25z KCspLCAzMyBkZWxldGlvbnMoLSkKCg== --===============7093906837015444012==--