Home > mailing lists

postgresql 9.5 has ocuuered OOM - Mailing list pgsql-general

From	mark
Subject	postgresql 9.5 has ocuuered OOM
Date	December 20, 2017 21:08:51
Msg-id	2fd6f5eb.10a25.160747856ec.Coremail.pgroad@163.com Whole thread Raw
Responses	Re: postgresql 9.5 has ocuuered OOM Re: postgresql 9.5 has ocuuered OOM Re: postgresql 9.5 has ocuuered OOM
List	pgsql-general

I have set shared_buffers is 1/4 of memory.

work_mem is 2% of memory.

max_connections is 50.

momery size is 16GB.

postgresql process used over 70% of memory and occuered OOM.

what should I do to deal with this problem?

From: Chris Travers
Date: 20 December 2017, 21:06:27
Subject: Re: Re: PostgreSQL needs percentage function

From: Tomas Vondra
Date: 20 December 2017, 22:24:35
Subject: Re: postgresql 9.5 has ocuuered OOM