Hi.
I have server that hras increase users and need to increase
max_connections from default value.
Current value = 100
New Value = 200
This send me a message about shared_memory need to lower the value
which default settings = 24MB.
My server has 128GB in size, for 200 connections what settings and
values u recommend for my server?
I'm reading tunning just would like to receive tips an suggestions.
Reading docs looks like if I lower shared_buffers will affect my
performance?, right now is 12MB, bigger values won't allow me to
increase max_connections.
Any comment will be appreciated, thanks.
Linux Ubuntu 12.
Postgresql 9.1.x
x64.
128GB RAM