Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r8qZv-00C3kY-QJ for pgsql-hackers@arkaria.postgresql.org; Thu, 30 Nov 2023 23:36:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1r8qZu-003uOa-EY for pgsql-hackers@arkaria.postgresql.org; Thu, 30 Nov 2023 23:36:18 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r8qZu-003uOR-4z for pgsql-hackers@lists.postgresql.org; Thu, 30 Nov 2023 23:36:18 +0000 Received: from lahtoruutu.iki.fi ([185.185.170.37]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r8qZr-008BNI-CY for pgsql-hackers@postgresql.org; Thu, 30 Nov 2023 23:36:16 +0000 Received: from [192.168.1.115] (dsl-hkibng22-54f8db-125.dhcp.inet.fi [84.248.219.125]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits) server-digest SHA256) (No client certificate requested) (Authenticated sender: hlinnaka) by lahtoruutu.iki.fi (Postfix) with ESMTPSA id 4ShCHx42yWz49Q33; Fri, 1 Dec 2023 01:36:13 +0200 (EET) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=iki.fi; s=lahtoruutu; t=1701387373; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=Jd/wrkUzvtlWciwO4uSCY1D6vSQVuu15Z/7sxKytM4Q=; b=CF+dlmSkirYZNp5wHCzXxu278fkhLPxWBR23bEeIodGJBSBN/zyce09LPej+J98E33kluM IzX/L02qlI5n1f09Y6okPlVcdhTC7IQxzynrK3n94yI3RyuNtMcWFJYyJu68GS7KHEbfhK Eeef4Ppk6jI8NFHvWv7CEKrGjSvwxEG2wd11SPPXmfhYOmtOHKYDwD5ZSsH/A3Zee2JDi+ vD+fuO1TEQK9AM0nNWToqZHX1vudVcVLQ06E7IY4szLPqaKfwv1x7tKn1QXzOkruYb81SQ K0RsnZ8x2v+5HOFqZIRWDF1cOxfoUSBVMgIlRoFmn+vNTKe7renyY0etGq3Fjg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=iki.fi; s=lahtoruutu; t=1701387373; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=Jd/wrkUzvtlWciwO4uSCY1D6vSQVuu15Z/7sxKytM4Q=; b=rNEvIxt49p4QhXuCG2UuCVZQGPXseev/ft6N32+EgC0oiXgg78AA4v+mUgEhuUEry9ypwj bcVwoovdjI/423sNCx+QuFwQ9FVEWe1yn4+fb6omCtOLQAG7HsrUVCDgBSk/9Bipc3PgXd E3JIr0+bbR6vszgn/9S7aT5E/uKkf/njfLUOOqhFgXDraevIu9jqRgrd1huSGV8UM5ATbb 4/SuatCVmugyxuCHMtVqMfdFm+z1GEFB8Gz9kik9mkZsKEjlyUM9mPCRTm6SmlfX4mfFWD tOIlH70UEtu9Zo54SOiBrEEb+owAcR0OT6hHGQjDIYz07PCKCpzLuzZz4JYwDg== ARC-Seal: i=1; s=lahtoruutu; d=iki.fi; t=1701387373; a=rsa-sha256; cv=none; b=VxDMuVlWitCpnkaOBL0Q3R6XY2zH08Xx/9fOyTpuppvwzei8nOUiygDDOOKrqwP+ryA27c BihDTKsudINGx0rJwEimvhxq3rxiKPbDz/Kly6t+czTAIm67UlVGHP0+yIvBcuaQpBaa5R rYGM2NHTv1tI0UFoHeGSLFjIsli5J7ATAHy4pqot7noFZbOC2JXiwJHHKy2+84P4kBYoiK ZhstY/DJlyeWQ0BUU+cw7oQp+IKkcoIB+V0yzXcFiCFpOYj8Z1Ng/G8ffkuqdaaLTOFI++ nlNPwx0KeMhc4YSF9bWWg5SFwlCP0S4rR5pm/0XzbXXbnveKBgC/IWsw4ADimQ== ARC-Authentication-Results: i=1; ORIGINATING; auth=pass smtp.auth=hlinnaka smtp.mailfrom=hlinnaka@iki.fi Message-ID: <3df4b075-fb15-4e35-8981-10ed29aef208@iki.fi> Date: Fri, 1 Dec 2023 01:36:13 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Refactoring backend fork+exec code Content-Language: en-US To: Andres Freund Cc: Tristan Partin , pgsql-hackers , Thomas Munro References: <7a59b073-5b5b-151e-7ed3-8b01ff7ce9ef@iki.fi> <20230710225043.svl7fqxecwshwc7a@awork3.anarazel.de> <119551e6-60f6-49b2-ae04-a382a89f900c@iki.fi> <20231130202648.7k6agmuizdilufnv@awork3.anarazel.de> From: Heikki Linnakangas In-Reply-To: <20231130202648.7k6agmuizdilufnv@awork3.anarazel.de> 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 On 30/11/2023 22:26, Andres Freund wrote: > On 2023-11-30 01:36:25 +0200, Heikki Linnakangas wrote: >> From a96b6e92fdeaa947bf32774c425419b8f987b8e2 Mon Sep 17 00:00:00 2001 >> From: Heikki Linnakangas >> Date: Thu, 30 Nov 2023 00:01:25 +0200 >> Subject: [PATCH v3 1/7] Refactor CreateSharedMemoryAndSemaphores >> >> For clarity, have separate functions for *creating* the shared memory >> and semaphores at postmaster or single-user backend startup, and >> for *attaching* to existing shared memory structures in EXEC_BACKEND >> case. CreateSharedMemoryAndSemaphores() is now called only at >> postmaster startup, and a new AttachSharedMemoryStructs() function is >> called at backend startup in EXEC_BACKEND mode. > > I assume CreateSharedMemoryAndSemaphores() is still called during crash > restart? Yes. > I wonder if it shouldn't split three ways: > 1) create > 2) initialize > 3) attach Why? What would be the difference between create and initialize phases? -- Heikki Linnakangas Neon (https://neon.tech)