Re: One PG process eating more than 40GB of RAM and getting killed by OOM

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