From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Kenny Bachman <kenny.bachman17@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: postgresql memory problem
Date: Mon, 21 Feb 2022 09:23:29 +0100
Message-ID: <924cb7284c36a96a844ab36bc3608763df6182a0.camel@cybertec.at> (raw)
In-Reply-To: <CAC0w7LJo204rRAuXZA5Gv6W_Zdn0WRq-rCKjqNxYiUC6uxRHSA@mail.gmail.com>
References: <CAC0w7LJo204rRAuXZA5Gv6W_Zdn0WRq-rCKjqNxYiUC6uxRHSA@mail.gmail.com>
On Mon, 2022-02-21 at 10:56 +0300, Kenny Bachman wrote:
> Firstly, I want to thank you all for the amazing help.
> I need your guidance with PostgreSQL. So, I have a 3-nodes patroni cluster running PostgreSQL 12.9 version. I got some errors related to a memory issue.
>
> ERROR: could not resize shared memory segment "/PostgreSQL.346141036" to 16776236 bytes: No space left on device
>
> FATAL: out of memory
> DETAIL: Failed on request of size 128 in-memory context "CacheMemoryContext"
>
> My PostgreSQL parameters related to memory;
> work_mem : 128MB
> shared_buffer: 16GB
> effective_cache_size: 200GB
> maintenance_work_mem: 2GB
>
> My server profile:
> free -g
> total used free shared buff/cache available
> Mem: 377 28 22 0 326 347
> Swap: 127 0 127
>
> df
> tmpfs 189G 2.0M 189G 1% /dev/shm
>
> What do you think about this? Can you advise some hints?
There should be a memory dump in the PostgreSQL log.
Considering the small size of 128, the problem might be somewhere else.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
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: pgsql-admin@postgresql.org
Cc: laurenz.albe@cybertec.at, kenny.bachman17@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: postgresql memory problem
In-Reply-To: <924cb7284c36a96a844ab36bc3608763df6182a0.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox