This is my postgresql.conf at the moment:
shared_buffer(51605MB) +
effective_cache_size(96760MB) +
work_mem(32MB) +
max_connections(200)
= 148397.08 MB
My server has 128GB of RAM
So, I'm using more RAM that I have. (not good at all)
I'm glad that it wasn't me who put those confs in there :)
Anyway...
I was thinking about decrease the shared_buffer to something like 1/8 of total RAM = 16GB
What do u guys think about it?
Cheers
Lucas
