Quick Links

postgresql 9.5 has ocuuered OOM

From:	mark <pgroad(at)163(dot)com>
To:	pgsql-general(at)postgresql(dot)org
Subject:	postgresql 9.5 has ocuuered OOM
Date:	2017-12-20 15:08:51
Message-ID:	2fd6f5eb.10a25.160747856ec.Coremail.pgroad@163.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	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?

Responses

Re: postgresql 9.5 has ocuuered OOM at 2017-12-20 16:24:35 from Tomas Vondra
Re: postgresql 9.5 has ocuuered OOM at 2017-12-20 16:25:00 from Andreas Kretschmer
Re: postgresql 9.5 has ocuuered OOM at 2017-12-20 16:44:36 from Uwe

Browse pgsql-general by date

	From	Date	Subject
Next Message	Tomas Vondra	2017-12-20 16:24:35	Re: postgresql 9.5 has ocuuered OOM
Previous Message	Chris Travers	2017-12-20 15:06:27	Re: Re: PostgreSQL needs percentage function