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 1q6EC1-0001wu-2F for pgsql-hackers@arkaria.postgresql.org; Mon, 05 Jun 2023 17:40:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q6EBz-0000E9-5j for pgsql-hackers@arkaria.postgresql.org; Mon, 05 Jun 2023 17:40:31 +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 1q6EBy-00007z-Fv for pgsql-hackers@lists.postgresql.org; Mon, 05 Jun 2023 17:40:30 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1q6EBr-000Nmb-26 for pgsql-hackers@postgresql.org; Mon, 05 Jun 2023 17:40:29 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Content-Type:In-Reply-To:Subject:From: References:Cc:To:MIME-Version:Date:Message-ID:Sender:Reply-To: Content-Transfer-Encoding:Content-ID:Content-Description; bh=KO7ZTFCXg/Ue/loH2JY8zWnOvFPx9bQzM4AGnIOAI68=; b=M+MEubVLzKCwaumHb2bVaQYph7 JsMeQwXMlDcoSfZy877r97vl7lIMuYKzlaOM4IFnCAdnlc6zM69uigP9tPMXqRun6373MDYZjU5Tj ZzbDlhh8+LnIRKT9dOIe2cB6d3OyAx4YHlwRV+hBAX+X0+T6CAlhcdZgE9EH0SqZzg6nO8/tqV1tf CRawnsm6L0KibwI+1PPlXSJSwt0O/zstFanjhnKMYIHA97deVPsZp3tNifyYfhm/68wOzPibBXJGo aEhKy6CPWFPUQv0JmTXj1lp1PQ2AOLWOw0GSzDiNgpxi6DA6wSzUGL4Y31MneZ7IdeyMogwIGL2mT wEmRrEcA==; Received: from [52.119.84.106] (helo=[192.168.88.177]) by meldrar.postgresql.org with esmtpsa (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1q6EBk-001AXR-RH; Mon, 05 Jun 2023 17:40:19 +0000 Message-ID: Date: Mon, 5 Jun 2023 13:40:13 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:102.0) Gecko/20100101 Thunderbird/102.11.0 Content-Language: en-US To: Heikki Linnakangas , Tom Lane Cc: pgsql-hackers References: <31cc6df9-53fe-3cd9-af5b-ac0d801163f4@iki.fi> <4178104.1685978307@sss.pgh.pa.us> <4ce6c0f8-e8a4-1672-93fd-49d3fa975ee5@iki.fi> From: "Jonathan S. Katz" Subject: Re: Let's make PostgreSQL multi-threaded In-Reply-To: <4ce6c0f8-e8a4-1672-93fd-49d3fa975ee5@iki.fi> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------CKXISNXA9C0SAZ09g7h0UzME" X-Host-Lookup-Failed: Reverse DNS lookup failed for 52.119.84.106 (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --------------CKXISNXA9C0SAZ09g7h0UzME Content-Type: multipart/mixed; boundary="------------TN7B236rgQogd70e0u0TrzGH"; protected-headers="v1" From: "Jonathan S. Katz" To: Heikki Linnakangas , Tom Lane Cc: pgsql-hackers Message-ID: Subject: Re: Let's make PostgreSQL multi-threaded References: <31cc6df9-53fe-3cd9-af5b-ac0d801163f4@iki.fi> <4178104.1685978307@sss.pgh.pa.us> <4ce6c0f8-e8a4-1672-93fd-49d3fa975ee5@iki.fi> In-Reply-To: <4ce6c0f8-e8a4-1672-93fd-49d3fa975ee5@iki.fi> --------------TN7B236rgQogd70e0u0TrzGH Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gNi81LzIzIDExOjMzIEFNLCBIZWlra2kgTGlubmFrYW5nYXMgd3JvdGU6DQo+IE9uIDA1 LzA2LzIwMjMgMTE6MTgsIFRvbSBMYW5lIHdyb3RlOg0KPj4gSGVpa2tpIExpbm5ha2FuZ2Fz IDxobGlubmFrYUBpa2kuZmk+IHdyaXRlczoNCj4+PiBJIHNwb2tlIHdpdGggc29tZSBmb2xr cyBhdCBQR0NvbiBhYm91dCBtYWtpbmcgUG9zdGdyZVNRTCBtdWx0aS10aHJlYWRlZCwNCj4+ PiBzbyB0aGF0IHRoZSB3aG9sZSBzZXJ2ZXIgcnVucyBpbiBhIHNpbmdsZSBwcm9jZXNzLCB3 aXRoIG11bHRpcGxlDQo+Pj4gdGhyZWFkcy4gSXQgaGFzIGJlZW4gZGlzY3Vzc2VkIG1hbnkg dGltZXMgaW4gdGhlIHBhc3QsIGxhc3QgdGhyZWFkIG9uDQo+Pj4gcGdzcWwtaGFja2VycyB3 YXMgYmFjayBpbiAyMDE3IHdoZW4gS29uc3RhbnRpbiBtYWRlIHNvbWUgZXhwZXJpbWVudHMg DQo+Pj4gWzBdLg0KPj4NCj4+PiBJIGZlZWwgdGhhdCB0aGVyZSBpcyBub3cgcHJldHR5IHN0 cm9uZyBjb25zZW5zdXMgdGhhdCBpdCB3b3VsZCBiZSBhIGdvb2QNCj4+PiB0aGluZywgbW9y ZSBzbyB0aGFuIGJlZm9yZS4gTG90cyBvZiB3b3JrIHRvIGdldCB0aGVyZSwgYW5kIGxvdHMg b2YNCj4+PiBkZXRhaWxzIHRvIGJlIGhhc2hlZCBvdXQsIGJ1dCBubyBvYmplY3Rpb25zIHRv IHRoZSBpZGVhIGF0IGEgaGlnaCBsZXZlbC4NCj4+DQo+Pj4gVGhlIHB1cnBvc2Ugb2YgdGhp cyBlbWFpbCBpcyB0byBtYWtlIHRoYXQgc2lsZW50IGNvbnNlbnN1cyBleHBsaWNpdC4gSWYN Cj4+PiB5b3UgaGF2ZSBvYmplY3Rpb25zIHRvIHN3aXRjaGluZyBmcm9tIHRoZSBjdXJyZW50 IG11bHRpLXByb2Nlc3MNCj4+PiBhcmNoaXRlY3R1cmUgdG8gYSBzaW5nbGUtcHJvY2Vzcywg bXVsdGktdGhyZWFkZWQgYXJjaGl0ZWN0dXJlLCBwbGVhc2UNCj4+PiBzcGVhayB1cC4NCj4+ DQo+PiBGb3IgdGhlIHJlY29yZCwgSSB0aGluayB0aGlzIHdpbGwgYmUgYSBkaXNhc3Rlci7C oCBUaGVyZSBpcyBmYXIgdG9vIG11Y2gNCj4+IGNvZGUgdGhhdCB3aWxsIGdldCBicm9rZW4s IGxhcmdlbHkgc2lsZW50bHksIGFuZCBtdWNoIG9mIGl0IGlzIG5vdA0KPj4gdW5kZXIgb3Vy IGNvbnRyb2wuDQo+IA0KPiBOb3RlZC4gT3RoZXIgbGFyZ2UgcHJvamVjdHMgaGF2ZSBnb25l IHRocm91Z2ggdGhpcyB0cmFuc2l0aW9uLiBJdCdzIG5vdCANCj4gZWFzeSwgYnV0IGl0J3Mg YSBsb3QgZWFzaWVyIG5vdyB0aGFuIGl0IHdhcyAxMCB5ZWFycyBhZ28uIFRoZSBwbGF0Zm9y bSANCj4gYW5kIGNvbXBpbGVyIHN1cHBvcnQgaXMgdGhlcmUgbm93LCBhbGwgbGlicmFyaWVz IGhhdmUgdGhyZWFkLXNhZmUgDQo+IGludGVyZmFjZXMsIGV0Yy4NCj4gDQo+IEkgZG9uJ3Qg ZXhwZWN0IHlvdSBvciBvdGhlcnMgdG8gYnV5IGludG8gYW55IHBhcnRpY3VsYXIgY29kZSBj aGFuZ2UgYXQgDQo+IHRoaXMgcG9pbnQsIG9yIHRvIGNvbnRyaWJ1dGUgdGltZSBpbnRvIGl0 LiBKdXN0IHRvIGFjY2VwdCB0aGF0IGl0J3MgYSANCj4gd29ydGh3aGlsZSBnb2FsLiBJZiB0 aGUgaW1wbGVtZW50YXRpb24gdHVybnMgb3V0IHRvIGJlIGEgZGlzYXN0ZXIsIHRoZW4gDQo+ IGl0IHdvbid0IGJlIGFjY2VwdGVkLCBvZiBjb3Vyc2UuIEJ1dCBJJ20gb3B0aW1pc3RpYy4N Cg0KSSBkb24ndCBoYXZlIGVub3VnaCBleHBlcnRpc2UgaW4gdGhpcyBhcmVhIHRvIGNvbW1l bnQgb24gaWYgaXQnZCBiZSBhIA0KImRpc2FzdGVyIiBvciBub3QuIE15IHpvb21lZCBvdXQg b2JzZXJ2YXRpb25zIGFyZSB0d28tZm9sZDoNCg0KMS4gSXQgc2VlbXMgbGlrZSB0aGVyZSdz IGEgbGFjayBvZiBjb25zZW5zdXMgb24gd2hpY2ggb2YgcHJvY2Vzc2VzIHZzLiANCnRocmVh ZHMgeWllbGQgdGhlIGJlc3QgcGVyZm9ybWFuY2UgYmVuZWZpdCwgYW5kIGZyb20gdGFsa2lu ZyB0byBmb2xrcyANCndpdGggZ3JlYXRlciBleHBlcnRpc2UgdGhhbiBtZSwgdGhpcyBjYW4g dmFyeSBiZXR3ZWVuIHdvcmtsb2Fkcy4gSSANCmJlbGlldmUgb25lIERCIGV2ZW4gZ2l2ZXMg dXNlcyBhIGNob2ljZSBpZiB0aGV5IHdhbnQgdG8gcnVuIGluIHByb2Nlc3NlcyANCnZzLiB0 aHJlYWRzLg0KDQoyLiBXaGlsZSBJIHdvdWxkbid0IHdhbnQgdG8gbmVjZXNzYXJpbHkgZGlz Y291cmFnZSBhIG1vb25zaG90IGVmZm9ydCwgSSANCndvdWxkIGFzayBpZiBkZXZlbG9wZXIg dGltZSBjb3VsZCBiZSBiZXR0ZXIgc3BlbnQgb24gdGFja2xpbmcgc29tZSBvZiANCnRoZSBv dGhlciBwcm9ibGVtcyBhcm91bmQgdmVydGljYWwgc2NhbGFiaWxpdHk/IFBlciBzb21lIFBH Q29uIA0KZGlzY3Vzc2lvbnMsIHRoZXJlJ3Mgc3RpbGwgcm9vbSBmb3IgaW1wcm92ZW1lbnQg aW4gaG93IFBvc3RncmVTUUwgY2FuIA0KYmVzdCB1dGlsaXplIHJlc291cmNlcyBhdmFpbGFi bGUgdmVyeSBsYXJnZSAiY29tbW9kaXR5IiBtYWNoaW5lcyAoYSANCjQ0OC1jb3JlIC8gMjRU QiBSQU0gaW5zdGFuY2UgY29tZXMgdG8gbWluZCkuDQoNCkknbSBwdXJwb3NlbHkgZ2l2aW5n IGEgbm9uYW5zd2VyIG9uIHdoZXRoZXIgaXQncyBhIHdvcnRod2hpbGUgZ29hbCwgYnV0IA0K cmF0aGVyIEknZCBiZSBjdXJpb3VzIHdoZXJlIGl0IGNvdWxkIHN0YWNrIHVwIGFnYWluc3Qg c29tZSBvdGhlciBlZmZvcnRzIA0KdG8gY29udGludWUgdG8gaGVscCBQb3N0Z3JlU1FMIGlt cHJvdmUgcGVyZm9ybWFuY2UgYW5kIGhhbmRsZSB2ZXJ5IGxhcmdlIA0Kd29ya2xvYWRzLg0K DQpUaGFua3MsDQoNCkpvbmF0aGFuDQo= --------------TN7B236rgQogd70e0u0TrzGH-- --------------CKXISNXA9C0SAZ09g7h0UzME Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wsF5BAABCAAjFiEE+oS2la8r95ogZD/x8QSccp8cZScFAmR+Hf0FAwAAAAAACgkQ8QSccp8cZSew 2w//Qh8UkZIURc0cp2oFnPUILDeVLBTNNqPhV4C5qc/j1DK0ngV4sx4cDQGoLV2JiyQSAl0HEdO4 Az/p8kcCgOQUoHPBQn3UUdd9GrYkadhsvceMeVrhG3wptqPzIoV1efri0kSy3RlN5y5jrxLeUzle ycFD9oRNt1rQInpR1tomOSyFZul/CEMHvX8g+O21U9tV2jHJnGKnooyK9UZuxtnDAMNjc8Z+Exxu +iAovt46e47fdcmW8w0odtZ8o4/JmXKqsSJO4LJLwJv5h/OdFAFIMdU9ugvoJ1tvkj1uQbZKLU5h w3qX/iHKK8ubrhDQqgMv4DNL7AzHqNSWA3qosJ80WFB941kHyr9hfCSE18eNu4DL8mFnQt8oo0NA BKU25o7koT01LFmb48znxmORNGpVaZR5mQaG01OnyHE50LzEKX0ZEnP6ORfAr72Y3VOFDY3j1tsp cvXp7CdSsau5ZkoD6Q7X8swzWTRvyQSi/CRDKZTZb5nBQ8epm2EvsgnEdUdchkQQbKd2NzPTWha1 2lIpsbw0A1FLiNzXS9kw1LeWTM45c8+XA9vWlDM/kukswu4JKNdTKJOMyC3Sj8FINSN0LGuNGHlm SCFR2Pyyhu38+ukxLjTRHb17so3tua/Mzg2PviRtFnnqjloNaXdz5fxj9MzmB+iucNU8HYqh/I5n G/E= =qGxF -----END PGP SIGNATURE----- --------------CKXISNXA9C0SAZ09g7h0UzME--