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 1peRGU-0004Lw-2X for pgsql-committers@arkaria.postgresql.org; Tue, 21 Mar 2023 01:58:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1peRGS-0002SA-W1 for pgsql-committers@arkaria.postgresql.org; Tue, 21 Mar 2023 01:58:16 +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 1peRGS-0002S0-Ob for pgsql-committers@lists.postgresql.org; Tue, 21 Mar 2023 01:58:16 +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 1peRGQ-0000O5-8Q for pgsql-committers@lists.postgresql.org; Tue, 21 Mar 2023 01:58:15 +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=mpT2MZnQP+0pxz6gPOp95JPzPkaK8BxveOQ0HiGi780=; b=TkZwSCdKRYNwfPnoTpDPgRZFc7 Ad75fdoP+89h+WojcFrmMm2kuIQQMRBToPfyHcooB39Q/KY6yvkdidsT9gt66Hx0SuDZljEBIdhIK JDrfw3EGBQ6B4Ouhvvi9c1J80CqbrLIH36n6iQJvmkpfOdY0DCJ5bfSwXt8sqmrVyFSJA0O09+hVt SVgU4SeMjI+uH2K2qYlX8azHVHnJ1pHswi73Zx8e9QkMvIacxIytyYVDI8doKXjxSL4a/7abdxKdS QlTWALHU92GGXs4S9vw1AJxH6azRriBzznmN7Y0BZ5k977Z6if/JHUESrP9iBptuvqQJUSHF3wQhP BZ33XVuQ==; 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 1peRGP-000347-TU for pgsql-committers@lists.postgresql.org; Tue, 21 Mar 2023 01:58:13 +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 1peRGP-004ZcI-0I for pgsql-committers@lists.postgresql.org; Tue, 21 Mar 2023 01:58:13 +0000 Content-Type: multipart/mixed; boundary="===============4938881779488987634==" 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:58:13 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4938881779488987634== 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 OTYlNDBwYXF1aWVyLnh5egoKQnJhbmNoCi0tLS0tLQpSRUxfMTVfU1RBQkxFCgpEZXRhaWxzCi0t LS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi9jMDNjNmU4Y2Y2 YTkxMThhM2QxMjE5ZWMwY2IwNmI0MzlkYjU0MTAwCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0t LS0tLQpzcmMvYmFja2VuZC9leGVjdXRvci9ub2RlSGFzaC5jICAgICB8IDUwICsrKysrKysrKysr KysrKysrKysrKysrLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvZXhlY3V0b3Ivbm9kZUhhc2hqb2lu LmMgfCA1NCArKysrKysrKysrKysrKysrKysrKysrKysrKy0tLS0tLS0tLS0tCnNyYy9pbmNsdWRl L2V4ZWN1dG9yL2hhc2hqb2luLmggICAgIHwgIDMgKystCjMgZmlsZXMgY2hhbmdlZCwgNzQgaW5z ZXJ0aW9ucygrKSwgMzMgZGVsZXRpb25zKC0pCgo= --===============4938881779488987634==--