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 1q78cY-00069g-Vb for pgsql-hackers@arkaria.postgresql.org; Thu, 08 Jun 2023 05:55:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q78cX-00077N-0O for pgsql-hackers@arkaria.postgresql.org; Thu, 08 Jun 2023 05:55:41 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q78cW-00077E-N0 for pgsql-hackers@lists.postgresql.org; Thu, 08 Jun 2023 05:55:40 +0000 Received: from mail-wm1-x332.google.com ([2a00:1450:4864:20::332]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1q78cT-000xnY-GQ for pgsql-hackers@lists.postgresql.org; Thu, 08 Jun 2023 05:55:39 +0000 Received: by mail-wm1-x332.google.com with SMTP id 5b1f17b1804b1-3f6e1394060so707735e9.3 for ; Wed, 07 Jun 2023 22:55:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1686203736; x=1688795736; h=content-transfer-encoding:in-reply-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=eHRr0GPFmLCIYi3QuDFTy+ojYU0HknEoyYMdULGNcT4=; b=hkcjo2jHqhRS4aJWCaqoZkvwWRvsY8IszMMLFwVHgpW0tpB4ZUNPsz4DXQVfxu2qP0 iiYxlvElixU1V6qhGvqtbgwqQbTxcVH+18/HUOx5cJL1aPg3Z62k5aXklLVBzMIgJ7lA 2owZbnVGydiXl7i50zemm+sIBuFUHrSH9E9QHSZUOlHyGlao20UZ63qtT0cXL6IdCcJH EvIJ6xAqFqBT+TVXzoSOlga2IbMiwob3C0sKRcKKTwgbjDycJAYbAsCoaoPryJvv+sFo 0+pQEJky2urMU0hl6/6sy0AUlWsdnqE550sy8tBor/Aa7veK9PyTg0vA2a/Y+jG0Vi3i DvCA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1686203736; x=1688795736; h=content-transfer-encoding:in-reply-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=eHRr0GPFmLCIYi3QuDFTy+ojYU0HknEoyYMdULGNcT4=; b=SgB/hJlgnYb8qEK7jiYqGJg1edY62NTKlPPo/hDWG19bwUzTGLeYCWHdWz18ame+2L eexul5SQLYSkPpWSN59LC25DdBGLccpfbeC1fzjDcBhIYKtHrtGtyv4ZUo409K+PIhC1 Df//7ZFPN52HNsgy2+MDRBy9h/bVR21JVeQfLbjQ8aVs7c8J/yjgKNk+hPv/naRvz8ee 6CmasFQhpMndiPmVF2/pI4ZaRKFxtYIbnlkOVVs8l3kQUBcJtxOpv0wGslX3UXdZBoAT RV7aqz0mVnYvw8LyRzLViEzI6roY32W/0MpVL6Y/F8F/pyy+sO2duKJpAQaq8LWwrAEF 1Plw== X-Gm-Message-State: AC+VfDydgV7/Zz6ps5G8hKVh76ZLLjO6slgMxAAFHWtr71ncsCGa3i43 OaV1Jy3IgxEL+HQCX8RBOXA= X-Google-Smtp-Source: ACHHUZ7ZOuQJql6K0PvQ/nDZIQWdzSJGynMB4OZtxqyue+7HR29fc38ZB139ZmUwVgFA9jbFQddtrg== X-Received: by 2002:a5d:4045:0:b0:30a:e643:2517 with SMTP id w5-20020a5d4045000000b0030ae6432517mr5287458wrp.21.1686203736377; Wed, 07 Jun 2023 22:55:36 -0700 (PDT) Received: from [192.168.20.65] ([54.239.6.189]) by smtp.gmail.com with ESMTPSA id y24-20020a7bcd98000000b003f7310a3ffasm829261wmj.2.2023.06.07.22.55.34 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 07 Jun 2023 22:55:35 -0700 (PDT) Message-ID: <65e31a5b-60f9-5f8b-a2da-b5800fbc3294@gmail.com> Date: Thu, 8 Jun 2023 07:55:34 +0200 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:102.0) Gecko/20100101 Thunderbird/102.11.2 Subject: Re: Let's make PostgreSQL multi-threaded Content-Language: en-US To: Jeremy Schneider , pgsql-hackers@lists.postgresql.org Cc: Thomas Kellerer , Tomas Vondra , Heikki Linnakangas , Tom Lane 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> <41c1e20d-f179-f87e-5929-80ca9ee0c105@gmx.net> From: "Drouvot, Bertrand" In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On 6/8/23 12:37 AM, Jeremy Schneider wrote: > On 6/7/23 2:39 PM, Thomas Kellerer wrote: >> Tomas Vondra schrieb am 07.06.2023 um 21:20: > > I did google search for "oracle threaded_execution" and browsed a bit; > didn't see anything that seems earth shattering so far. FWIW, I recall Karl Arao's wiki page: https://karlarao.github.io/karlaraowiki/#%2212c%20threaded_execution%22 where some performance and memory consumption studies have been done. Regards, -- Bertrand Drouvot PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com