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 1tWA1h-00EdbL-HU for pgsql-general@arkaria.postgresql.org; Fri, 10 Jan 2025 08:05:53 +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 1tWA1g-00DIVN-Vh for pgsql-general@arkaria.postgresql.org; Fri, 10 Jan 2025 08:05:52 +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 1tWA1g-00DIVE-KM for pgsql-general@lists.postgresql.org; Fri, 10 Jan 2025 08:05:52 +0000 Received: from mail-ej1-x635.google.com ([2a00:1450:4864:20::635]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tWA1e-000qVi-0G for pgsql-general@postgresql.org; Fri, 10 Jan 2025 08:05:51 +0000 Received: by mail-ej1-x635.google.com with SMTP id a640c23a62f3a-aaedd529ba1so258609666b.1 for ; Fri, 10 Jan 2025 00:05:50 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1736496349; x=1737101149; darn=postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=A23+oLMBLtgKDBUNMut9Xvv8F770gSJi8W/Pdlago4o=; b=sjeCi0PaUsc+FZLMHfMcpjhQSo2Ko+r+nnAEb6WwHf5QzIYNz05rU8FVrsXSWw1ek8 bgbWucKFiuc4e4s3eZbmYsbJMsbzL/dG7uppGSYapdHR+ymIXa//QFQbxfTcTy/wvMth New7rU7rV/vCfpVEhFSiDUHCPQJxGj0iHFz4AE847c7JxVLoU6YsEN4SM6JZOnj6+nAi 1AfmUYssbmntDfNmtLD/nbQi/352mf7mi+zWUyA3ckViG6M+ZjxcYOHtSIkXM/dyk53v 9Ropmesyzujn5G59LaM3+eXBt7DrxoPE6K/fqiNlg3m1yn2T9XIehEpezWMzjV9jjZIL Tflg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1736496349; x=1737101149; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=A23+oLMBLtgKDBUNMut9Xvv8F770gSJi8W/Pdlago4o=; b=jZdPMtvu3YWkHeK9UHfAim5D0p7nn1AKDh1mBHXcSYBRkP8H92XrE7iSX/SsEmOSg7 1U4rdKYUNMj05u5Knj1C0oOUnP2QsiAVg0PsrEZdhZfPMMSrMUjdRGISMYQc3xWHmG3k 5CPMCqoBviwuxQO+0B/TYYybyD92hcdwc1QJuc/qs6oC8jO5pD3RcoxaRus2OencdJVP +fj1WDPjXPwK+s98uu+eyhevN8cjHcMVEFcSlUZWnIZ80ttqIsnnFXgiAomzsyhJsmK4 bHxE+KbbsPJrHp1Zh0vHroZb4yrVSFAA3yaJ7oKValEfmC0U59A3mT+l6vRn6qDlAvT5 xKjw== X-Forwarded-Encrypted: i=1; AJvYcCU5qZT2zxOLYDhGv8cCzFUn83kQpUSch7w4R8jt+iyQw6f2rNmmk1hshecG8DPXSHoN+uHjXLn6xJ6lsbqE@postgresql.org X-Gm-Message-State: AOJu0YymkgvxeNBmOc7+c7sFhnR1eDNw4kOAECGygeZbvS23GEc4N346 Q+qVgByFYih0bywiTZOZDgFfgfcHdElYVoPtdhSkvCuX2InzbCAKM32kJUTCorg= X-Gm-Gg: ASbGncsMoPYmZAHmfM3gxUY8+Et6cEWKhodkDdEuLSczSPuHmipNRacGVhO7LUm7g71 gWxjLJkiQ+1NAy6nbDU7kIsPtQAo9QC65dJ9mAdJSIWQKIa2A72s/azHKnmAXx7ENgHT4U0wApS IZhJ8DUWwrGVc5mgbI0yDoVfZKdAxeOOjS0XwakKIsKGUNdMZRRJAEbOhN7Loassiwfm6Fx4zJS 9izizYgMYtE4f4WX+YdaNIqB9d1ka9ohJR0kz5nAqqCLsfD5TMf0sCBPZbaf23BbIwh0NwRLRp8 X-Google-Smtp-Source: AGHT+IFM3DYtfbsiuz6aCuiyCRzY7KHGkamgFAwzfB8PA0Ulq+5Sm1zgb1tF1UIeqzzOjIYIM72A7g== X-Received: by 2002:a05:6402:4415:b0:5d0:abb8:7a3 with SMTP id 4fb4d7f45d1cf-5d972e000c5mr23248824a12.6.1736496348859; Fri, 10 Jan 2025 00:05:48 -0800 (PST) Received: from localhost.localdomain ([2001:871:5e:e87d:b942:77f8:162e:c98a]) by smtp.gmail.com with ESMTPSA id 4fb4d7f45d1cf-5d99008c469sm1407672a12.5.2025.01.10.00.05.48 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 10 Jan 2025 00:05:48 -0800 (PST) Message-ID: <0afb859dabc47de3460fde28867d95ae71415fe7.camel@cybertec.at> Subject: Re: Parameter - shared_memory_size From: Laurenz Albe To: Jayadevan M , "pgsql-general@postgresql.org" Date: Fri, 10 Jan 2025 09:05:47 +0100 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.54.2 (3.54.2-1.fc41) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, 2025-01-10 at 12:14 +0530, Jayadevan M wrote: > I am trying to understand the parameter=C2=A0shared_memory_size. It is a = static parameter > that reports the size of the shared memory area. Does that imply that the= value may > change depending on the memory used by the server? No, that value will never change. It is set once after the start of the server, after the server has allocate= d shared buffers and other shared memory segments, and after the modules in "shared_preload_libraries" have had a chance to allocate shared memory too. Yours, Laurenz Albe