Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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_io_direct
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Use direct I/O for file access. |
| Data type | string |
| Default value | |
| Allowed values | |
| Parameter type | read-only |
| Documentation | debug_io_direct |
debug_logical_replication_streaming
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Forces immediate streaming or serialization of changes in large transactions. On the publisher, it allows streaming or serializing each change in logical decoding. On the subscriber, it allows serialization of all changes to files and notifies the parallel apply workers to read and apply them at the end of the transaction. |
| Data type | set |
| Default value | buffered |
| Allowed values | buffered |
| Parameter type | read-only |
| Documentation | debug_logical_replication_streaming |
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 |
send_abort_for_crash
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Send SIGABRT not SIGQUIT to child processes after backend crash. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | send_abort_for_crash |
send_abort_for_kill
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Send SIGABRT not SIGKILL to stuck child processes. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | send_abort_for_kill |
trace_connection_negotiation
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Logs details of pre-authentication connection handshake. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | trace_connection_negotiation |
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_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 |
debug_io_direct
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Use direct I/O for file access. |
| Data type | string |
| Default value | |
| Allowed values | |
| Parameter type | read-only |
| Documentation | debug_io_direct |
debug_logical_replication_streaming
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Forces immediate streaming or serialization of changes in large transactions. On the publisher, it allows streaming or serializing each change in logical decoding. On the subscriber, it allows serialization of all changes to files and notifies the parallel apply workers to read and apply them at the end of the transaction. |
| Data type | set |
| Default value | buffered |
| Allowed values | buffered |
| Parameter type | read-only |
| Documentation | debug_logical_replication_streaming |
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 |
send_abort_for_crash
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Send SIGABRT not SIGQUIT to child processes after backend crash. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | send_abort_for_crash |
send_abort_for_kill
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Send SIGABRT not SIGKILL to stuck child processes. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | send_abort_for_kill |
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 |