Developer Options

allow_in_place_tablespaces

Attribute Value
Category Developer Options
Description Allows tablespaces directly inside pg_tblspc, for testing.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation allow_in_place_tablespaces

allow_system_table_mods

Attribute Value
Category Developer Options
Description Allows modifications of the structure of system tables.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation allow_system_table_mods

backtrace_functions

Attribute Value
Category Developer Options
Description Log backtrace for errors in these functions.
Data type string
Default value
Allowed values
Parameter type read-only
Documentation backtrace_functions

debug_discard_caches

Attribute Value
Category Developer Options
Description Aggressively flush system caches for debugging purposes.
Data type integer
Default value 0
Allowed values 0
Parameter type read-only
Documentation debug_discard_caches

debug_parallel_query

Attribute Value
Category Developer Options
Description Forces use of parallel query facilities.
Data type enumeration
Default value off
Allowed values off,on,regress
Parameter type dynamic
Documentation debug_parallel_query

ignore_checksum_failure

Attribute Value
Category Developer Options
Description Continues processing after a checksum failure.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation ignore_checksum_failure

ignore_invalid_pages

Attribute Value
Category Developer Options
Description Continues recovery after an invalid pages failure.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation ignore_invalid_pages

ignore_system_indexes

Attribute Value
Category Developer Options
Description Disables reading from system indexes.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation ignore_system_indexes

jit_debugging_support

Attribute Value
Category Developer Options
Description Register JIT-compiled functions with debugger.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation jit_debugging_support

jit_dump_bitcode

Attribute Value
Category Developer Options
Description Write out LLVM bitcode to facilitate JIT debugging.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation jit_dump_bitcode

jit_expressions

Attribute Value
Category Developer Options
Description Allow JIT compilation of expressions.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation jit_expressions

jit_profiling_support

Attribute Value
Category Developer Options
Description Register JIT-compiled functions with perf profiler.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation jit_profiling_support

jit_tuple_deforming

Attribute Value
Category Developer Options
Description Allow JIT compilation of tuple deforming.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation jit_tuple_deforming

post_auth_delay

Attribute Value
Category Developer Options
Description Sets the amount of time to wait after authentication on connection startup.
Data type integer
Default value 0
Allowed values 0
Parameter type read-only
Documentation post_auth_delay

pre_auth_delay

Attribute Value
Category Developer Options
Description Sets the amount of time to wait before authentication on connection startup.
Data type integer
Default value 0
Allowed values 0
Parameter type read-only
Documentation pre_auth_delay

remove_temp_files_after_crash

Attribute Value
Category Developer Options
Description Remove temporary files after backend crash.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation remove_temp_files_after_crash

trace_notify

Attribute Value
Category Developer Options
Description Generates debugging output for LISTEN and NOTIFY.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation trace_notify

trace_recovery_messages

Attribute Value
Category Developer Options
Description Enables logging of recovery-related debugging information.
Data type enumeration
Default value log
Allowed values log
Parameter type read-only
Documentation trace_recovery_messages

trace_sort

Attribute Value
Category Developer Options
Description Emit information about resource usage in sorting.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation trace_sort

wal_consistency_checking

Attribute Value
Category Developer Options
Description Sets the WAL resource managers for which WAL consistency checks are done.
Data type string
Default value
Allowed values
Parameter type read-only
Documentation wal_consistency_checking

zero_damaged_pages

Attribute Value
Category Developer Options
Description Continues processing past damaged page headers.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation zero_damaged_pages

allow_in_place_tablespaces

Attribute Value
Category Developer Options
Description Allows tablespaces directly inside pg_tblspc, for testing.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation allow_in_place_tablespaces

allow_system_table_mods

Attribute Value
Category Developer Options
Description Allows modifications of the structure of system tables.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation allow_system_table_mods

backtrace_functions

Attribute Value
Category Developer Options
Description Log backtrace for errors in these functions.
Data type string
Default value
Allowed values
Parameter type read-only
Documentation backtrace_functions

debug_discard_caches

Attribute Value
Category Developer Options
Description Aggressively flush system caches for debugging purposes.
Data type integer
Default value 0
Allowed values 0
Parameter type read-only
Documentation debug_discard_caches

force_parallel_mode

Attribute Value
Category Developer Options
Description Forces use of parallel query facilities.
Data type enumeration
Default value off
Allowed values off,on,regress
Parameter type dynamic
Documentation force_parallel_mode

ignore_checksum_failure

Attribute Value
Category Developer Options
Description Continues processing after a checksum failure.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation ignore_checksum_failure

ignore_invalid_pages

Attribute Value
Category Developer Options
Description Continues recovery after an invalid pages failure.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation ignore_invalid_pages

ignore_system_indexes

Attribute Value
Category Developer Options
Description Disables reading from system indexes.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation ignore_system_indexes

jit_debugging_support

Attribute Value
Category Developer Options
Description Register JIT-compiled functions with debugger.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation jit_debugging_support

jit_dump_bitcode

Attribute Value
Category Developer Options
Description Write out LLVM bitcode to facilitate JIT debugging.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation jit_dump_bitcode

jit_expressions

Attribute Value
Category Developer Options
Description Allow JIT compilation of expressions.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation jit_expressions

jit_profiling_support

Attribute Value
Category Developer Options
Description Register JIT-compiled functions with perf profiler.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation jit_profiling_support

jit_tuple_deforming

Attribute Value
Category Developer Options
Description Allow JIT compilation of tuple deforming.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation jit_tuple_deforming

post_auth_delay

Attribute Value
Category Developer Options
Description Sets the amount of time to wait after authentication on connection startup.
Data type integer
Default value 0
Allowed values 0
Parameter type read-only
Documentation post_auth_delay

pre_auth_delay

Attribute Value
Category Developer Options
Description Sets the amount of time to wait before authentication on connection startup.
Data type integer
Default value 0
Allowed values 0
Parameter type read-only
Documentation pre_auth_delay

trace_notify

Attribute Value
Category Developer Options
Description Generates debugging output for LISTEN and NOTIFY.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation trace_notify

trace_recovery_messages

Attribute Value
Category Developer Options
Description Enables logging of recovery-related debugging information.
Data type enumeration
Default value log
Allowed values log
Parameter type read-only
Documentation trace_recovery_messages

trace_sort

Attribute Value
Category Developer Options
Description Emit information about resource usage in sorting.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation trace_sort

wal_consistency_checking

Attribute Value
Category Developer Options
Description Sets the WAL resource managers for which WAL consistency checks are done.
Data type string
Default value
Allowed values
Parameter type read-only
Documentation wal_consistency_checking

zero_damaged_pages

Attribute Value
Category Developer Options
Description Continues processing past damaged page headers.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation zero_damaged_pages

allow_in_place_tablespaces

Attribute Value
Category Developer Options
Description Allows tablespaces directly inside pg_tblspc, for testing.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation allow_in_place_tablespaces

allow_system_table_mods

Attribute Value
Category Developer Options
Description Allows modifications of the structure of system tables.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation allow_system_table_mods

backtrace_functions

Attribute Value
Category Developer Options
Description Log backtrace for errors in these functions.
Data type string
Default value
Allowed values
Parameter type read-only
Documentation backtrace_functions

debug_discard_caches

Attribute Value
Category Developer Options
Description Aggressively flush system caches for debugging purposes.
Data type integer
Default value 0
Allowed values 0
Parameter type read-only
Documentation debug_discard_caches

force_parallel_mode

Attribute Value
Category Developer Options
Description Forces use of parallel query facilities.
Data type enumeration
Default value off
Allowed values off,on,regress
Parameter type dynamic
Documentation force_parallel_mode

ignore_checksum_failure

Attribute Value
Category Developer Options
Description Continues processing after a checksum failure.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation ignore_checksum_failure

ignore_invalid_pages

Attribute Value
Category Developer Options
Description Continues recovery after an invalid pages failure.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation ignore_invalid_pages

ignore_system_indexes

Attribute Value
Category Developer Options
Description Disables reading from system indexes.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation ignore_system_indexes

jit_debugging_support

Attribute Value
Category Developer Options
Description Register JIT-compiled functions with debugger.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation jit_debugging_support

jit_dump_bitcode

Attribute Value
Category Developer Options
Description Write out LLVM bitcode to facilitate JIT debugging.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation jit_dump_bitcode

jit_expressions

Attribute Value
Category Developer Options
Description Allow JIT compilation of expressions.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation jit_expressions

jit_profiling_support

Attribute Value
Category Developer Options
Description Register JIT-compiled functions with perf profiler.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation jit_profiling_support

jit_tuple_deforming

Attribute Value
Category Developer Options
Description Allow JIT compilation of tuple deforming.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation jit_tuple_deforming

post_auth_delay

Attribute Value
Category Developer Options
Description Waits N seconds on connection startup after authentication.
Data type integer
Default value 0
Allowed values 0
Parameter type read-only
Documentation post_auth_delay

pre_auth_delay

Attribute Value
Category Developer Options
Description Waits N seconds on connection startup before authentication.
Data type integer
Default value 0
Allowed values 0
Parameter type read-only
Documentation pre_auth_delay

remove_temp_files_after_crash

Attribute Value
Category Developer Options
Description Remove temporary files after backend crash.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation

