Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem
On Fri, Apr 14, 2017 at 2:42 PM, Chris Mair <chris@1006.org> wrote:
you should increase shared_memory to 40GB. General philosphy is to allocate 80% of system memory to shared_memory
Uhm...
80% is too much, likely:
https://www.postgresql.org/docs/9.5/static/runtime-config- resource.html
Bye,
Chris.
Sorry, I had a brain fart, shared_buffers should be 25% system memory, or 12GB
--
Melvin Davidson
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
В списке pgsql-general по дате отправления: