Re: PostgreSQL Out of Memory
От
Mladen Gogala
Тема
Re: PostgreSQL Out of Memory
Дата
Msg-id
eab6a451-f181-c179-b423-6e63753aeddb@gmail.com
Ответ на
PostgreSQL Out of Memory (liam saffioti)
Список
Дерево обсуждения
PostgreSQL Out of Memory liam saffioti <liam.saffiotti@gmail.com>
Re: PostgreSQL Out of Memory Jeff Janes <jeff.janes@gmail.com>
Re: PostgreSQL Out of Memory Mladen Gogala <gogala.mladen@gmail.com>
On 9/5/22 07:54, liam saffioti wrote:
Hi Teams,FATAL: terminating background worker "parallel worker" due to administrator commandFATAL: terminating background worker "parallel worker" due to administrator commandFATAL: terminating background worker "parallel worker" due to administrator commandFATAL: out of memoryFATAL: out of memory...
You are allowing over-committing memory, which in turn activates OOMK (Out of Memory Killer) when the memory runs out. You have to restrict the number of connections or parameters like work_mem and hash_mem_multiplier. There is also a good article on Squishy Data:
https://www.crunchydata.com/blog/deep-postgresql-thoughts-the-linux-assassin
Basically, you should start with vm.overcommit_memory = 2
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com
В списке pgsql-admin по дате отправления
