Project

General

Profile

« Previous | Next » 

Revision 1721

Added by Aaron Marcuse-Kubitza almost 13 years ago

schemas/postgresql*.conf: Increased checkpoint_segments and checkpoint_completion_target so that checkpoints (performance intensive) are written less often and load-balanced better

View differences:

schemas/postgresql.nimoy.conf
179 179 

  		




  180
  180
  
    
# - Checkpoints -


  		




  181
  181
  
    

  		




  
  182
  
    
checkpoint_segments = 32		# in logfile segments, min 1, 16MB each


  		




  182
  183
  
    
#checkpoint_segments = 3		# in logfile segments, min 1, 16MB each


  		




  183
  184
  
    
#checkpoint_timeout = 5min		# range 30s-1h


  		




  
  185
  
    
checkpoint_completion_target = 0.9	# checkpoint target duration, 0.0 - 1.0


  		




  184
  186
  
    
#checkpoint_completion_target = 0.5	# checkpoint target duration, 0.0 - 1.0


  		




  185
  187
  
    
#checkpoint_warning = 30s		# 0 is off


  		




  186
  188
  
    

  		












  

    
      schemas/postgresql.conf
    
  





  177
  177
  
    

  		




  178
  178
  
    
# - Checkpoints -


  		




  179
  179
  
    

  		




  
  180
  
    
checkpoint_segments = 32		# in logfile segments, min 1, 16MB each


  		




  180
  181
  
    
#checkpoint_segments = 3		# in logfile segments, min 1, 16MB each


  		




  181
  182
  
    
#checkpoint_timeout = 5min		# range 30s-1h


  		




  
  183
  
    
checkpoint_completion_target = 0.9	# checkpoint target duration, 0.0 - 1.0


  		




  182
  184
  
    
#checkpoint_completion_target = 0.5	# checkpoint target duration, 0.0 - 1.0


  		




  183
  185
  
    
#checkpoint_warning = 30s		# 0 disables


  		




  184
  186
  
    

  		












Also available in:  Unified diff