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 1q70st-0003b9-HL for pgsql-hackers@arkaria.postgresql.org; Wed, 07 Jun 2023 21:40: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 1q70ss-0000zE-DQ for pgsql-hackers@arkaria.postgresql.org; Wed, 07 Jun 2023 21:40:02 +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 1q70ss-0000x2-21 for pgsql-hackers@lists.postgresql.org; Wed, 07 Jun 2023 21:40:02 +0000 Received: from mout.gmx.net ([212.227.15.18]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1q70sm-000mGR-Sc for pgsql-hackers@lists.postgresql.org; Wed, 07 Jun 2023 21:40:00 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=s31663417; t=1686173994; x=1686778794; i=shammat@gmx.net; bh=/z8E9xKglfuxXHx2B441ALdOR0VVKL7lp2rJlM1rTUQ=; h=X-UI-Sender-Class:Subject:To:References:From:Date:In-Reply-To; b=eMF/67Lxyu23qOudlC4/tFQbwqTo9gD5EkO2ODPq0I3BZNuoUIU+3DNuSvGtl/F4rqoeH5n M6Lj4k9q/jLtlsoTtqes6hMbqj69PUIceoGKUAr1jlHxlUHTE+1N8Hb41g5ITAj8RZXzE3Pr8 hi360ZWDprLsEilbwPmo/ot690UPmwTgByEOrquLxCqf9fBSGRLuE7cRyIXrHbyfTpVJo1wxJ 6UFQgKY5E0ZPFbGFiPhJFPqfrgGyhUibUQKM85ELYxTn3+L4WLrkEe1v8RoEA0YPZaD0rA/W/ F8/o5PqEysaZsRrkE1oD7lSIrAn2ZtnUWOzMKaPHaxQgfEBaLpNw== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from [192.168.178.20] ([88.217.180.11]) by mail.gmx.net (mrgmx004 [212.227.17.190]) with ESMTPSA (Nemesis) id 1MTiU3-1qasUh2Jbx-00U0s7 for ; Wed, 07 Jun 2023 23:39:54 +0200 Subject: Re: Let's make PostgreSQL multi-threaded To: pgsql-hackers@lists.postgresql.org References: <31cc6df9-53fe-3cd9-af5b-ac0d801163f4@iki.fi> <4178104.1685978307@sss.pgh.pa.us> <4ce6c0f8-e8a4-1672-93fd-49d3fa975ee5@iki.fi> <29fe5f48-a6ed-d896-45ed-16b5904353a9@enterprisedb.com> From: Thomas Kellerer Message-ID: <41c1e20d-f179-f87e-5929-80ca9ee0c105@gmx.net> Date: Wed, 7 Jun 2023 23:39:54 +0200 User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.21) Gecko/20090302 Thunderbird/2.0.0.21 Mnenhy/0.7.5.666 MIME-Version: 1.0 In-Reply-To: <29fe5f48-a6ed-d896-45ed-16b5904353a9@enterprisedb.com> Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: de-DE Content-Transfer-Encoding: 7bit X-Provags-ID: V03:K1:gLfD2DJDyTnO/cp6oeQRk6X4JH24jgsHLcX6wIeBiSuEKur4q++ AEsU3jWpp88WzvS/DzY6X0WUlDRiBP6vxCd5BTOt8BumRLiuO4oHkKotereqUHRCviaFCYi MNAXOGe0GvhCjNUCSV5QwueDGyGQXJR4NOTHRGfiAYJjTPyUt9LOQEGeqp164ym9uzmWiCq JmEVfL8T1yUlzyOEX2LOg== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:IeUDHOjGkq8=;mB3vN72qAXnCTwVBTM7QxxGnAoZ iFwcwSyShl6IeDvdDAkCUka+CVrFPRYjpNOxQLDPbESuP3R1NAoqf+CqMtlBfgeoIn2/48kGE BfGrY2Vfl4RQTna1LiAA9KKUvHuqAYFix3OKnaWU9dloi4UxxNaIN8mbmShqAqEJJe02IzI8c Q8c9wCcw1HWa5NZlWF3JMqlAUe+BwgvMXTQX18ygetgVX6FvSpB01GtoV4fZp4fIdLqWjk9VO gP/QzrtHyI3feIGmwnQqA5A0R+3N3DjW+SULxeK4saF5WYNd7yYuz/VFxjCvRNsF0ohrSLBmS LwrbNOmKmJPxq9cTxlkEPNjhScSNGCdaiLp6KId3NySZDFwhvqlCvqVF1gD5fjEwJB1C7nGpr OKu93xQTE1+klw/mnp0nnAoG4AmZM1Vi5H5fMxHQuQSAbe4ZuEr8rNNMf16noUcWzVT+1b7lC xadkALXdG99DuyWafPf/AyMSl5/3EExjLK3HFfzVjyTR0msHaBgn0y6Mza0vhHBKwtjHosJHa 9Nh39H9xSB0TntcMt3Lhz3eVcsS/wM4BofaBsamV8ElGwjuO+tyn9N1fBPXvUkbculexvhscD eXA27cirVLVoktkVmI0jhFXqaLqkHjGys6QhXxuCdlM1NvYKmUJdhx58U1aeOpiV1dwK8bZgG bJZLASrKA7NwBzF414WHTEhU1OfjA7zUVRwtkkGad3Qqp6tYoirSmaZ/pNJDK4/YZDM6uGRsG ONu+JVNzAL6FZB+glQmJRs6wuERR8+ZEhakl3Y7kdwKBV/IAtALfjtuuS4247nAPQF/aH6wz4 zd2ILBj6fnl/AveaXGHkHdX2z9DC9y4Zi4hwX7S/M3iUf4Cr46sO3G3TulJ2GhCc2BmqeS2pL e6hMeSAC0wWpumeOc24UoNCpXrGXQUFJcRQ6WlB/ZJI+Zvp15BXh1SLh7zkzrReExB4swnwZ8 Hh9y5LBkljZm8Swkz2Ymr9SWrFs= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Tomas Vondra schrieb am 07.06.2023 um 21:20: > Also, which other projects did this transition? Is there something we > could learn from them? Were they restricted to much smaller list of > platforms? Firebird did this a while ago if I'm not mistaken. Not open source, but Oracle was historically multi-threaded on Windows and multi-process on all other platforms. I _think_ starting with 19c you can optionally run it multi-threaded on Linux as well. But I doubt, they are willing to share any insights ;)