basti wrote: >>> Since a few days we had problems with the Linux OOM-Killer. >>> Some simple query that normally take around 6-7 minutes now takes 5 hours. >>> We did not change any configuration values the last days. >>> >>> First of all I have set >>> >>> vm.overcommit_memory=2 >>> vm.overcommit_ratio=80 > Swap is disabled. > free -m > total used free shared buffers cached > Mem: 32215 16163 16051 0 40 14842 > -/+ buffers/cache: 1281 30934 > Swap: 0 0 0 That together means that you cannot use more than 80% of your RAM. Are you hitting that limit? See the description of overcommit_ratio in https://www.kernel.org/doc/Documentation/sysctl/vm.txt I would definitely add some swap. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