trace_notify

Attribute Value
Category Developer Options
Description Generates debugging output for LISTEN and NOTIFY.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation trace_notify

trace_recovery_messages

Attribute Value
Category Developer Options
Description Enables logging of recovery-related debugging information.
Data type enumeration
Default value log
Allowed values log
Parameter type read-only
Documentation trace_recovery_messages

trace_sort

Attribute Value
Category Developer Options
Description Emit information about resource usage in sorting.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation trace_sort

wal_consistency_checking

Attribute Value
Category Developer Options
Description Sets the WAL resource managers for which WAL consistency checks are done.
Data type string
Default value
Allowed values
Parameter type read-only
Documentation wal_consistency_checking

zero_damaged_pages

Attribute Value
Category Developer Options
Description Continues processing past damaged page headers.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation zero_damaged_pages

allow_in_place_tablespaces

Attribute Value
Category Developer Options
Description Allows tablespaces directly inside pg_tblspc, for testing.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation allow_in_place_tablespaces

allow_system_table_mods

Attribute Value
Category Developer Options
Description Allows modifications of the structure of system tables.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation allow_system_table_mods

backtrace_functions

Attribute Value
Category Developer Options
Description Log backtrace for errors in these functions.
Data type string
Default value
Allowed values
Parameter type read-only
Documentation backtrace_functions

force_parallel_mode

Attribute Value
Category Developer Options
Description Forces use of parallel query facilities.
Data type enumeration
Default value off
Allowed values off,on,regress
Parameter type dynamic
Documentation force_parallel_mode

ignore_checksum_failure

Attribute Value
Category Developer Options
Description Continues processing after a checksum failure.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation ignore_checksum_failure

ignore_invalid_pages

Attribute Value
Category Developer Options
Description Continues recovery after an invalid pages failure.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation ignore_invalid_pages

ignore_system_indexes

Attribute Value
Category Developer Options
Description Disables reading from system indexes.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation ignore_system_indexes

jit_debugging_support

Attribute Value
Category Developer Options
Description Register JIT compiled function with debugger.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation jit_debugging_support

jit_dump_bitcode

Attribute Value
Category Developer Options
Description Write out LLVM bitcode to facilitate JIT debugging.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation jit_dump_bitcode

jit_expressions

Attribute Value
Category Developer Options
Description Allow JIT compilation of expressions.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation jit_expressions

jit_profiling_support

Attribute Value
Category Developer Options
Description Register JIT compiled function with perf profiler.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation jit_profiling_support

jit_tuple_deforming

Attribute Value
Category Developer Options
Description Allow JIT compilation of tuple deforming.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation jit_tuple_deforming

post_auth_delay

Attribute Value
Category Developer Options
Description Waits N seconds on connection startup after authentication.
Data type integer
Default value 0
Allowed values 0
Parameter type read-only
Documentation post_auth_delay

pre_auth_delay

Attribute Value
Category Developer Options
Description Waits N seconds on connection startup before authentication.
Data type integer
Default value 0
Allowed values 0
Parameter type read-only
Documentation pre_auth_delay

trace_notify

Attribute Value
Category Developer Options
Description Generates debugging output for LISTEN and NOTIFY.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation trace_notify

trace_recovery_messages

Attribute Value
Category Developer Options
Description Enables logging of recovery-related debugging information.
Data type enumeration
Default value log
Allowed values log
Parameter type read-only
Documentation trace_recovery_messages

trace_sort

Attribute Value
Category Developer Options
Description Emit information about resource usage in sorting.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation trace_sort

wal_consistency_checking

Attribute Value
Category Developer Options
Description Sets the WAL resource managers for which WAL consistency checks are done.
Data type string
Default value
Allowed values
Parameter type read-only
Documentation wal_consistency_checking

zero_damaged_pages

Attribute Value
Category Developer Options
Description Continues processing past damaged page headers.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation zero_damaged_pages

allow_in_place_tablespaces

Attribute Value
Category Developer Options
Description Allows tablespaces directly inside pg_tblspc, for testing.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation allow_in_place_tablespaces

allow_system_table_mods

Attribute Value
Category Developer Options
Description Allows modifications of the structure of system tables.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation allow_system_table_mods

force_parallel_mode

Attribute Value
Category Developer Options
Description Forces use of parallel query facilities.
Data type enumeration
Default value off
Allowed values off,on,regress
Parameter type dynamic
Documentation force_parallel_mode

ignore_checksum_failure

Attribute Value
Category Developer Options
Description Continues processing after a checksum failure.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation ignore_checksum_failure

ignore_system_indexes

Attribute Value
Category Developer Options
Description Disables reading from system indexes.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation ignore_system_indexes

jit_debugging_support

Attribute Value
Category Developer Options
Description Register JIT compiled function with debugger.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation jit_debugging_support

jit_dump_bitcode

Attribute Value
Category Developer Options
Description Write out LLVM bitcode to facilitate JIT debugging.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation jit_dump_bitcode

jit_expressions

Attribute Value
Category Developer Options
Description Allow JIT compilation of expressions.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation jit_expressions

jit_profiling_support

Attribute Value
Category Developer Options
Description Register JIT compiled function with perf profiler.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation jit_profiling_support

jit_tuple_deforming

Attribute Value
Category Developer Options
Description Allow JIT compilation of tuple deforming.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation jit_tuple_deforming

post_auth_delay

Attribute Value
Category Developer Options
Description Waits N seconds on connection startup after authentication.
Data type integer
Default value 0
Allowed values 0
Parameter type read-only
Documentation post_auth_delay

pre_auth_delay

Attribute Value
Category Developer Options
Description Waits N seconds on connection startup before authentication.
Data type integer
Default value 0
Allowed values 0
Parameter type read-only
Documentation pre_auth_delay

trace_notify

Attribute Value
Category Developer Options
Description Generates debugging output for LISTEN and NOTIFY.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation trace_notify

trace_recovery_messages

Attribute Value
Category Developer Options
Description Enables logging of recovery-related debugging information.
Data type enumeration
Default value log
Allowed values log
Parameter type read-only
Documentation trace_recovery_messages

trace_sort

Attribute Value
Category Developer Options
Description Emit information about resource usage in sorting.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation trace_sort

wal_consistency_checking

Attribute Value
Category Developer Options
Description Sets the WAL resource managers for which WAL consistency checks are done.
Data type string
Default value
Allowed values
Parameter type read-only
Documentation wal_consistency_checking

zero_damaged_pages

Attribute Value
Category Developer Options
Description Continues processing past damaged page headers.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation zero_damaged_pages

allow_in_place_tablespaces

Attribute Value
Category Developer Options
Description Allows tablespaces directly inside pg_tblspc, for testing.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation allow_in_place_tablespaces

allow_system_table_mods

Attribute Value
Category Developer Options
Description Allows modifications of the structure of system tables.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation allow_system_table_mods

force_parallel_mode

Attribute Value
Category Developer Options
Description Forces use of parallel query facilities.
Data type enumeration
Default value off
Allowed values off,on,regress
Parameter type dynamic
Documentation force_parallel_mode

ignore_checksum_failure

Attribute Value
Category Developer Options
Description Continues processing after a checksum failure.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation ignore_checksum_failure

ignore_system_indexes

Attribute Value
Category Developer Options
Description Disables reading from system indexes.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation ignore_system_indexes

jit_debugging_support

Attribute Value
Category Developer Options
Description Register JIT compiled function with debugger.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation jit_debugging_support

jit_dump_bitcode

Attribute Value
Category Developer Options
Description Write out LLVM bitcode to facilitate JIT debugging.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation jit_dump_bitcode

jit_expressions

Attribute Value
Category Developer Options
Description Allow JIT compilation of expressions.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation jit_expressions

jit_profiling_support

Attribute Value
Category Developer Options
Description Register JIT compiled function with perf profiler.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation jit_profiling_support

jit_tuple_deforming

Attribute Value
Category Developer Options
Description Allow JIT compilation of tuple deforming.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation jit_tuple_deforming

post_auth_delay

Attribute Value
Category Developer Options
Description Waits N seconds on connection startup after authentication.
Data type integer
Default value 0
Allowed values 0
Parameter type read-only
Documentation post_auth_delay

pre_auth_delay

Attribute Value
Category Developer Options
Description Waits N seconds on connection startup before authentication.
Data type integer
Default value 0
Allowed values 0
Parameter type read-only
Documentation pre_auth_delay

trace_notify

Attribute Value
Category Developer Options
Description Generates debugging output for LISTEN and NOTIFY.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation trace_notify

trace_recovery_messages

Attribute Value
Category Developer Options
Description Enables logging of recovery-related debugging information.
Data type enumeration
Default value log
Allowed values log
Parameter type read-only
Documentation trace_recovery_messages

trace_sort

Attribute Value
Category Developer Options
Description Emit information about resource usage in sorting.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation trace_sort

wal_consistency_checking

Attribute Value
Category Developer Options
Description Sets the WAL resource managers for which WAL consistency checks are done.
Data type string
Default value
Allowed values
Parameter type read-only
Documentation wal_consistency_checking

zero_damaged_pages

Attribute Value
Category Developer Options
Description Continues processing past damaged page headers.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation zero_damaged_pages