Search PostgreSQL documentation

huge_page_sizeConfigurationReferencehuge_page_size Resource Usage 14 Controls the size of huge pages, when they are enabled with huge_pages. The default is zero (0). When set to 0, the default huge page size on the system will…Configuration · Resource Usage huge_pagesConfigurationReferencehuge_pages Resource Usage 10 Enables/disables the use of huge memory pages. Valid values are try (the default), on, and off. At present, this feature is supported only on Linux. The setting …Configuration · Resource Usage huge_pages_statusConfigurationReferencehuge_pages_status Preset Options 17 Reports the state of huge pages in the current instance: on, off, or unknown (if displayed with postgres -C). This parameter is useful to determine whethe…Configuration · Preset Options icu_validation_levelConfigurationReferenceicu_validation_level Client Connection Defaults 16 When ICU locale validation problems are encountered, controls which message level is used to report the problem. Valid values are DISABLED,…Configuration · Client Connection Defaults ident_fileConfigurationReferenceident_file File Locations 10 Specifies the configuration file for user name mapping (customarily called pg_ident.conf). This parameter can only be set at server start. See also Section 20.2.…Configuration · File Locations idle_in_transaction_session_timeoutConfigurationReferenceidle_in_transaction_session_timeout Client Connection Defaults 10 Terminate any session with an open transaction that has been idle for longer than the specified duration in milliseconds. Th…Configuration · Client Connection Defaults idle_replication_slot_timeoutConfigurationReferenceidle_replication_slot_timeout Replication 18 Invalidate replication slots that have remained inactive (not used by a replication connection) for longer than this duration. If this value is s…Configuration · Replication idle_session_timeoutConfigurationReferenceidle_session_timeout Client Connection Defaults 14 Terminate any session that has been idle (that is, waiting for a client query), but not within an open transaction, for longer than the spe…Configuration · Client Connection Defaults ignore_checksum_failureConfigurationReferenceignore_checksum_failure Developer Options 10 Only has effect if data checksums are enabled. Detection of a checksum failure during a read normally causes PostgreSQL to report an error, abort…Configuration · Developer Options ignore_invalid_pagesConfigurationReferenceignore_invalid_pages Developer Options 13 If set to off (the default), detection of WAL records having references to invalid pages during recovery causes PostgreSQL to raise a PANIC-level er…Configuration · Developer Options ignore_system_indexesConfigurationReferenceignore_system_indexes Developer Options 10 Ignore system indexes when reading system tables (but still update the indexes when modifying the tables). This is useful when recovering from dama…Configuration · Developer Options in_hot_standbyConfigurationReferencein_hot_standby Preset Options 14 Reports whether the server is currently in hot standby mode. When this is on, all transactions are forced to be read-only. Within a session, this can change …Configuration · Preset Options integer_datetimesConfigurationReferenceinteger_datetimes Preset Options 10 Reports whether PostgreSQL was built with support for 64-bit-integer dates and times. As of PostgreSQL 10, this is always on. 11 12 13 14 15 16 17 18 19 2…Configuration · Preset Options IntervalStyleConfigurationReferenceIntervalStyle Client Connection Defaults 10 Sets the display format for interval values. The value sql_standard will produce output matching SQL standard interval literals. The value postgre…Configuration · Client Connection Defaults io_combine_limitConfigurationReferenceio_combine_limit Resource Usage 17 Controls the largest I/O size in operations that combine I/O. If this value is specified without units, it is taken as blocks, that is BLCKSZ bytes, typica…Configuration · Resource Usage io_max_combine_limitConfigurationReferenceio_max_combine_limit Resource Usage 18 Controls the largest I/O size in operations that combine I/O, and silently limits the user-settable parameter io_combine_limit. This parameter can only…Configuration · Resource Usage io_max_concurrencyConfigurationReferenceio_max_concurrency Resource Usage 18 Controls the maximum number of I/O operations that one process can execute simultaneously. The default setting of -1 selects a number based on shared_buf…Configuration · Resource Usage io_max_workersConfigurationReferenceio_max_workers Resource Usage 19 Sets the maximum number of I/O worker processes. The default is 8. This parameter can only be set in the postgresql.conf file or on the server command line. …Configuration · Resource Usage io_methodConfigurationReferenceio_method Resource Usage 18 Selects the method for executing asynchronous I/O. Possible values are: worker (execute asynchronous I/O using worker processes) io_uring (execute asynchronous I/…Configuration · Resource Usage io_min_workersConfigurationReferenceio_min_workers Resource Usage 19 Sets the minimum number of I/O worker processes. The default is 2. This parameter can only be set in the postgresql.conf file or on the server command line. …Configuration · Resource Usage io_worker_idle_timeoutConfigurationReferenceio_worker_idle_timeout Resource Usage 19 Sets the time after which entirely idle I/O worker processes exit, reducing the size of pool to match demand. The default is 1 minute. This parameter…Configuration · Resource Usage io_worker_launch_intervalConfigurationReferenceio_worker_launch_interval Resource Usage 19 Sets the minimum time before another I/O worker can be launched. This avoids creating too many for an unsustained burst of activity. The default i…Configuration · Resource Usage io_workersConfigurationReferenceio_workers Resource Usage 18 Selects the number of I/O worker processes to use. The default is 3. This parameter can only be set in the postgresql.conf file or on the server command line. On…Configuration · Resource Usage jitConfigurationReferencejit Query Tuning 11 Determines whether JIT compilation may be used by PostgreSQL, if available (see Chapter 32). The default is off. 12 Determines whether JIT compilation may be used by Post…Configuration · Query Tuning jit_above_costConfigurationReferencejit_above_cost Query Tuning 11 Sets the query cost above which JIT compilation is activated, if enabled (see Chapter 32). Performing JIT costs planning time but can accelerate query executio…Configuration · Query Tuning jit_debugging_supportConfigurationReferencejit_debugging_support Developer Options 11 If LLVM has the required functionality, register generated functions with GDB. This makes debugging easier. The default setting is off. This parame…Configuration · Developer Options jit_dump_bitcodeConfigurationReferencejit_dump_bitcode Developer Options 11 Writes the generated LLVM IR out to the file system, inside data_directory. This is only useful for working on the internals of the JIT implementation. …Configuration · Developer Options jit_expressionsConfigurationReferencejit_expressions Developer Options 11 Determines whether expressions are JIT compiled, when JIT compilation is activated (see Section 32.2). The default is on. 12 Determines whether expressio…Configuration · Developer Options jit_inline_above_costConfigurationReferencejit_inline_above_cost Query Tuning 11 Sets the query cost above which JIT compilation attempts to inline functions and operators. Inlining adds planning time, but can improve execution speed…Configuration · Query Tuning jit_optimize_above_costConfigurationReferencejit_optimize_above_cost Query Tuning 11 Sets the query cost above which JIT compilation applies expensive optimizations. Such optimization adds planning time, but can improve execution speed…Configuration · Query Tuning jit_profiling_supportConfigurationReferencejit_profiling_support Developer Options 11 If LLVM has the required functionality, emit the data needed to allow perf to profile functions generated by JIT. This writes out files to $HOME/.d…Configuration · Developer Options jit_providerConfigurationReferencejit_provider Client Connection Defaults 11 This variable is the name of the JIT provider library to be used (see Section 32.4.2). The default is llvmjit. This parameter can only be set at se…Configuration · Client Connection Defaults jit_tuple_deformingConfigurationReferencejit_tuple_deforming Developer Options 11 Determines whether tuple deforming is JIT compiled, when JIT compilation is activated (see Section 32.2). The default is on. 12 Determines whether tu…Configuration · Developer Options join_collapse_limitConfigurationReferencejoin_collapse_limit Query Tuning 10 The planner will rewrite explicit JOIN constructs (except FULL JOINs) into lists of FROM items whenever a list of no more than this many items would resul…Configuration · Query Tuning krb_caseins_usersConfigurationReferencekrb_caseins_users Connections and Authentication 10 Sets whether GSSAPI user names should be treated case-insensitively. The default is off (case sensitive). This parameter can only be set i…Configuration · Connections and Authentication krb_server_keyfileConfigurationReferencekrb_server_keyfile Connections and Authentication 10 Sets the location of the Kerberos server key file. See Section 20.3.3 for details. This parameter can only be set in the postgresql.conf …Configuration · Connections and Authentication krb_srvnameConfigurationReferencekrb_srvname Connections and Authentication 9.0 Sets the Kerberos service name. See Section 19.3.5 for details. This parameter can only be set in the postgresql.conf file or on the server com…Configuration · Connections and Authentication lc_collateConfigurationReferencelc_collate Preset Options 10 Reports the locale in which sorting of textual data is done. See Section 23.1 for more information. This value is determined when a database is created. 11 12 13…Configuration · Preset Options lc_ctypeConfigurationReferencelc_ctype Preset Options 10 Reports the locale that determines character classifications. See Section 23.1 for more information. This value is determined when a database is created. Ordinaril…Configuration · Preset Options lc_messagesConfigurationReferencelc_messages Client Connection Defaults 10 Sets the language in which messages are displayed. Acceptable values are system-dependent; see Section 23.1 for more information. If this variable i…Configuration · Client Connection Defaults