Re: Database block lifecycle

Robin <robinstc@xxxxxxxxxx> · Wed, 13 Aug 2014 19:19:41 +0100



      On 13/08/2014 17:23, Jeff Janes wrote:

    
          On Wed, Aug 13, 2014 at 1:07 AM,
            pinker <pinker@xxxxxxx>
            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