All pastes #333073 Raw Edit

Someone

public text v1 · immutable
#333073 ·published 2007-01-30 17:34 UTC
rendered paste body
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