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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
