PG Settings

Properties

• track_activity_query_size (integer): Specifies the number of bytes reserved to track the currently executing command for each active session. Changing this parameter causes a service restart.
• timezone (string): PostgreSQL service timezone
• track_io_timing (string): Enables timing of database I/O calls. The default is off. When on, it will repeatedly query the operating system for the current time, which may cause significant overhead on some platforms.
• pg_stat_monitor.pgsm_enable_query_plan (boolean): Enables or disables query plan monitoring. Changing this parameter causes a service restart. Only available for PostgreSQL 13+.
• max_files_per_process (integer): PostgreSQL maximum number of files that can be open per process. The default is 1000 (upstream default). Changing this parameter causes a service restart.
• pg_stat_monitor.pgsm_max_buckets (integer): Sets the maximum number of buckets. Changing this parameter causes a service restart. Only available for PostgreSQL 13+.
• io_max_concurrency (integer): EXPERIMENTAL: Controls the maximum number of I/O operations that one process can execute simultaneously. Version 18 and up only. Changing this parameter causes a service restart.
• wal (object) - schema details
• default_toast_compression (string): Specifies the default TOAST compression method for values of compressible columns. The default is lz4. Only available for PostgreSQL 14+.
• deadlock_timeout (integer): This is the amount of time, in milliseconds, to wait on a lock before checking to see if there is a deadlock condition. The default is 1000 (upstream default).
• idle_in_transaction_session_timeout (integer): Time out sessions with open transactions after this number of milliseconds
• max_pred_locks_per_transaction (integer): PostgreSQL maximum predicate locks per transaction. The default is 64 (upstream default). Changing this parameter causes a service restart.
• max_replication_slots (integer): PostgreSQL maximum replication slots. The default is 20. Changing this parameter causes a service restart.
• max_sync_workers_per_subscription (integer): Maximum number of synchronization workers per subscription. The default is 2.
• autovacuum (object) - schema details
• max_parallel_workers_per_gather (integer): Sets the maximum number of workers that can be started by a single Gather or Gather Merge node. The default is 2 (upstream default).
• io_combine_limit (integer): EXPERIMENTAL: Controls the largest I/O size in operations that combine I/O in 8kB units. Version 17 and up only.
• password_encryption (string): Chooses the algorithm for encrypting passwords.
• io_workers (integer): EXPERIMENTAL: Number of IO worker processes, for io_method=worker. Version 18 and up only. Changing this parameter causes a service restart.
• pg_partman_bgw.interval (integer): Sets the time interval in seconds to run pg_partman’s scheduled tasks. The default is 3600.
• log_line_prefix (string): Choose from one of the available log formats.
• log_temp_files (integer): Log statements for each temporary file created larger than this number of kilobytes, -1 disables
• max_locks_per_transaction (integer): PostgreSQL maximum locks per transaction. Changing this parameter causes a service restart.
• track_commit_timestamp (string): Record commit time of transactions. Changing this parameter causes a service restart.
• track_functions (string): Enables tracking of function call counts and time used.
• io_max_combine_limit (integer): EXPERIMENTAL: Controls the largest I/O size in operations that combine I/O in 8kB units, and silently limits the user-settable parameter io_combine_limit. Version 18 and up only. Changing this parameter causes a service restart.
• io_method (string): EXPERIMENTAL: Controls the maximum number of I/O operations that one process can execute simultaneously. Version 18 and up only. Changing this parameter causes a service restart.
• max_stack_depth (integer): Maximum depth of the stack in bytes. The default is 2097152 (upstream default).
• max_parallel_workers (integer): Sets the maximum number of workers that the system can support for parallel queries. The default is 8 (upstream default).
• pg_partman_bgw.role (string): Controls which role to use for pg_partman’s scheduled background tasks.
• max_logical_replication_workers (integer): PostgreSQL maximum logical replication workers (taken from the pool of max_parallel_workers). The default is 4 (upstream default). Changing this parameter causes a service restart.
• max_prepared_transactions (integer): PostgreSQL maximum prepared transactions. The default is 0. Changing this parameter causes a service restart.
• max_worker_processes (integer): Sets the maximum number of background processes that the system can support. The default is 8. Changing this parameter causes a service restart.
• pg_stat_statements.track (string): Controls which statements are counted. Specify top to track top-level statements (those issued directly by clients), all to also track nested statements (such as statements invoked within functions), or none to disable statement statistics collection. The default is top.
• temp_file_limit (integer): PostgreSQL temporary file limit in KiB, -1 for unlimited
• log_error_verbosity (string): Controls the amount of detail written in the server log for each message that is logged.
• log_min_duration_statement (integer): Log statements that take more than this number of milliseconds to run, -1 disables
• max_standby_streaming_delay (integer): Max standby streaming delay in milliseconds. The default is 30000 (upstream default).
• jit (boolean): Controls system-wide use of Just-in-Time Compilation (JIT).
• max_standby_archive_delay (integer): Max standby archive delay in milliseconds. The default is 30000 (upstream default).
• bg-writer (object) - schema details