{

{"deadlock_timeout",PGC_SIGHUP,LOCK_MANAGEMENT,

gettext_noop("Sets the time to wait on a lock before checking for deadlock."),

gettext_noop("Sets the time to wait on a lock before checking for deadlock, in milliseconds."),

NULL,

},

{

{"maintenance_work_mem",PGC_USERSET,RESOURCES_MEM,

gettext_noop("Sets the maximum memory to be used for maintenance operations."),

gettext_noop("Sets the maximum memory to be used for maintenance operations, in kilobytes."),

gettext_noop("This includes operations such as VACUUM and CREATE INDEX."),

},

{

{"authentication_timeout",PGC_SIGHUP,CONN_AUTH_SECURITY,

gettext_noop("Sets the maximum allowed time to complete client authentication."),

gettext_noop("Sets the maximum allowed time to complete client authentication, in seconds."),

NULL,

},

{

{"checkpoint_timeout",PGC_SIGHUP,WAL_CHECKPOINTS,

gettext_noop("Sets the maximum time between automatic WAL checkpoints."),

gettext_noop("Sets the maximum time between automatic WAL checkpoints, in seconds."),

NULL,

},

{

{"wal_writer_delay",PGC_SIGHUP,WAL_SETTINGS,

gettext_noop("WAL writer sleep time between WAL flushes."),

gettext_noop("WAL writer sleep time between WAL flushes, in milliseconds."),

NULL,

},

{

{"log_min_duration_statement",PGC_SUSET,LOGGING_WHEN,

gettext_noop("Sets the minimum execution timeabove which "

"statements will be logged."),

gettext_noop("Sets the minimum execution time(in milliseconds) above "

"whichstatements will be logged."),

gettext_noop("Zero prints all queries. -1 turns this feature off."),

},

{

{"log_autovacuum_min_duration",PGC_SIGHUP,LOGGING_WHAT,

gettext_noop("Sets the minimum execution milliseconds above which "

gettext_noop("Sets the minimum executioninmilliseconds above which "

"autovacuum actions will be logged."),

gettext_noop("Zero prints all actions. -1 turns autovacuum logging off."),

{

{"bgwriter_delay",PGC_SIGHUP,RESOURCES,

gettext_noop("Background writer sleep time between rounds."),

gettext_noop("Background writer sleep time between rounds, in milliseconds."),

NULL,

},

{

{"autovacuum_naptime",PGC_SIGHUP,AUTOVACUUM,

gettext_noop("Time to sleep between autovacuum runs."),

gettext_noop("Time to sleep between autovacuum runs, in seconds."),

NULL,

},

# - Asynchronous Behavior -

#effective_io_concurrency = 1# 1-1000, or 0 to disable prefetching

#effective_io_concurrency = 1# 1-1000. 0 disables prefetching

#------------------------------------------------------------------------------

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

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

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

#checkpoint_warning = 30s# 0is off

#checkpoint_warning = 30s# 0disables

# - Archiving -

#archive_mode = off# allows archiving to be done

# (change requires restart)

#archive_command = ''# command to use to archive a logfile segment

#archive_timeout = 0# force a logfile segment switch after this

# number of seconds; 0is off

# number of seconds; 0disables

#------------------------------------------------------------------------------

# off, meaning append to existing files

# in all cases.

#log_rotation_age = 1d# Automatic rotation of logfiles will

# happen after that time. 0to disable.

# happen after that time. 0disables.

#log_rotation_size = 10MB# Automatic rotation of logfiles will

# happen after that much log output.

# 0to disable.

# 0disables.

# These are relevant when logging to syslog:

#syslog_facility = 'LOCAL0'