PostgreSQL Extensions
You can set the following supported extensions for PostgreSQL:
| Extension Name | Description |
|---|---|
| dataChecksums | Use checksums on data pages to help detect corruption by the I/O system that would otherwise be silent(default value: enabled). This option can only be set during creation of the database instance, and cannot be changed later. For more details click here. |
| maxConnections | Determines the maximum number of concurrent connections to the database server(default value: 128). For more details click here. |
| effectiveCacheSize | Sets the planner's assumption about the effective size of the disk cache that is available to a single query. For more details click here. |
| workMem | Specifies the amount of memory to be used by internal sort operations and hash tables before writing to temporary disk files(default value: 8 MB). For more details click here. |
| maintenanceWorkMem | Specifies the maximum amount of memory to be used by maintenance operations, such as VACUUM, CREATE INDEX, and ALTER TABLE ADD FOREIGN KEY. For more details click here. |
| tempFileLimit | Specifies the maximum amount of disk space that a process can use for temporary files, such as sort and hash temporary files, or the storage file for a held cursor(-1 means 'no limit', which is also the default value). For more details click here. |
| trackIoTiming | Enables timing of database I/O calls(default value: off). For more details click here. |
| archiveTimeout | Enforces the server to switch to a new WAL segment file periodically(default value: null, which is 1h). For more details click here. |
| statementTimeout | Abort any statement that takes more than the specified number of milliseconds, starting from the time the command arrives at the server from the client(default value: 0). For more details click here. |
| idleInTransactionSessionTimeout | Terminate any session with an open transaction that has been idle for longer than the specified duration in milliseconds(default value: 0). For more details click here. |
| rolePrivileges | Configures default privileges for the credentials. For more details click here. |
| walLevelLogical | Configures wal_level(default value: false). For more details click here. |
| walWriterDelay | Configures how often the WAL writer flushes WAL(default value: 200 milliseconds). For more details click here. |
| maxReplicationSlots | Configures the maximum amount of replication slots(default value: 4). For more details click here. |
| maxWalSenders | Configures the maximum amount of WAL sender fore each node of the service instance(default value: 0). For more details click here. |
| synchronousCommit | Configures synchronous_commit which specifies how much WAL processing must be completed before the database server returns a 'success' indication to the client.(default value: on). For more details click here. |
| clientMinMessages | Controls which message levels are sent to the client. For more details click here. |
| logMinMessages | Controls which message levels are written to the server log(default value: WARNING). For more details click here. |
| logMinErrorStatement | Controls which SQL statements that cause an error condition are recorded in the server log(default value: PANIC). For more details click here. |
| logStatement | Controls which SQL statements are logged. For more details click here. |
| logErrorVerbosity | Controls the amount of detail written in the server log for each message that is logged. For more details click here. |