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 1pkOyH-0002DS-Mr for pgsql-general@arkaria.postgresql.org; Thu, 06 Apr 2023 12:44:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pkOyG-0005gj-0M for pgsql-general@arkaria.postgresql.org; Thu, 06 Apr 2023 12:44:08 +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 1pkOyF-0005ga-An for pgsql-general@lists.postgresql.org; Thu, 06 Apr 2023 12:44:07 +0000 Received: from tamriel.snowman.net ([2001:470:e38f::11]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1pkOy7-001FQQ-64 for pgsql-general@postgresql.org; Thu, 06 Apr 2023 12:44:06 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id 3CB2B5F7B9; Thu, 6 Apr 2023 08:43:52 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=snowman.net; s=dkim; t=1680785032; 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: in-reply-to:in-reply-to:references:references; bh=XkxYDBHhwb5mnORYxwVxi45xodApNoLkCgD8i+atVrw=; b=IF8KY2LFVdIq/goBvr9vfsg7U1EOKTJifsT2H23Ro0kKX2rAC/i0dEtTJBfxTHDCOU/cH/ 18vjN+T8jRoo34Tt/NrSDJTHnEohFi8ZVHjakfDlZAO1t0c1bqo1Y6a7hvsyDRIFQN/YEv I53d79JUBPrQiSqS0zQwj9hD4q27KIg= Date: Thu, 6 Apr 2023 08:43:52 -0400 From: Stephen Frost To: Marco Fortina Cc: "pgsql-general@postgresql.org" Subject: Re: Proposal: Shared Work Mem Area Message-ID: References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="UtppEBtddCFB4ojr" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/2.1.4 (2021-12-11) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --UtppEBtddCFB4ojr Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Greetings, * Marco Fortina (marco_fortina@hotmail.it) wrote: > I would like to propose to developers a new feature to replace the privat= e management of the work mem with a management through shared memory: alloc= ated at the start of PostgreSQL this area should be shared to all worker pr= ocesses as for example Oracle Database PGA do. >=20 > This would allow an optimal use of this memory area by limiting only its = global maximum limit and not a configuration/allocation at the process leve= l. >=20 > What do you think about my proposal? There's ongoing work to provide a way to have a global maximum limit which doesn't involve entirely reworking how work_mem works today. The commitfest entry for that work is here: https://commitfest.postgresql.org/42/3867/ If you're interested in that, getting additional reviews and comments on the work would be helpful in moving it forward. Thanks, Stephen --UtppEBtddCFB4ojr Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEwf6gbxKhD863zrx/7WyKOINHZFUFAmQuvoUACgkQ7WyKOINH ZFXzyRAAr/4ekWPGvRfGGuKbHGv9VQRRheYJG5KZl5HCPIk+v43RbDIjnC2s7P+9 aZyVNK9XN2P3pvNSlIfmJPAaos7exTcHm/QvZFmLE0ueHGZfXEOTeF4XnsEWhScS zLmJI2z/HGPWixBcA1/3vXelQdr8BbaywSnIfLv3J2WVv9o4ry8V0deoGUL8ZkOQ 8TihjagcDUdrFXEhetnyjcyRhpKOD+pnxCWlXxv+wFfhApLZ32FRJ0wGZTAcJsJ2 IdYB6ZvW9UcAtpvp06gpjjuMox9nyvLUORb8zlF7LE9WewssuzGuL/L6VZ6oaEEF F8TSGlNNTHgC1QLrCDx3WPnuPSGeHT2z/MlS8IkSCOy8oMCqGm2iYnWHbmGbmwJ6 83tUswYTgcrqvu4StxeeQiS4N1D9ToD4YS0A6CYJ7GCmf7FkZ51j/YSi0MDDrxVG B/HIjf1YKBATEcl9oAwP+PVIhmythxJqbZFXrKSA+UapDF1xEuzt8sOJR3BD+PxB aTyBAtkkQkoXKpiTS5Da6kwFoEscVz6FGoZqmL2X1LMTBt8MiEG61EIugrT4PZe6 dkUo9mRELTlG+2vvjqSJ59p17aGqemcpGrNkkFRo2Ybeg0JKShZbatmHvg346nqM IZMw9Ja330vNQZ0kGJCZ5mLArldWek0QdWuVjuo/ZeLL+/kjyIM= =QayN -----END PGP SIGNATURE----- --UtppEBtddCFB4ojr--