From: Jean-Christophe Boggio <postgresql@thefreecat.org>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: One PG process eating more than 40GB of RAM and getting killed by OOM
Date: Fri, 13 Oct 2023 16:31:21 +0200
Message-ID: <b9a4bf45-65ca-4598-beae-84e269331fbb@thefreecat.org> (raw)
In-Reply-To: <897a43b3-60d0-2417-f821-9299fd204c1d@sqlexec.com>
References: <1018f9c0-9d14-4146-b7e9-24c48ea29e1d@thefreecat.org>
<897a43b3-60d0-2417-f821-9299fd204c1d@sqlexec.com>
Le 13/10/2023 à 15:12, MichaelDBA a écrit :
> Turn off the OOM killer so you would get a nicer me ssage in PG log
> file instead of crashing the PG service.
> vm.overcommit_memory=2
Did this and now the process dies much quicker (without seemingly
consume all the available memory)... Also I can not launch thunderbird
anymore with this setting...
Anyway, I also reduced work_mem to 128Mb
You can find the corresponding logs attached.
Thanks for your help,
JC
--
*Jean-Christophe Boggio*
*Independant consultant and developer*
cat@thefreecat.org
Office : +33 2 46 65 56 96
Mobile : +33 6 60 70 83 70
<https://improvize.eu;
104^bis rue Avisseau
37000 Tours
France
Attachments:
[image/png] chVy7ZG5Zdp20p1e.png (27.7K, ../b9a4bf45-65ca-4598-beae-84e269331fbb@thefreecat.org/3-chVy7ZG5Zdp20p1e.png)
download | view image
[text/x-log] pg_outofmemory.log (83.6K, ../b9a4bf45-65ca-4598-beae-84e269331fbb@thefreecat.org/4-pg_outofmemory.log)
download
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: postgresql@thefreecat.org, pgsql-admin@lists.postgresql.org
Subject: Re: One PG process eating more than 40GB of RAM and getting killed by OOM
In-Reply-To: <b9a4bf45-65ca-4598-beae-84e269331fbb@thefreecat.org>
* 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