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
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.
you should increase shared_memory to 40GB. General philosphy is to allocate 80% of system memory to shared_memory
-- Melvin DavidsonI reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных