Message-ID: <924cb7284c36a96a844ab36bc3608763df6182a0.camel@cybertec.at>
Subject: Re: postgresql memory problem
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Kenny Bachman <kenny.bachman17@gmail.com>,
	pgsql-admin@lists.postgresql.org
Date: Mon, 21 Feb 2022 09:23:29 +0100
In-Reply-To: 
 <CAC0w7LJo204rRAuXZA5Gv6W_Zdn0WRq-rCKjqNxYiUC6uxRHSA@mail.gmail.com>
References: 
	<CAC0w7LJo204rRAuXZA5Gv6W_Zdn0WRq-rCKjqNxYiUC6uxRHSA@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
User-Agent: Evolution 3.40.4 (3.40.4-2.fc34) 
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/924cb7284c36a96a844ab36bc3608763df6182a0.camel%40cybertec.at>
Precedence: bulk

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