Re: Memory issues with PostgreSQL 15 - Mailing list pgsql-general

From Ron Johnson
Subject Re: Memory issues with PostgreSQL 15
Date
Msg-id CANzqJaD2+LVRvvHWr627d_p9s0EqN2FQcdScd6HOP1Y3e9HcuQ@mail.gmail.com
Whole thread Raw
In response to RE: Memory issues with PostgreSQL 15  (Christian Schröder <christian.schroeder@wsd.com>)
List pgsql-general
On Thu, Jul 25, 2024 at 6:59 AM Christian Schröder <christian.schroeder@wsd.com> wrote:
Hi all,
I started this discussion in May and was then dragged into other topics, so I could never follow up. Sorry for that!
Since then, the problem has resurfaced from time to time. Right now, we seem to have issues again, which gives me the opportunity to follow up on your various suggestions.

The current error messages are similar to what we have seen before:

<2024-07-25 12:27:38 CEST - > LOG:  could not fork autovacuum worker process: Cannot allocate memory
<2024-07-25 12:27:38 CEST - mailprocessor> ERROR:  could not resize shared memory segment "/PostgreSQL.1226901392" to 189280 bytes: No space left on device

What's mailprocessor?  Maybe it's using some tmpfs device.

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: Memory issues with PostgreSQL 15
Next
From: KK CHN
Date:
Subject: PgbackRest PointTIme Recovery : server unable to start back