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 | | 104bis rue Avisseau 37000 Tours France |