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 |