On Wed, Aug 13, 2014 at 1:07 AM, pinker <pinker@onet.eu> wrote:
>> >> btw. 512MB if we assume up to 600 connection is a reasonable value? >> > >>Reasonable value for what? >
> For normal server load.
512MB is being questioned as a reasonable value for what? shared_buffers? work_mem? maintenance_work_mem?
Cheers,
Jeff
Generally speaking, folk imagine that DBMS performance is all about disk access - in reality chucking as much memory as possible at the server(s) is an optimal investment. analyse your queries and store time critical stuff in memory