From: | Kenny Bachman <kenny(dot)bachman17(at)gmail(dot)com> |
---|---|
To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: postgresql memory problem |
Date: | 2022-02-21 08:56:13 |
Message-ID: | CAC0w7LLesFVOH7D7UU1+auxGTEKGEFcQ6FQphOunirvDqD75+Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi Laurenz,
Thank you so much for your suggestion. I set a lower work_mem setting
(64MB), then I will monitor for a while.
Best regards,
KB
Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, 21 Şub 2022 Pzt, 11:23 tarihinde
şunu yazdı:
> 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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Gaurav Anand | 2022-02-21 14:04:04 | Postgres 10 - Attach-Detach Partition in Declarative vs Inheritance |
Previous Message | Laurenz Albe | 2022-02-21 08:23:29 | Re: postgresql memory problem |