On Fri, Apr 14, 2017 at 2:42 PM, Chris Mair <ch...@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.
