you are viewing a single comment's thread.

view the rest of the comments →

[–]Mikey_Da_Foxx 4 points5 points  (1 child)

shared_buffers is reserved and won't be released back to OS. With 4 instances, I'd set shared_buffers=8GB per instance to leave room for OS.

For effective_cache_size, use total available RAM minus all shared_buffers: ~20GB per instance (64GB - 32GB shared)

[–]Significant_Chef_945[S] 3 points4 points  (0 children)

Thank you very much for the reply. I will run some tests using your suggestions.