public inbox for [email protected]  

help / color / mirror / Atom feed

From: Francisco Olarte <[email protected]>
To: Christian Schröder <[email protected]>
Cc: Muhammad Salahuddin Manzoor <[email protected]>
Cc: pgsql-general <[email protected]>
Cc: Eric Wong <[email protected]>
Subject: Re: Memory issues with PostgreSQL 15
Date: Thu, 30 May 2024 13:02:52 +0200
Message-ID: <CA+bJJbxT4S5hedrfBEzn2tDf650VLN8p6a6ey+QxSsctirtKBw@mail.gmail.com> (raw)
In-Reply-To: <LO0P265MB2700590113FEC61BE8B660F3F9F32@LO0P265MB2700.GBRP265.PROD.OUTLOOK.COM>
References: <LO0P265MB2700E0D30CC9A427956FC121F9F02@LO0P265MB2700.GBRP265.PROD.OUTLOOK.COM>
	<CAKD7CDkhQLGWm71nkAFBbuoQ92BGhz3FUkPDGrgrn1v8515H8g@mail.gmail.com>
	<LO0P265MB2700590113FEC61BE8B660F3F9F32@LO0P265MB2700.GBRP265.PROD.OUTLOOK.COM>

Hi christian:

On Thu, 30 May 2024 at 12:51, Christian Schröder
<[email protected]> wrote:
...
> I had already checked most of your points, but I double checked them now.
...
> Shared memory limits look good to me:
> # sudo sysctl -a | grep kernel.shm
> kernel.shmall = 18446744073692774399
> kernel.shmmax = 18446744073692774399
> kernel.shmmni = 4096

Bear in mind this is SysV shared memory. IIRC Pg uses POSIX shared
memory for shared buffers, which I think is backed normally in Linux
by files in a tmpfs mounted on /dev/shm. It still uses some amount of
SysV due to some special properties lacking from POSIX, for control
purposes, but only a little.

You could try "df -h /dev/shm" and "ls -lhR /dev/shm/" to see if you
have problems there.

Francisco Olarte.

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Memory issues with PostgreSQL 15
  In-Reply-To: <CA+bJJbxT4S5hedrfBEzn2tDf650VLN8p6a6ey+QxSsctirtKBw@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox