On 13/08/2014 17:23, Jeff Janes wrote:
On Wed, Aug 13, 2014 at 1:07 AM, pinker <pin...@onet.eu
<mailto:pin...@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
R+C
