MIME-Version: 1.0
References: <LO0P265MB2700E0D30CC9A427956FC121F9F02@LO0P265MB2700.GBRP265.PROD.OUTLOOK.COM>
 <CA+bJJbyzFdr1i1Yarqt=JnsN0WUg+veRvYZC1+kaYnWFGjiYRw@mail.gmail.com> <LO0P265MB2700F3C159F47D8F039D6B1FF9F12@LO0P265MB2700.GBRP265.PROD.OUTLOOK.COM>
In-Reply-To: <LO0P265MB2700F3C159F47D8F039D6B1FF9F12@LO0P265MB2700.GBRP265.PROD.OUTLOOK.COM>
From: Francisco Olarte <folarte@peoplecall.com>
Date: Wed, 29 May 2024 10:23:38 +0200
Message-ID: <CA+bJJbwvtpLaAWXCj4FwTdsO+V5Kuc4iP=fSkbW4VZzqfC_B9A@mail.gmail.com>
Subject: Re: Memory issues with PostgreSQL 15
To: =?UTF-8?Q?Christian_Schr=C3=B6der?= <christian.schroeder@wsd.com>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>, Eric Wong <eric.wong@wsd.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CA%2BbJJbwvtpLaAWXCj4FwTdsO%2BV5Kuc4iP%3DfSkbW4VZzqfC_B9A%40mail.gmail.com>
Precedence: bulk

Hi Christian:

On Wed, 29 May 2024 at 00:59, Christian Schr=C3=B6der
<christian.schroeder@wsd.com> wrote:
> Thank you for your advice. I used "ipcs" to get more readable information=
 about the shared memory:
...
> As far as I understand, there is no upper limit to the size of the shared=
 memory. The database only holds a single shared memory segment, which does=
n't seem to have a relevant size.

Seems the same to me, so I will disregard that.

> I am surprised to see this since I would have expected much more shared m=
emory to be used by the database. Is there anything in the configuration th=
at prevents the shared memory from being used?

I am not too current with postgres, that one was a thing which
happened to me when I did more administration, and is one you always
want to check. I assume you have all checked, but I would follow by
insuring every mounted partition in your system has space. I am not
current on the details, but I know Pg can be mmaping things and doing
other stuff. Your problem seems more of resource exhaustion, so I
would follow by checking that, both disk, tmpfs and all the other
stuff. I cannot give you advice on that as it depends a lot on your
server configuration and from the age in the mssages I suspect you
have the usual suspects debugged. But as you have a configuration
crahsing in minutes and it seems to be a dev server you could do it
easily.

Sorry.

   Francisco Olarte.