| trackActivityQuerySize |
Integer |
Specifies the number of bytes reserved to track the currently executing command for each active session. Changing this parameter causes a service restart. |
[optional] |
| timezone |
String |
PostgreSQL service timezone |
[optional] |
| trackIoTiming |
TrackIoTimingEnum |
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. |
[optional] |
| pgStatMonitorPgsmEnableQueryPlan |
Boolean |
Enables or disables query plan monitoring. Changing this parameter causes a service restart. Only available for PostgreSQL 13+. |
[optional] |
| maxFilesPerProcess |
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. |
[optional] |
| pgStatMonitorPgsmMaxBuckets |
Integer |
Sets the maximum number of buckets. Changing this parameter causes a service restart. Only available for PostgreSQL 13+. |
[optional] |
| ioMaxConcurrency |
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. |
[optional] |
| wal |
WriteAheadLogWALSettings |
|
[optional] |
| defaultToastCompression |
DefaultToastCompressionEnum |
Specifies the default TOAST compression method for values of compressible columns. The default is `lz4`. Only available for PostgreSQL 14+. |
[optional] |
| deadlockTimeout |
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). |
[optional] |
| idleInTransactionSessionTimeout |
Integer |
Time out sessions with open transactions after this number of milliseconds |
[optional] |
| maxPredLocksPerTransaction |
Integer |
PostgreSQL maximum predicate locks per transaction. The default is `64` (upstream default). Changing this parameter causes a service restart. |
[optional] |
| maxReplicationSlots |
Integer |
PostgreSQL maximum replication slots. The default is `20`. Changing this parameter causes a service restart. |
[optional] |
| maxSyncWorkersPerSubscription |
Integer |
Maximum number of synchronization workers per subscription. The default is `2`. |
[optional] |
| autovacuum |
AutovacuumSettings |
|
[optional] |
| maxParallelWorkersPerGather |
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). |
[optional] |
| ioCombineLimit |
Integer |
EXPERIMENTAL: Controls the largest I/O size in operations that combine I/O in 8kB units. Version 17 and up only. |
[optional] |
| passwordEncryption |
PasswordEncryptionEnum |
Chooses the algorithm for encrypting passwords. |
[optional] |
| ioWorkers |
Integer |
EXPERIMENTAL: Number of IO worker processes, for io_method=worker. Version 18 and up only. Changing this parameter causes a service restart. |
[optional] |
| pgPartmanBgwInterval |
Integer |
Sets the time interval in seconds to run pg_partman's scheduled tasks. The default is `3600`. |
[optional] |
| logLinePrefix |
LogLinePrefixEnum |
Choose from one of the available log formats. |
[optional] |
| logTempFiles |
Integer |
Log statements for each temporary file created larger than this number of kilobytes, -1 disables |
[optional] |
| maxLocksPerTransaction |
Integer |
PostgreSQL maximum locks per transaction. Changing this parameter causes a service restart. |
[optional] |
| trackCommitTimestamp |
TrackCommitTimestampEnum |
Record commit time of transactions. Changing this parameter causes a service restart. |
[optional] |
| trackFunctions |
TrackFunctionsEnum |
Enables tracking of function call counts and time used. |
[optional] |
| ioMaxCombineLimit |
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. |
[optional] |
| ioMethod |
IoMethodEnum |
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. |
[optional] |
| maxStackDepth |
Integer |
Maximum depth of the stack in bytes. The default is `2097152` (upstream default). |
[optional] |
| maxParallelWorkers |
Integer |
Sets the maximum number of workers that the system can support for parallel queries. The default is `8` (upstream default). |
[optional] |
| pgPartmanBgwRole |
String |
Controls which role to use for pg_partman's scheduled background tasks. |
[optional] |
| maxLogicalReplicationWorkers |
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. |
[optional] |
| maxPreparedTransactions |
Integer |
PostgreSQL maximum prepared transactions. The default is `0`. Changing this parameter causes a service restart. |
[optional] |
| maxWorkerProcesses |
Integer |
Sets the maximum number of background processes that the system can support. The default is `8`. Changing this parameter causes a service restart. |
[optional] |
| pgStatStatementsTrack |
PgStatStatementsTrackEnum |
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`. |
[optional] |
| tempFileLimit |
Integer |
PostgreSQL temporary file limit in KiB, -1 for unlimited |
[optional] |
| logErrorVerbosity |
LogErrorVerbosityEnum |
Controls the amount of detail written in the server log for each message that is logged. |
[optional] |
| logMinDurationStatement |
Integer |
Log statements that take more than this number of milliseconds to run, -1 disables |
[optional] |
| maxStandbyStreamingDelay |
Integer |
Max standby streaming delay in milliseconds. The default is `30000` (upstream default). |
[optional] |
| jit |
Boolean |
Controls system-wide use of Just-in-Time Compilation (JIT). |
[optional] |
| maxStandbyArchiveDelay |
Integer |
Max standby archive delay in milliseconds. The default is `30000` (upstream default). |
[optional] |
| bgWriter |
BackgroundBGWriterSettings |
|
[optional] |