shared_buffers = 32768 # min 16 or max_connections*2, 8KB each work_mem = 16348 # min 64, size in KB maintenance_work_mem = 32768 # min 1024, size in KB vacuum_cost_delay = 50 # 0-1000 milliseconds fsync = off # turns forced synchronization on or off wal_buffers = 64 # min 4, 8KB each checkpoint_segments = 15 # in logfile segments, min 1, 16MB each checkpoint_timeout = 600 # range 30-3600, in seconds effective_cache_size = 2000 # typically 8KB each redirect_stderr = on # Enable capturing of stderr into log log_directory = 'pg_log' # Directory where log files are written log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' # Log file name pattern. log_truncate_on_rotation = on # If on, any existing log file of the same log_rotation_age = 1440 # Automatic rotation of logfiles will log_rotation_size = 0 # Automatic rotation of logfiles will log_min_duration_statement = 100 # -1 is disabled, 0 logs all statements log_duration = on log_line_prefix = '%t %i' # Special values: log_statement = 'none' # none, mod, ddl, all autovacuum = on # enable autovacuum subprocess? autovacuum_naptime = 120 # time between autovacuum runs, in secs