https://tech.uvoo.io/index.php?action=history&feed=atom&title=Postgres_Azure_Server_parameters 2026-04-05T17:45:42Z Revision history for this page on the wiki MediaWiki 1.35.2 https://tech.uvoo.io/index.php?title=Postgres_Azure_Server_parameters&diff=4407&oldid=prev 2023-07-12T23:04:06Z

<p>Created page with &quot;``` array_nulls ON OFF Dynamic Enable input of NULL elements in arrays. autovacuum ON OFF Dynamic Starts the autovacuum subprocess. autovac...&quot;</p> <p><b>New page</b></p><div>```<br /> array_nulls<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Enable input of NULL elements in arrays.<br /> <br /> autovacuum<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Starts the autovacuum subprocess.<br /> <br /> autovacuum_analyze_scale_factor<br /> <br /> Dynamic<br /> <br /> Number of tuple inserts, updates, or deletes prior to analyze as a fraction of reltuples.<br /> <br /> autovacuum_analyze_threshold<br /> <br /> Dynamic<br /> <br /> Minimum number of tuple inserts, updates, or deletes prior to analyze.<br /> <br /> autovacuum_freeze_max_age<br /> <br /> Static<br /> <br /> Age at which to autovacuum a table to prevent transaction ID wraparound. Any change requires restarting the server to take effect.<br /> <br /> autovacuum_max_workers<br /> <br /> Static<br /> <br /> Sets the maximum number of simultaneously running autovacuum worker processes. Any change requires restarting the server to take effect.<br /> <br /> autovacuum_multixact_freeze_max_age<br /> <br /> Static<br /> <br /> Multixact age at which to autovacuum a table to prevent multixact wraparound. Any change requires restarting the server to take effect.<br /> <br /> autovacuum_naptime<br /> <br /> Dynamic<br /> <br /> Time to sleep between autovacuum runs. Unit is s.<br /> <br /> autovacuum_vacuum_cost_delay<br /> <br /> Dynamic<br /> <br /> Vacuum cost delay in milliseconds, for autovacuum.<br /> <br /> autovacuum_vacuum_cost_limit<br /> <br /> Dynamic<br /> <br /> Vacuum cost amount available before napping, for autovacuum.<br /> <br /> autovacuum_vacuum_scale_factor<br /> <br /> Dynamic<br /> <br /> Number of tuple updates or deletes prior to vacuum as a fraction of reltuples.<br /> <br /> autovacuum_vacuum_threshold<br /> <br /> Dynamic<br /> <br /> Minimum number of tuple updates or deletes prior to vacuum.<br /> <br /> autovacuum_work_mem<br /> <br /> Dynamic<br /> <br /> Sets the maximum memory to be used by each autovacuum worker process. Unit is kb.<br /> <br /> backend_flush_after<br /> <br /> Dynamic<br /> <br /> Number of pages after which previously performed writes are flushed to disk. Unit is 8kb.<br /> <br /> backslash_quote<br /> <br /> <br /> Dynamic<br /> <br /> Sets whether &quot;\'&quot; is allowed in string literals.<br /> <br /> bgwriter_delay<br /> <br /> Dynamic<br /> <br /> Background writer sleep time between rounds. Unit is ms.<br /> <br /> bgwriter_flush_after<br /> <br /> Dynamic<br /> <br /> Number of pages after which previously performed writes are flushed to disk. Unit is 8kb.<br /> <br /> bgwriter_lru_maxpages<br /> <br /> Dynamic<br /> <br /> Background writer maximum number of LRU pages to flush per round.<br /> <br /> bgwriter_lru_multiplier<br /> <br /> Dynamic<br /> <br /> Multiple of the average buffer usage to free per round.<br /> <br /> bytea_output<br /> <br /> <br /> Dynamic<br /> <br /> Sets the output format for bytea.<br /> <br /> check_function_bodies<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Check function bodies during CREATE FUNCTION.<br /> <br /> checkpoint_completion_target<br /> <br /> Dynamic<br /> <br /> Time spent flushing dirty buffers during checkpoint, as fraction of checkpoint interval.<br /> <br /> checkpoint_warning<br /> <br /> Dynamic<br /> <br /> Enables warnings if checkpoint segments are filled more frequently than this. Unit is s.<br /> <br /> client_encoding<br /> <br /> <br /> Dynamic<br /> <br /> Sets the client's character set encoding.<br /> <br /> client_min_messages<br /> <br /> <br /> Dynamic<br /> <br /> Sets the message levels that are sent to the client.<br /> <br /> commit_delay<br /> <br /> Dynamic<br /> <br /> Sets the delay in microseconds between transaction commit and flushing WAL to disk.<br /> <br /> commit_siblings<br /> <br /> Dynamic<br /> <br /> Sets the minimum concurrent open transactions before performing commit_delay.<br /> <br /> connection_throttling<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Enables temporary connection throttling per IP for too many invalid password login failures.<br /> <br /> constraint_exclusion<br /> <br /> <br /> Dynamic<br /> <br /> Enables the planner to use constraints to optimize queries.<br /> <br /> cpu_index_tuple_cost<br /> <br /> Dynamic<br /> <br /> Sets the planner's estimate of the cost of processing each index entry during an index scan.<br /> <br /> cpu_operator_cost<br /> <br /> Dynamic<br /> <br /> Sets the planner's estimate of the cost of processing each operator or function call.<br /> <br /> cpu_tuple_cost<br /> <br /> Dynamic<br /> <br /> Sets the planner's estimate of the cost of processing each tuple (row).<br /> <br /> cursor_tuple_fraction<br /> <br /> Dynamic<br /> <br /> Sets the planner's estimate of the fraction of a cursor's rows that will be retrieved.<br /> <br /> datestyle<br /> <br /> Dynamic<br /> <br /> Sets the display format for date and time values.<br /> <br /> deadlock_timeout<br /> <br /> Dynamic<br /> <br /> Sets the amount of time, in milliseconds, to wait on a lock before checking for deadlock.<br /> <br /> debug_print_parse<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Logs each query's parse tree.<br /> <br /> debug_print_plan<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Logs each query's execution plan.<br /> <br /> debug_print_rewritten<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Logs each query's rewritten parse tree.<br /> <br /> default_statistics_target<br /> <br /> Dynamic<br /> <br /> Sets the default statistics target.<br /> <br /> default_text_search_config<br /> <br /> Dynamic<br /> <br /> Sets default text search configuration.<br /> <br /> default_transaction_deferrable<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Sets the default deferrable status of new transactions.<br /> <br /> default_transaction_isolation<br /> <br /> <br /> Dynamic<br /> <br /> Sets the transaction isolation level of each new transaction.<br /> <br /> default_transaction_read_only<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Sets the default read-only status of new transactions.<br /> <br /> default_with_oids<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Create new tables with OIDs by default.<br /> <br /> effective_cache_size<br /> <br /> Dynamic<br /> <br /> Sets the planner's assumption about the size of the disk cache. Unit is 8kb.<br /> <br /> enable_bitmapscan<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Enables the planner's use of bitmap-scan plans.<br /> <br /> enable_hashagg<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Enables the planner's use of hashed aggregation plans.<br /> <br /> enable_hashjoin<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Enables the planner's use of hash join plans.<br /> <br /> enable_indexonlyscan<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Enables the planner's use of index-only-scan plans.<br /> <br /> enable_indexscan<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Enables the planner's use of index-scan plans.<br /> <br /> enable_material<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Enables the planner's use of materialization.<br /> <br /> enable_mergejoin<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Enables the planner's use of merge join plans.<br /> <br /> enable_nestloop<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Enables the planner's use of nested-loop join plans.<br /> <br /> enable_partitionwise_aggregate<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Enables or disables the query planner's use of partitionwise grouping or aggregation, which allows grouping or aggregation on a partitioned tables performed separately for each partition.<br /> <br /> enable_partitionwise_join<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Enables or disables the query planner's use of partitionwise join, which allows a join between partitioned tables to be performed by joining the matching partitions.<br /> <br /> enable_seqscan<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Enables the planner's use of sequential-scan plans.<br /> <br /> enable_sort<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Enables the planner's use of explicit sort steps.<br /> <br /> enable_tidscan<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Enables the planner's use of TID scan plans.<br /> <br /> escape_string_warning<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Warn about backslash escapes in ordinary string literals.<br /> <br /> exit_on_error<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Terminate session on any error.<br /> <br /> extra_float_digits<br /> <br /> Dynamic<br /> <br /> Sets the number of digits displayed for floating-point values.<br /> <br /> force_parallel_mode<br /> <br /> <br /> Dynamic<br /> <br /> Forces use of parallel query facilities.<br /> <br /> from_collapse_limit<br /> <br /> Dynamic<br /> <br /> Sets the FROM-list size beyond which subqueries are not collapsed.<br /> <br /> geqo<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Enables genetic query optimization.<br /> <br /> geqo_effort<br /> <br /> Dynamic<br /> <br /> GEQO: effort is used to set the default for other GEQO parameters.<br /> <br /> geqo_generations<br /> <br /> Dynamic<br /> <br /> GEQO: number of iterations of the algorithm.<br /> <br /> geqo_pool_size<br /> <br /> Dynamic<br /> <br /> GEQO: number of individuals in the population.<br /> <br /> geqo_seed<br /> <br /> Dynamic<br /> <br /> GEQO: seed for random path selection.<br /> <br /> geqo_selection_bias<br /> <br /> Dynamic<br /> <br /> GEQO: selective pressure within the population.<br /> <br /> geqo_threshold<br /> <br /> Dynamic<br /> <br /> Sets the threshold of FROM items beyond which GEQO is used.<br /> <br /> gin_fuzzy_search_limit<br /> <br /> Dynamic<br /> <br /> Sets the maximum allowed result for exact search by GIN.<br /> <br /> gin_pending_list_limit<br /> <br /> Dynamic<br /> <br /> Sets the maximum size of the pending list for GIN index. Unit is kb.<br /> <br /> hot_standby_feedback<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Allows feedback from a hot standby to the primary that will avoid query conflicts.<br /> <br /> idle_in_transaction_session_timeout<br /> <br /> Dynamic<br /> <br /> Sets the maximum allowed duration of any idling transaction. Unit is ms.<br /> <br /> intervalstyle<br /> <br /> <br /> Dynamic<br /> <br /> Sets the display format for interval values.<br /> <br /> join_collapse_limit<br /> <br /> Dynamic<br /> <br /> Sets the FROM-list size beyond which JOIN constructs are not flattened.<br /> <br /> lc_monetary<br /> <br /> Dynamic<br /> <br /> Sets the locale for formatting monetary amounts.<br /> <br /> lc_numeric<br /> <br /> Dynamic<br /> <br /> Sets the locale for formatting numbers.<br /> <br /> lo_compat_privileges<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Enables backward compatibility mode for privilege checks on large objects.<br /> <br /> lock_timeout<br /> <br /> Dynamic<br /> <br /> Sets the maximum allowed duration (in milliseconds) of any wait for a lock. 0 turns this off.<br /> <br /> log_autovacuum_min_duration<br /> <br /> Dynamic<br /> <br /> Sets the minimum execution time above which autovacuum actions will be logged. Unit is ms.<br /> <br /> log_checkpoints<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Logs each checkpoint.<br /> <br /> log_connections<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Logs each successful connection.<br /> <br /> log_disconnections<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Logs end of a session, including duration.<br /> <br /> log_duration<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Logs the duration of each completed SQL statement.<br /> <br /> log_error_verbosity<br /> <br /> <br /> Dynamic<br /> <br /> Sets the verbosity of logged messages.<br /> <br /> log_line_prefix<br /> <br /> Dynamic<br /> <br /> Sets the printf-style string that is output at the beginning of each log line.<br /> <br /> log_lock_waits<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Logs long lock waits.<br /> <br /> log_min_duration_statement<br /> <br /> Dynamic<br /> <br /> Sets the minimum execution time (in milliseconds) above which statements will be logged. -1 disables logging statement durations.<br /> <br /> log_min_error_statement<br /> <br /> <br /> Dynamic<br /> <br /> Causes all statements generating error at or above this level to be logged.<br /> <br /> log_min_messages<br /> <br /> <br /> Dynamic<br /> <br /> Sets the message levels that are logged.<br /> <br /> log_replication_commands<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Logs each replication command.<br /> <br /> log_retention_days<br /> <br /> Dynamic<br /> <br /> Sets how many days a log file is saved for.<br /> <br /> log_statement<br /> <br /> <br /> Dynamic<br /> <br /> Sets the type of statements logged.<br /> <br /> log_statement_stats<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> For each query, writes cumulative performance statistics to the server log.<br /> <br /> log_temp_files<br /> <br /> Dynamic<br /> <br /> Log the use of temporary files larger than this number of kilobytes.<br /> <br /> logging_collector<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Static<br /> <br /> Enable .log files. Setting is independent of Azure Monitor logging options. Any change requires restarting the server to take effect.<br /> <br /> maintenance_work_mem<br /> <br /> Dynamic<br /> <br /> Sets the maximum memory to be used for maintenance operations. Unit is kb.<br /> <br /> max_locks_per_transaction<br /> <br /> Static<br /> <br /> Sets the maximum number of locks per transaction. Any change requires restarting the server to take effect. When running a replica server, you must set this parameter to the same or higher value than on the master server.<br /> <br /> max_parallel_workers<br /> <br /> Dynamic<br /> <br /> Sets the maximum number of parallel workers than can be active at one time.<br /> <br /> max_parallel_workers_per_gather<br /> <br /> Dynamic<br /> <br /> Sets the maximum number of parallel processes per executor node.<br /> <br /> max_prepared_transactions<br /> <br /> Static<br /> <br /> Sets the maximum number of simultaneously prepared transactions. Any change requires restarting the server to take effect. When running a replica server, you must set this parameter to the same or higher value than on the master server.<br /> <br /> max_replication_slots<br /> <br /> Static<br /> <br /> IMPORTANT NOTE: Generally a single digit value is sufficient for this parameter for most scenarios. Only in scenarios like migration where there is a need to migrate 10's of databases at once should you set this to a higher value. Also change max_wal_senders accordingly. Description: Specifies the maximum number of replication slots that the server can support.<br /> <br /> max_standby_archive_delay<br /> <br /> Dynamic<br /> <br /> Sets the maximum delay before canceling queries when a hot standby server is processing archived WAL data. Unit is ms.<br /> <br /> max_standby_streaming_delay<br /> <br /> Dynamic<br /> <br /> Sets the maximum delay before canceling queries when a hot standby server is processing streamed WAL data. Unit is ms.<br /> <br /> max_wal_senders<br /> <br /> Static<br /> <br /> IMPORTANT NOTE: In PG 11 and lower, the value max_wal_senders MUST be much smaller relative to max_connections since it takes up the connection slots. See https://docs.microsoft.com/en-us/azure/postgresql/single-server/concepts-limits for max_connections info in single server. Typically a single digit value suffices for most scenarios. Only in scenarios like migration where there is a need to migrate 10's of databases at once should you set this to a higher value. Also change max_replication_slots accordingly. Description: The parameter specifies the maximum number of concurrent connections from standby servers or streaming base backup clients (i.e., the maximum number of simultaneously running WAL sender processes).<br /> <br /> max_wal_size<br /> <br /> Dynamic<br /> <br /> Sets the WAL size that triggers a checkpoint. Unit is mb.<br /> <br /> min_parallel_index_scan_size<br /> <br /> Dynamic<br /> <br /> Sets the minimum amount of index data for a parallel scan. Unit is 8kb.<br /> <br /> min_parallel_table_scan_size<br /> <br /> Dynamic<br /> <br /> Sets the minimum amount of table data for a parallel scan. Unit is 8kb.<br /> <br /> min_wal_size<br /> <br /> Dynamic<br /> <br /> Sets the minimum size to shrink the WAL to. Unt is mb.<br /> <br /> old_snapshot_threshold<br /> <br /> Static<br /> <br /> Time before a snapshot is too old to read pages changed after the snapshot was taken. Any change requires restarting the server to take effect. Unit is min.<br /> <br /> operator_precedence_warning<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Emit a warning for constructs that changed meaning since PostgreSQL 9.4.<br /> <br /> parallel_leader_participation<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Enables or disables the query planner's use of partitionwise grouping or aggregation, which allows grouping or aggregation on a partitioned tables performed separately for each partition.<br /> <br /> parallel_setup_cost<br /> <br /> Dynamic<br /> <br /> Sets the planner's estimate of the cost of starting up worker processes for parallel query.<br /> <br /> parallel_tuple_cost<br /> <br /> Dynamic<br /> <br /> Sets the planner's estimate of the cost of passing each tuple (row) from worker to master backend.<br /> <br /> pg_qs.interval_length_minutes<br /> <br /> Static<br /> <br /> Sets the query_store capture interval in minutes for pg_qs - this is the frequency of data persistence.<br /> <br /> pg_qs.max_query_text_length<br /> <br /> Dynamic<br /> <br /> Sets the maximum query text length that will be saved; longer queries will be truncated.<br /> <br /> pg_qs.query_capture_mode<br /> <br /> <br /> Dynamic<br /> <br /> Selects which statements are tracked by pg_qs.<br /> <br /> pg_qs.replace_parameter_placeholders<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Selects whether parameter placeholders are replaced in parameterized queries.<br /> <br /> pg_qs.retention_period_in_days<br /> <br /> Dynamic<br /> <br /> Sets the retention period window in days for pg_qs - after this time data will be deleted.<br /> <br /> pg_qs.track_utility<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Selects whether utility commands are tracked by pg_qs.<br /> <br /> pg_stat_statements.max<br /> <br /> Static<br /> <br /> Sets the maximum number of statements tracked by pg_stat_statements. Any change requires restarting the server to take effect.<br /> <br /> pg_stat_statements.save<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Save pg_stat_statements statistics across server shutdowns.<br /> <br /> pg_stat_statements.track<br /> <br /> <br /> Dynamic<br /> <br /> Controls which statements are counted by pg_stat_statements.<br /> <br /> pg_stat_statements.track_utility<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Selects whether utility commands are tracked by pg_stat_statements.<br /> <br /> pgms_wait_sampling.history_period<br /> <br /> Dynamic<br /> <br /> Set the frequency, in milliseconds, at which wait events are sampled.<br /> <br /> pgms_wait_sampling.query_capture_mode<br /> <br /> <br /> Dynamic<br /> <br /> Selects which statements are tracked by the pgms_wait_sampling extension.<br /> <br /> postgis.gdal_enabled_drivers<br /> <br /> <br /> Dynamic<br /> <br /> Controls postgis GDAL enabled driver settings.<br /> <br /> quote_all_identifiers<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> When generating SQL fragments, quote all identifiers.<br /> <br /> random_page_cost<br /> <br /> Dynamic<br /> <br /> Sets the planner's estimate of the cost of a nonsequentially fetched disk page.<br /> <br /> row_security<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Enable row security.<br /> <br /> search_path<br /> <br /> Dynamic<br /> <br /> Sets the schema search order for names that are not schema-qualified.<br /> <br /> seq_page_cost<br /> <br /> Dynamic<br /> <br /> Sets the planner's estimate of the cost of a sequentially fetched disk page.<br /> <br /> session_replication_role<br /> <br /> <br /> Dynamic<br /> <br /> Sets the session's behavior for triggers and rewrite rules.<br /> <br /> shared_preload_libraries<br /> <br /> <br /> Static<br /> <br /> Sets which shared libraries are preloaded at server start. Any change requires a restart to take effect.<br /> <br /> statement_timeout<br /> <br /> Dynamic<br /> <br /> Sets the maximum allowed duration (in milliseconds) of any statement. 0 turns this off.<br /> <br /> synchronize_seqscans<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Enable synchronized sequential scans.<br /> <br /> synchronous_commit<br /> <br /> <br /> Dynamic<br /> <br /> Sets the current transaction's synchronization level.<br /> <br /> tcp_keepalives_count<br /> <br /> Dynamic<br /> <br /> Maximum number of TCP keepalive retransmits.<br /> <br /> tcp_keepalives_idle<br /> <br /> Dynamic<br /> <br /> Time between issuing TCP keepalives. Unit is s.<br /> <br /> tcp_keepalives_interval<br /> <br /> Dynamic<br /> <br /> Time between TCP keepalive retransmits.Unit is s.<br /> <br /> temp_buffers<br /> <br /> Dynamic<br /> <br /> Sets the maximum number of temporary buffers used by each database session. Unit is 8kb.<br /> <br /> timezone<br /> <br /> Dynamic<br /> <br /> Sets the time zone for displaying and interpreting time stamps<br /> <br /> track_activities<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Collects information about executing commands.<br /> <br /> track_activity_query_size<br /> <br /> Static<br /> <br /> Sets the size reserved for pg_stat_activity.query, in bytes. Any change requires restarting the server to take effect.<br /> <br /> track_commit_timestamp<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Static<br /> <br /> Collects transaction commit time. Any change requires restarting the server to take effect.<br /> <br /> track_counts<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Collects statistics on database activity.<br /> <br /> track_functions<br /> <br /> <br /> Dynamic<br /> <br /> Collects function-level statistics on database activity.<br /> <br /> track_io_timing<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Collects timing statistics for database I/O activity.<br /> <br /> transform_null_equals<br /> <br /> <br /> ON<br /> OFF<br /> <br /> <br /> Dynamic<br /> <br /> Treats &quot;expr=NULL&quot; as &quot;expr IS NULL&quot;.<br /> <br /> vacuum_cost_delay<br /> <br /> Dynamic<br /> <br /> Vacuum cost delay in milliseconds.<br /> <br /> vacuum_cost_limit<br /> <br /> Dynamic<br /> <br /> Vacuum cost amount available before napping.<br /> <br /> vacuum_cost_page_dirty<br /> <br /> Dynamic<br /> <br /> Vacuum cost for a page dirtied by vacuum.<br /> <br /> vacuum_cost_page_hit<br /> <br /> Dynamic<br /> <br /> Vacuum cost for a page found in the buffer cache.<br /> <br /> vacuum_cost_page_miss<br /> <br /> Dynamic<br /> <br /> Vacuum cost for a page not found in the buffer cache.<br /> <br /> vacuum_defer_cleanup_age<br /> <br /> Dynamic<br /> <br /> Number of transactions by which VACUUM and HOT cleanup should be deferred, if any.<br /> <br /> vacuum_freeze_min_age<br /> <br /> Dynamic<br /> <br /> Minimum age at which VACUUM should freeze a table row.<br /> <br /> vacuum_freeze_table_age<br /> <br /> Dynamic<br /> <br /> Age at which VACUUM should scan whole table to freeze tuples.<br /> <br /> vacuum_multixact_freeze_min_age<br /> <br /> Dynamic<br /> <br /> Minimum age at which VACUUM should freeze a MultiXactId in a table row.<br /> <br /> vacuum_multixact_freeze_table_age<br /> <br /> Dynamic<br /> <br /> Multixact age at which VACUUM should scan whole table to freeze tuples.<br /> <br /> wal_buffers<br /> <br /> Static<br /> <br /> Sets the number of disk-page buffers in shared memory for WAL. Any change requires restarting the server to take effect. Unit is 8kb.<br /> <br /> wal_receiver_status_interval<br /> <br /> Dynamic<br /> <br /> Sets the maximum interval between WAL receiver status reports to the primary. Unit is s.<br /> ```</div>

Busk