postgres14_options

<table>
<tr><td>名前</td><td>値</td><td>許可された値</td><td>変更可能</td><td>送信元</td><td>適用タイプ</td><td>データ型</td><td>説明</tr>
<tr><td>application_name</td><td></td><td></td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Sets the application name to be reported in statistics and logs.</tr>
<tr><td>archive_command</td><td>/etc/rds/dbbin/pgscripts/rds_wal_archive %p</td><td></td><td>FALSE</td><td>system</td><td>dynamic</td><td>string</td><td>Sets the shell command that will be called to archive a WAL file.</tr>
<tr><td>archive_timeout</td><td>300</td><td>0-2147483647</td><td>FALSE</td><td>system</td><td>dynamic</td><td>integer</td><td>(s) Forces a switch to the next xlog file if a new file has not been started within N seconds.</tr>
<tr><td>array_nulls</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Enable input of NULL elements in arrays.</tr>
<tr><td>authentication_timeout</td><td></td><td>1-600</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>(s) Sets the maximum allowed time to complete client authentication.</tr>
<tr><td>auto_explain.log_analyze</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Use EXPLAIN ANALYZE for plan logging.</tr>
<tr><td>auto_explain.log_buffers</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Log buffers usage.</tr>
<tr><td>auto_explain.log_format</td><td></td><td>text, xml, json, yaml</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>EXPLAIN format to be used for plan logging.</tr>
<tr><td>auto_explain.log_min_duration</td><td></td><td>-2147483648</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>(ms) Sets the minimum execution time above which plans will be logged.</tr>
<tr><td>auto_explain.log_nested_statements</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Log nested statements.</tr>
<tr><td>auto_explain.log_timing</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Collect timing data, not just row counts.</tr>
<tr><td>auto_explain.log_triggers</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Include trigger statistics in plans.</tr>
<tr><td>auto_explain.log_verbose</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Use EXPLAIN VERBOSE for plan logging.</tr>
<tr><td>auto_explain.sample_rate</td><td></td><td>0-1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>float</td><td>Fraction of queries to process.</tr>
<tr><td>autovacuum</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Starts the autovacuum subprocess.</tr>
<tr><td>autovacuum_analyze_scale_factor</td><td>0.05</td><td>0-100</td><td>TRUE</td><td>system</td><td>dynamic</td><td>float</td><td>Number of tuple inserts, updates or deletes prior to analyze as a fraction of reltuples.</tr>
<tr><td>autovacuum_analyze_threshold</td><td></td><td>0-2147483647</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>Minimum number of tuple inserts, updates or deletes prior to analyze.</tr>
<tr><td>autovacuum_freeze_max_age</td><td></td><td>100000000-750000000</td><td>TRUE</td><td>engine-default</td><td>static</td><td>integer</td><td>Age at which to autovacuum a table to prevent transaction ID wraparound.</tr>
<tr><td>autovacuum_max_workers</td><td>GREATEST({DBInstanceClassMemory/64371566592},3)</td><td>1-8388607</td><td>TRUE</td><td>system</td><td>static</td><td>integer</td><td>Sets the maximum number of simultaneously running autovacuum worker processes.</tr>
<tr><td>autovacuum_multixact_freeze_max_age</td><td></td><td>10000000-2000000000</td><td>TRUE</td><td>engine-default</td><td>static</td><td>integer</td><td>Multixact age at which to autovacuum a table to prevent multixact wraparound.</tr>
<tr><td>autovacuum_naptime</td><td>15</td><td>1-2147483</td><td>TRUE</td><td>system</td><td>dynamic</td><td>integer</td><td>(s) Time to sleep between autovacuum runs.</tr>
<tr><td>autovacuum_vacuum_cost_delay</td><td></td><td>-101</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>(ms) Vacuum cost delay in milliseconds, for autovacuum.</tr>
<tr><td>autovacuum_vacuum_cost_limit</td><td>GREATEST({log(DBInstanceClassMemory/21474836480)*600},200)</td><td>-10001</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>Vacuum cost amount available before napping, for autovacuum.</tr>
<tr><td>autovacuum_vacuum_insert_scale_factor</td><td></td><td>0-100</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>float</td><td>Number of tuple inserts prior to vacuum as a fraction of reltuples.</tr>
<tr><td>autovacuum_vacuum_insert_threshold</td><td></td><td>-2147483648</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>Minimum number of tuple inserts prior to vacuum, or -1 to disable insert vacuums.</tr>
<tr><td>autovacuum_vacuum_scale_factor</td><td>0.1</td><td>0-100</td><td>TRUE</td><td>system</td><td>dynamic</td><td>float</td><td>Number of tuple updates or deletes prior to vacuum as a fraction of reltuples.</tr>
<tr><td>autovacuum_vacuum_threshold</td><td></td><td>0-2147483647</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>Minimum number of tuple updates or deletes prior to vacuum.</tr>
<tr><td>autovacuum_work_mem</td><td></td><td>-2147483648</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>(kB) Sets the maximum memory to be used by each autovacuum worker process.</tr>
<tr><td>backend_flush_after</td><td></td><td>0-256</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>(8Kb) Number of pages after which previously performed writes are flushed to disk.</tr>
<tr><td>backslash_quote</td><td></td><td>safe_encoding, on, off</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Sets whether \ is allowed in string literals.</tr>
<tr><td>backtrace_functions</td><td></td><td></td><td>FALSE</td><td>system</td><td>dynamic</td><td>string</td><td>Log backtrace for errors in these functions.</tr>
<tr><td>bgwriter_delay</td><td></td><td>10-10000</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>(ms) Background writer sleep time between rounds.</tr>
<tr><td>bgwriter_flush_after</td><td></td><td>0-256</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>(8Kb) Number of pages after which previously performed writes are flushed to disk.</tr>
<tr><td>bgwriter_lru_maxpages</td><td></td><td>0-1000</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>Background writer maximum number of LRU pages to flush per round.</tr>
<tr><td>bgwriter_lru_multiplier</td><td></td><td>0-10</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>float</td><td>Multiple of the average buffer usage to free per round.</tr>
<tr><td>bytea_output</td><td></td><td>escape, hex</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Sets the output format for bytea.</tr>
<tr><td>check_function_bodies</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Check function bodies during CREATE FUNCTION.</tr>
<tr><td>checkpoint_completion_target</td><td>0.9</td><td>0-1</td><td>TRUE</td><td>system</td><td>dynamic</td><td>float</td><td>Time spent flushing dirty buffers during checkpoint, as fraction of checkpoint interval.</tr>
<tr><td>checkpoint_flush_after</td><td></td><td>0-256</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>(8kB) Number of pages after which previously performed writes are flushed to disk.</tr>
<tr><td>checkpoint_timeout</td><td></td><td>30-3600</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>(s) Sets the maximum time between automatic WAL checkpoints.</tr>
<tr><td>checkpoint_warning</td><td></td><td>0-2147483647</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>(s) Enables warnings if checkpoint segments are filled more frequently than this.</tr>
<tr><td>client_connection_check_interval</td><td></td><td>0-2147483647</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>time between checks for client disconnection while running queries</tr>
<tr><td>client_encoding</td><td>UTF8</td><td></td><td>TRUE</td><td>system</td><td>dynamic</td><td>string</td><td>Sets the clients character set encoding.</tr>
<tr><td>client_min_messages</td><td></td><td>debug5, debug4, debug3, debug2, debug1, log, notice, warning, error</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Sets the message levels that are sent to the client.</tr>
<tr><td>commit_delay</td><td></td><td>0-100000</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>Sets the delay in microseconds between transaction commit and flushing WAL to disk.</tr>
<tr><td>commit_siblings</td><td></td><td>0-1000</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>Sets the minimum concurrent open transactions before performing commit_delay.</tr>
<tr><td>compute_query_id</td><td>auto</td><td>on, auto</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Enables in-core computation of a query identifier</tr>
<tr><td>config_file</td><td>/rdsdbdata/config/postgresql.conf</td><td></td><td>FALSE</td><td>system</td><td>static</td><td>string</td><td>Sets the servers main configuration file.</tr>
<tr><td>constraint_exclusion</td><td></td><td>partition, on, off</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Enables the planner to use constraints to optimize queries.</tr>
<tr><td>cpu_index_tuple_cost</td><td></td><td>0-1.79769e+308</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>float</td><td>Sets the planners estimate of the cost of processing each index entry during an index scan.</tr>
<tr><td>cpu_operator_cost</td><td></td><td>0-1.79769e+308</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>float</td><td>Sets the planners estimate of the cost of processing each operator or function call.</tr>
<tr><td>cpu_tuple_cost</td><td></td><td>0-1.79769e+308</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>float</td><td>Sets the planners estimate of the cost of processing each tuple (row).</tr>
<tr><td>cron.database_name</td><td>postgres</td><td></td><td>TRUE</td><td>engine-default</td><td>static</td><td>string</td><td>Sets the database to store pg_cron metadata tables</tr>
<tr><td>cron.log_run</td><td>on</td><td>on, off</td><td>TRUE</td><td>engine-default</td><td>static</td><td>string</td><td>Log all jobs runs into the job_run_details table</tr>
<tr><td>cron.log_statement</td><td>on</td><td>on, off</td><td>TRUE</td><td>engine-default</td><td>static</td><td>string</td><td>Log all cron statements prior to execution.</tr>
<tr><td>cron.max_running_jobs</td><td>5</td><td>0-100</td><td>TRUE</td><td>engine-default</td><td>static</td><td>integer</td><td>Maximum number of jobs that can run concurrently.</tr>
<tr><td>cron.use_background_workers</td><td>on</td><td></td><td>FALSE</td><td>system</td><td>static</td><td>string</td><td>Enables background workers for pg_cron</tr>
<tr><td>cursor_tuple_fraction</td><td></td><td>0-1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>float</td><td>Sets the planners estimate of the fraction of a cursors rows that will be retrieved.</tr>
<tr><td>data_directory</td><td>/rdsdbdata/db</td><td></td><td>FALSE</td><td>system</td><td>static</td><td>string</td><td>Sets the servers data directory.</tr>
<tr><td>datestyle</td><td></td><td></td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Sets the display format for date and time values.</tr>
<tr><td>db_user_namespace</td><td></td><td>0, 1</td><td>FALSE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Enables per-database user names.</tr>
<tr><td>deadlock_timeout</td><td></td><td>1-2147483647</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>(ms) Sets the time to wait on a lock before checking for deadlock.</tr>
<tr><td>debug_pretty_print</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Indents parse and plan tree displays.</tr>
<tr><td>debug_print_parse</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Logs each querys parse tree.</tr>
<tr><td>debug_print_plan</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Logs each querys execution plan.</tr>
<tr><td>debug_print_rewritten</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Logs each querys rewritten parse tree.</tr>
<tr><td>default_statistics_target</td><td></td><td>1-10000</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>Sets the default statistics target.</tr>
<tr><td>default_tablespace</td><td></td><td></td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Sets the default tablespace to create tables and indexes in.</tr>
<tr><td>default_toast_compression</td><td></td><td>pglz, lz4</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Sets the default TOAST compression method for columns of newly-created tables</tr>
<tr><td>default_transaction_deferrable</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Sets the default deferrable status of new transactions.</tr>
<tr><td>default_transaction_isolation</td><td></td><td>serializable, repeatable read, read committed, read uncommitted</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Sets the transaction isolation level of each new transaction.</tr>
<tr><td>default_transaction_read_only</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Sets the default read-only status of new transactions.</tr>
<tr><td>effective_cache_size</td><td>{DBInstanceClassMemory/16384}</td><td>1-2147483647</td><td>TRUE</td><td>system</td><td>dynamic</td><td>integer</td><td>(8kB) Sets the planners assumption about the size of the disk cache.</tr>
<tr><td>effective_io_concurrency</td><td></td><td>0-1000</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>Number of simultaneous requests that can be handled efficiently by the disk subsystem.</tr>
<tr><td>enable_async_append</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Enables or disables the query planner's use of async-aware append plan types</tr>
<tr><td>enable_bitmapscan</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Enables the planners use of bitmap-scan plans.</tr>
<tr><td>enable_gathermerge</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Enables the planner's use of gather merge plans.</tr>
<tr><td>enable_hashagg</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Enables the planners use of hashed aggregation plans.</tr>
<tr><td>enable_hashjoin</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Enables the planners use of hash join plans.</tr>
<tr><td>enable_incremental_sort</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Enables the planner's use of incremental sort steps.</tr>
<tr><td>enable_indexonlyscan</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Enables the planner's use of index-only-scan plans.</tr>
<tr><td>enable_indexscan</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Enables the planners use of index-scan plans.</tr>
<tr><td>enable_material</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Enables the planners use of materialization.</tr>
<tr><td>enable_memoize</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Enables the planner's use of memoization</tr>
<tr><td>enable_mergejoin</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Enables the planners use of merge join plans.</tr>
<tr><td>enable_nestloop</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Enables the planners use of nested-loop join plans.</tr>
<tr><td>enable_parallel_append</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Enables the planner's use of parallel append plans.</tr>
<tr><td>enable_parallel_hash</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Enables the planner's user of parallel hash plans.</tr>
<tr><td>enable_partition_pruning</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Enable plan-time and run-time partition pruning.</tr>
<tr><td>enable_partitionwise_aggregate</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Enables partitionwise aggregation and grouping.</tr>
<tr><td>enable_partitionwise_join</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Enables partitionwise join.</tr>
<tr><td>enable_seqscan</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Enables the planners use of sequential-scan plans.</tr>
<tr><td>enable_sort</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Enables the planners use of explicit sort steps.</tr>
<tr><td>enable_tidscan</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Enables the planners use of TID scan plans.</tr>
<tr><td>escape_string_warning</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Warn about backslash escapes in ordinary string literals.</tr>
<tr><td>exit_on_error</td><td></td><td>0, 1</td><td>FALSE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Terminate session on any error.</tr>
<tr><td>extra_float_digits</td><td></td><td>-18</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>Sets the number of digits displayed for floating-point values.</tr>
<tr><td>force_parallel_mode</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Forces use of parallel query facilities.</tr>
<tr><td>from_collapse_limit</td><td></td><td>1-2147483647</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>Sets the FROM-list size beyond which subqueries are not collapsed.</tr>
<tr><td>fsync</td><td>1</td><td>0, 1</td><td>FALSE</td><td>system</td><td>dynamic</td><td>boolean</td><td>Forces synchronization of updates to disk.</tr>
<tr><td>full_page_writes</td><td>1</td><td>0, 1</td><td>FALSE</td><td>system</td><td>dynamic</td><td>boolean</td><td>Writes full pages to WAL when first modified after a checkpoint.</tr>
<tr><td>geqo</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Enables genetic query optimization.</tr>
<tr><td>geqo_effort</td><td></td><td>1月10日</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>GEQO: effort is used to set the default for other GEQO parameters.</tr>
<tr><td>geqo_generations</td><td></td><td>0-2147483647</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>GEQO: number of iterations of the algorithm.</tr>
<tr><td>geqo_pool_size</td><td></td><td>0-2147483647</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>GEQO: number of individuals in the population.</tr>
<tr><td>geqo_seed</td><td></td><td>0-1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>float</td><td>GEQO: seed for random path selection.</tr>
<tr><td>geqo_selection_bias</td><td></td><td>1.5-2</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>float</td><td>GEQO: selective pressure within the population.</tr>
<tr><td>geqo_threshold</td><td></td><td>2-2147483647</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>Sets the threshold of FROM items beyond which GEQO is used.</tr>
<tr><td>gin_fuzzy_search_limit</td><td></td><td>0-2147483647</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>Sets the maximum allowed result for exact search by GIN.</tr>
<tr><td>gin_pending_list_limit</td><td></td><td>64-2147483647</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>(kB) Sets the maximum size of the pending list for GIN index.</tr>
<tr><td>hash_mem_multiplier</td><td></td><td>1-1000</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>float</td><td>Multiple of work_mem to use for hash tables.</tr>
<tr><td>hba_file</td><td>/rdsdbdata/config/pg_hba.conf</td><td></td><td>FALSE</td><td>system</td><td>static</td><td>string</td><td>Sets the servers hba configuration file.</tr>
<tr><td>hll.force_groupagg</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Force group aggregation for hll</tr>
<tr><td>hot_standby_feedback</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Allows feedback from a hot standby to the primary that will avoid query conflicts.</tr>
<tr><td>huge_pages</td><td>on</td><td>on, off</td><td>TRUE</td><td>system</td><td>static</td><td>string</td><td>Use of huge pages on Linux.</tr>
<tr><td>ident_file</td><td>/rdsdbdata/config/pg_ident.conf</td><td></td><td>FALSE</td><td>system</td><td>static</td><td>string</td><td>Sets the servers ident configuration file.</tr>
<tr><td>idle_in_transaction_session_timeout</td><td>86400000</td><td>0-2147483647</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>(ms) Sets the maximum allowed duration of any idling transaction.</tr>
<tr><td>idle_session_timeout</td><td></td><td>0-2147483647</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>Terminate any session that has been idle (that is, waiting for a client query), but not within an open transaction, for longer than the specified amount of time</tr>
<tr><td>ignore_invalid_pages</td><td>0</td><td>0, 1</td><td>FALSE</td><td>engine-default</td><td>static</td><td>boolean</td><td>Continues recovery after an invalid pages failure.</tr>
<tr><td>intervalstyle</td><td></td><td>postgres, postgres_verbose, sql_standard, iso_8601</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Sets the display format for interval values.</tr>
<tr><td>jit</td><td>0</td><td>0, 1</td><td>TRUE</td><td>system</td><td>dynamic</td><td>boolean</td><td>Allow JIT compilation.</tr>
<tr><td>jit_above_cost</td><td></td><td>-1-1.79769e+308</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>float</td><td>Perform JIT compilation if query is more expensive.</tr>
<tr><td>jit_inline_above_cost</td><td></td><td>-1-1.79769e+308</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>float</td><td>Perform JIT inlining if query is more expensive.</tr>
<tr><td>jit_optimize_above_cost</td><td></td><td>-1-1.79769e+308</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>float</td><td>Optimize JITed functions if query is more expensive.</tr>
<tr><td>join_collapse_limit</td><td></td><td>1-2147483647</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>Sets the FROM-list size beyond which JOIN constructs are not flattened.</tr>
<tr><td>lc_messages</td><td></td><td></td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Sets the language in which messages are displayed.</tr>
<tr><td>lc_monetary</td><td></td><td></td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Sets the locale for formatting monetary amounts.</tr>
<tr><td>lc_numeric</td><td></td><td></td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Sets the locale for formatting numbers.</tr>
<tr><td>lc_time</td><td></td><td></td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Sets the locale for formatting date and time values.</tr>
<tr><td>listen_addresses</td><td>*</td><td></td><td>FALSE</td><td>system</td><td>static</td><td>string</td><td>Sets the host name or IP address(es) to listen to.</tr>
<tr><td>lo_compat_privileges</td><td>0</td><td>0, 1</td><td>FALSE</td><td>system</td><td>dynamic</td><td>boolean</td><td>Enables backward compatibility mode for privilege checks on large objects.</tr>
<tr><td>log_autovacuum_min_duration</td><td>10000</td><td>-2147483648</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>(ms) Sets the minimum execution time above which autovacuum actions will be logged.</tr>
<tr><td>log_checkpoints</td><td>1</td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Logs each checkpoint.</tr>
<tr><td>log_connections</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Logs each successful connection.</tr>
<tr><td>log_destination</td><td>stderr</td><td>stderr, csvlog</td><td>TRUE</td><td>system</td><td>dynamic</td><td>string</td><td>Sets the destination for server log output.</tr>
<tr><td>log_directory</td><td>/rdsdbdata/log/error</td><td></td><td>FALSE</td><td>system</td><td>dynamic</td><td>string</td><td>Sets the destination directory for log files.</tr>
<tr><td>log_disconnections</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Logs end of a session, including duration.</tr>
<tr><td>log_duration</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Logs the duration of each completed SQL statement.</tr>
<tr><td>log_error_verbosity</td><td></td><td>terse, default, verbose</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Sets the verbosity of logged messages.</tr>
<tr><td>log_executor_stats</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Writes executor performance statistics to the server log.</tr>
<tr><td>log_file_mode</td><td>644</td><td></td><td>FALSE</td><td>system</td><td>dynamic</td><td>string</td><td>Sets the file permissions for log files.</tr>
<tr><td>log_filename</td><td>postgresql.log.%Y-%m-%d-%H</td><td>postgresql.log.%Y-%m-%d, postgresql.log.%Y-%m-%d-%H</td><td>TRUE</td><td>system</td><td>dynamic</td><td>string</td><td>Sets the file name pattern for log files.</tr>
<tr><td>logging_collector</td><td>1</td><td>0, 1</td><td>FALSE</td><td>system</td><td>static</td><td>boolean</td><td>Start a subprocess to capture stderr output and/or csvlogs into log files.</tr>
<tr><td>log_hostname</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Logs the host name in the connection logs.</tr>
<tr><td>logical_decoding_work_mem</td><td></td><td>64-2147483647</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>(kB) Sets the maximum memory to be used for logical decoding.</tr>
<tr><td>log_line_prefix</td><td>%t:%r:%u@%d:[%p]:</td><td></td><td>FALSE</td><td>system</td><td>dynamic</td><td>string</td><td>Controls information prefixed to each log line.</tr>
<tr><td>log_lock_waits</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Logs long lock waits.</tr>
<tr><td>log_min_duration_sample</td><td></td><td>-2147483648</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>(ms) Sets the minimum execution time above which a sample of statements will be logged. Sampling is determined by log_statement_sample_rate.</tr>
<tr><td>log_min_duration_statement</td><td></td><td>-2147483648</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>(ms) Sets the minimum execution time above which statements will be logged.</tr>
<tr><td>log_min_error_statement</td><td></td><td>debug5, debug4, debug3, debug2, debug1, info, notice, warning, error, log, fatal, panic</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Causes all statements generating error at or above this level to be logged.</tr>
<tr><td>log_min_messages</td><td></td><td>debug5, debug4, debug3, debug2, debug1, info, notice, warning, error, log, fatal</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Sets the message levels that are logged.</tr>
<tr><td>log_parameter_max_length</td><td></td><td>-1073741824</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>When logging statements, limit logged parameter values to first N bytes.</tr>
<tr><td>log_parameter_max_length_on_error</td><td></td><td>-1073741824</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>When reporting an error, limit logged parameter values to first N bytes.</tr>
<tr><td>log_parser_stats</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Writes parser performance statistics to the server log.</tr>
<tr><td>log_planner_stats</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Writes planner performance statistics to the server log.</tr>
<tr><td>log_recovery_conflict_waits</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Controls whether a log message is produced when the startup process waits longer than deadlock_timeout for recovery conflicts</tr>
<tr><td>log_replication_commands</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Logs each replication command.</tr>
<tr><td>log_rotation_age</td><td>60</td><td>1-1440</td><td>TRUE</td><td>system</td><td>dynamic</td><td>integer</td><td>(min) Automatic log file rotation will occur after N minutes.</tr>
<tr><td>log_rotation_size</td><td></td><td>0-2097151</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>(kB) Automatic log file rotation will occur after N kilobytes.</tr>
<tr><td>log_statement</td><td></td><td>none, ddl, mod, all</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Sets the type of statements logged.</tr>
<tr><td>log_statement_sample_rate</td><td></td><td>0-1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>float</td><td>Fraction of statements exceeding log_min_duration_sample to be logged.</tr>
<tr><td>log_statement_stats</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Writes cumulative performance statistics to the server log.</tr>
<tr><td>log_temp_files</td><td></td><td>-2147483648</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>(kB) Log the use of temporary files larger than this number of kilobytes.</tr>
<tr><td>log_timezone</td><td>UTC</td><td></td><td>FALSE</td><td>system</td><td>dynamic</td><td>string</td><td>Sets the time zone to use in log messages.</tr>
<tr><td>log_transaction_sample_rate</td><td></td><td>0.0-1.0</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>float</td><td>Set the fraction of transactions to log for new transactions.</tr>
<tr><td>log_truncate_on_rotation</td><td>0</td><td>0, 1</td><td>FALSE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Truncate existing log files of same name during log rotation.</tr>
<tr><td>maintenance_io_concurrency</td><td></td><td>0-1000</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>A variant of effective_io_concurrency that is used for maintenance work.</tr>
<tr><td>maintenance_work_mem</td><td>GREATEST({DBInstanceClassMemory*1024/63963136},65536)</td><td>1024-2147483647</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>(kB) Sets the maximum memory to be used for maintenance operations.</tr>
<tr><td>max_connections</td><td>LEAST({DBInstanceClassMemory/9531392},5000)</td><td>6-8388607</td><td>TRUE</td><td>system</td><td>static</td><td>integer</td><td>Sets the maximum number of concurrent connections.</tr>
<tr><td>max_files_per_process</td><td></td><td>64-2147483647</td><td>TRUE</td><td>engine-default</td><td>static</td><td>integer</td><td>Sets the maximum number of simultaneously open files for each server process.</tr>
<tr><td>max_locks_per_transaction</td><td>64</td><td>10-2147483647</td><td>TRUE</td><td>engine-default</td><td>static</td><td>integer</td><td>Sets the maximum number of locks per transaction.</tr>
<tr><td>max_logical_replication_workers</td><td></td><td>0-262143</td><td>TRUE</td><td>engine-default</td><td>static</td><td>integer</td><td>Maximum number of logical replication worker processes.</tr>
<tr><td>max_parallel_maintenance_workers</td><td></td><td>0-1024</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>Sets the maximum number of parallel processes per maintenance operation.</tr>
<tr><td>max_parallel_workers</td><td>GREATEST(${DBInstanceVCPU/2},8)</td><td>0-1024</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>Sets the maximum number of parallel workers than can be active at one time.</tr>
<tr><td>max_parallel_workers_per_gather</td><td></td><td>0-1024</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>Sets the maximum number of parallel processes per executor node.</tr>
<tr><td>max_pred_locks_per_page</td><td></td><td>0-2147483647</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>Sets the maximum number of predicate-locked tuples per page.</tr>
<tr><td>max_pred_locks_per_relation</td><td></td><td>-4294967295</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>Sets the maximum number of predicate-locked pages and tuples per relation.</tr>
<tr><td>max_pred_locks_per_transaction</td><td></td><td>10-2147483647</td><td>TRUE</td><td>engine-default</td><td>static</td><td>integer</td><td>Sets the maximum number of predicate locks per transaction.</tr>
<tr><td>max_prepared_transactions</td><td>0</td><td>0-8388607</td><td>TRUE</td><td>engine-default</td><td>static</td><td>integer</td><td>Sets the maximum number of simultaneously prepared transactions.</tr>
<tr><td>max_replication_slots</td><td>20</td><td>5-8388607</td><td>TRUE</td><td>system</td><td>static</td><td>integer</td><td>Sets the maximum number of replication slots that the server can support.</tr>
<tr><td>max_slot_wal_keep_size</td><td></td><td>-2147483648</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>(MB) Sets the maximum WAL size that can be reserved by replication slots.</tr>
<tr><td>max_stack_depth</td><td>6144</td><td>100-2147483647</td><td>TRUE</td><td>system</td><td>dynamic</td><td>integer</td><td>(kB) Sets the maximum stack depth, in kilobytes.</tr>
<tr><td>max_standby_archive_delay</td><td></td><td>-2147483648</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>(ms) Sets the maximum delay before canceling queries when a hot standby server is processing archived WAL data.</tr>
<tr><td>max_standby_streaming_delay</td><td></td><td>-2147483648</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>(ms) Sets the maximum delay before canceling queries when a hot standby server is processing streamed WAL data.</tr>
<tr><td>max_sync_workers_per_subscription</td><td></td><td>0-262143</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>Maximum number of synchronization workers per subscription</tr>
<tr><td>max_wal_senders</td><td>20</td><td>5-8388607</td><td>TRUE</td><td>system</td><td>static</td><td>integer</td><td>Sets the maximum number of simultaneously running WAL sender processes.</tr>
<tr><td>max_wal_size</td><td>2048</td><td>128-201326592</td><td>TRUE</td><td>system</td><td>dynamic</td><td>integer</td><td>(MB) Sets the WAL size that triggers a checkpoint.</tr>
<tr><td>max_worker_processes</td><td>GREATEST(${DBInstanceVCPU*2},8)</td><td>0-262143</td><td>TRUE</td><td>engine-default</td><td>static</td><td>integer</td><td>Sets the maximum number of concurrent worker processes.</tr>
<tr><td>min_dynamic_shared_memory</td><td></td><td>0-715827882</td><td>TRUE</td><td>engine-default</td><td>static</td><td>integer</td><td>Specifies the amount of memory that should be allocated at server startup for use by parallel queries</tr>
<tr><td>min_parallel_index_scan_size</td><td></td><td>0-715827882</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>(8kB) Sets the minimum amount of index data for a parallel scan.</tr>
<tr><td>min_parallel_table_scan_size</td><td></td><td>0-715827882</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>(8kB) Sets the minimum amount of table data for a parallel scan.</tr>
<tr><td>min_wal_size</td><td>192</td><td>128-201326592</td><td>TRUE</td><td>system</td><td>dynamic</td><td>integer</td><td>(MB) Sets the minimum size to shrink the WAL to.</tr>
<tr><td>old_snapshot_threshold</td><td></td><td>-86401</td><td>TRUE</td><td>engine-default</td><td>static</td><td>integer</td><td>(min) Time before a snapshot is too old to read pages changed after the snapshot was taken.</tr>
<tr><td>orafce.nls_date_format</td><td></td><td></td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Emulate oracle's date output behaviour.</tr>
<tr><td>orafce.timezone</td><td></td><td></td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Specify timezone used for sysdate function.</tr>
<tr><td>parallel_leader_participation</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Controls whether Gather and Gather Merge also run subplans.</tr>
<tr><td>parallel_setup_cost</td><td></td><td>0-1.79769e+308</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>float</td><td>Sets the planner's estimate of the cost of starting up worker processes for parallel query.</tr>
<tr><td>parallel_tuple_cost</td><td></td><td>0-1.79769e+308</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>float</td><td>Sets the planner's estimate of the cost of passing each tuple (row) from worker to master backend.</tr>
<tr><td>password_encryption</td><td></td><td>md5, scram-sha-256</td><td>TRUE</td><td>system</td><td>dynamic</td><td>string</td><td>Encrypt passwords.</tr>
<tr><td>pgaudit.log</td><td></td><td>ddl, function, misc, read, role, write, none, all, -ddl, -function, -misc, -read, -role, -write</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>list</td><td>Specifies which classes of statements will be logged by session audit logging.</tr>
<tr><td>pgaudit.log_catalog</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Specifies that session logging should be enabled in the case where all relations in a statement are in pg_catalog.</tr>
<tr><td>pgaudit.log_level</td><td></td><td>debug5, debug4, debug3, debug2, debug1, info, notice, warning, log</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Specifies the log level that will be used for log entries.</tr>
<tr><td>pgaudit.log_parameter</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Specifies that audit logging should include the parameters that were passed with the statement.</tr>
<tr><td>pgaudit.log_relation</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Specifies whether session audit logging should create a separate log entry for each relation (TABLE, VIEW, etc.) referenced in a SELECT or DML statement.</tr>
<tr><td>pgaudit.log_rows</td><td>0</td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Specifies that audit logging should include the rows retrieved or affected by a statement.</tr>
<tr><td>pgaudit.log_statement</td><td>1</td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Specifies whether logging will include the statement text and parameters (if enabled).</tr>
<tr><td>pgaudit.log_statement_once</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Specifies whether logging will include the statement text and parameters with the first log entry for a statement/substatement combination or with every entry.</tr>
<tr><td>pgaudit.role</td><td></td><td>rds_pgaudit</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Specifies the master role to use for object audit logging.</tr>
<tr><td>pg_bigm.enable_recheck</td><td>on</td><td>on, off</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>It specifies whether to perform Recheck which is an internal process of full text search.</tr>
<tr><td>pg_bigm.gin_key_limit</td><td>0</td><td>0-2147483647</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>It specifies the maximum number of 2-grams of the search keyword to be used for full text search.</tr>
<tr><td>pg_bigm.last_update</td><td>2013.11.22</td><td></td><td>FALSE</td><td>engine-default</td><td>static</td><td>string</td><td>It reports the last updated date of the pg_bigm module.</tr>
<tr><td>pg_bigm.similarity_limit</td><td>0.3</td><td>0-1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>float</td><td>It specifies the minimum threshold used by the similarity search.</tr>
<tr><td>pg_hint_plan.debug_print</td><td></td><td>off, on, detailed, verbose</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Logs results of hint parsing.</tr>
<tr><td>pg_hint_plan.enable_hint</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Force planner to use plans specified in the hint comment preceding to the query.</tr>
<tr><td>pg_hint_plan.enable_hint_table</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Force planner to not get hint by using table lookups.</tr>
<tr><td>pg_hint_plan.message_level</td><td></td><td>debug5, debug4, debug3, debug2, debug1, log, info, notice, warning, error</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Message level of debug messages.</tr>
<tr><td>pg_hint_plan.parse_messages</td><td></td><td>debug5, debug4, debug3, debug2, debug1, log, info, notice, warning, error</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Message level of parse errors.</tr>
<tr><td>pglogical.batch_inserts</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>static</td><td>boolean</td><td>Batch inserts if possible</tr>
<tr><td>pglogical.conflict_log_level</td><td></td><td>debug5, debug4, debug3, debug2, debug1, info, notice, warning, error, log, fatal, panic</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Sets log level used for logging resolved conflicts.</tr>
<tr><td>pglogical.conflict_resolution</td><td></td><td>error, apply_remote, keep_local, last_update_wins, first_update_wins</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Sets method used for conflict resolution for resolvable conflicts.</tr>
<tr><td>pglogical.extra_connection_options</td><td></td><td></td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>connection options to add to all peer node connections</tr>
<tr><td>pglogical.synchronous_commit</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>static</td><td>boolean</td><td>pglogical specific synchronous commit value</tr>
<tr><td>pglogical.use_spi</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>static</td><td>boolean</td><td>Use SPI instead of low-level API for applying changes</tr>
<tr><td>pg_prewarm.autoprewarm</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>static</td><td>boolean</td><td>Starts the autoprewarm worker.</tr>
<tr><td>pg_prewarm.autoprewarm_interval</td><td></td><td>0-2147483</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>Sets the interval between dumps of shared buffers</tr>
<tr><td>pg_similarity.block_is_normalized</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Sets if the result value is normalized or not.</tr>
<tr><td>pg_similarity.block_threshold</td><td></td><td>0-1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>float</td><td>Sets the threshold used by the Block similarity function.</tr>
<tr><td>pg_similarity.block_tokenizer</td><td></td><td>alnum, gram, word, camelcase</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Sets the tokenizer for Block similarity function.</tr>
<tr><td>pg_similarity.cosine_is_normalized</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Sets if the result value is normalized or not.</tr>
<tr><td>pg_similarity.cosine_threshold</td><td></td><td>0-1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>float</td><td>Sets the threshold used by the Cosine similarity function.</tr>
<tr><td>pg_similarity.cosine_tokenizer</td><td></td><td>alnum, gram, word, camelcase</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Sets the tokenizer for Cosine similarity function.</tr>
<tr><td>pg_similarity.dice_is_normalized</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Sets if the result value is normalized or not.</tr>
<tr><td>pg_similarity.dice_threshold</td><td></td><td>0-1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>float</td><td>Sets the threshold used by the Dice similarity measure.</tr>
<tr><td>pg_similarity.dice_tokenizer</td><td></td><td>alnum, gram, word, camelcase</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Sets the tokenizer for Dice similarity measure.</tr>
<tr><td>pg_similarity.euclidean_is_normalized</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Sets if the result value is normalized or not.</tr>
<tr><td>pg_similarity.euclidean_threshold</td><td></td><td>0-1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>float</td><td>Sets the threshold used by the Euclidean similarity measure.</tr>
<tr><td>pg_similarity.euclidean_tokenizer</td><td></td><td>alnum, gram, word, camelcase</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Sets the tokenizer for Euclidean similarity measure.</tr>
<tr><td>pg_similarity.hamming_is_normalized</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Sets if the result value is normalized or not.</tr>
<tr><td>pg_similarity.hamming_threshold</td><td></td><td>0-1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>float</td><td>Sets the threshold used by the Block similarity metric.</tr>
<tr><td>pg_similarity.jaccard_is_normalized</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Sets if the result value is normalized or not.</tr>
<tr><td>pg_similarity.jaccard_threshold</td><td></td><td>0-1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>float</td><td>Sets the threshold used by the Jaccard similarity measure.</tr>
<tr><td>pg_similarity.jaccard_tokenizer</td><td></td><td>alnum, gram, word, camelcase</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Sets the tokenizer for Jaccard similarity measure.</tr>
<tr><td>pg_similarity.jaro_is_normalized</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Sets if the result value is normalized or not.</tr>
<tr><td>pg_similarity.jaro_threshold</td><td></td><td>0-1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>float</td><td>Sets the threshold used by the Jaro similarity measure.</tr>
<tr><td>pg_similarity.jarowinkler_is_normalized</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Sets if the result value is normalized or not.</tr>
<tr><td>pg_similarity.jarowinkler_threshold</td><td></td><td>0-1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>float</td><td>Sets the threshold used by the Jarowinkler similarity measure.</tr>
<tr><td>pg_similarity.levenshtein_is_normalized</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Sets if the result value is normalized or not.</tr>
<tr><td>pg_similarity.levenshtein_threshold</td><td></td><td>0-1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>float</td><td>Sets the threshold used by the Levenshtein similarity measure.</tr>
<tr><td>pg_similarity.matching_is_normalized</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Sets if the result value is normalized or not.</tr>
<tr><td>pg_similarity.matching_threshold</td><td></td><td>0-1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>float</td><td>Sets the threshold used by the Matching Coefficient similarity measure.</tr>
<tr><td>pg_similarity.matching_tokenizer</td><td></td><td>alnum, gram, word, camelcase</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Sets the tokenizer for Matching Coefficient similarity measure.</tr>
<tr><td>pg_similarity.mongeelkan_is_normalized</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Sets if the result value is normalized or not.</tr>
<tr><td>pg_similarity.mongeelkan_threshold</td><td></td><td>0-1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>float</td><td>Sets the threshold used by the Monge-Elkan similarity measure.</tr>
<tr><td>pg_similarity.mongeelkan_tokenizer</td><td></td><td>alnum, gram, word, camelcase</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Sets the tokenizer for Monge-Elkan similarity measure.</tr>
<tr><td>pg_similarity.nw_gap_penalty</td><td></td><td>-1.84467E+19</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>float</td><td>Sets the gap penalty used by the Needleman-Wunsch similarity measure.</tr>
<tr><td>pg_similarity.nw_is_normalized</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Sets if the result value is normalized or not.</tr>
<tr><td>pg_similarity.nw_threshold</td><td></td><td>0-1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>float</td><td>Sets the threshold used by the Needleman-Wunsch similarity measure.</tr>
<tr><td>pg_similarity.overlap_is_normalized</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Sets if the result value is normalized or not.</tr>
<tr><td>pg_similarity.overlap_threshold</td><td></td><td>0-1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>float</td><td>Sets the threshold used by the Overlap Coefficient similarity measure.</tr>
<tr><td>pg_similarity.overlap_tokenizer</td><td></td><td>alnum, gram, word, camelcase</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Sets the tokenizer for Overlap Coefficientsimilarity measure.</tr>
<tr><td>pg_similarity.qgram_is_normalized</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Sets if the result value is normalized or not.</tr>
<tr><td>pg_similarity.qgram_threshold</td><td></td><td>0-1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>float</td><td>Sets the threshold used by the Q-Gram similarity measure.</tr>
<tr><td>pg_similarity.qgram_tokenizer</td><td></td><td>alnum, gram, word, camelcase</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Sets the tokenizer for Q-Gram measure.</tr>
<tr><td>pg_similarity.swg_is_normalized</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Sets if the result value is normalized or not.</tr>
<tr><td>pg_similarity.swg_threshold</td><td></td><td>0-1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>float</td><td>Sets the threshold used by the Smith-Waterman-Gotoh similarity measure.</tr>
<tr><td>pg_similarity.sw_is_normalized</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Sets if the result value is normalized or not.</tr>
<tr><td>pg_similarity.sw_threshold</td><td></td><td>0-1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>float</td><td>Sets the threshold used by the Smith-Waterman similarity measure.</tr>
<tr><td>pg_stat_statements.max</td><td></td><td>100-2147483647</td><td>TRUE</td><td>engine-default</td><td>static</td><td>integer</td><td>Sets the maximum number of statements tracked by pg_stat_statements.</tr>
<tr><td>pg_stat_statements.save</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Save pg_stat_statements statistics across server shutdowns.</tr>
<tr><td>pg_stat_statements.track</td><td></td><td>NONE, TOP, ALL</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Selects which statements are tracked by pg_stat_statements.</tr>
<tr><td>pg_stat_statements.track_planning</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Selects whether planning duration is tracked by pg_stat_statements.</tr>
<tr><td>pg_stat_statements.track_utility</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Selects whether utility commands are tracked by pg_stat_statements.</tr>
<tr><td>pg_transport.num_workers</td><td></td><td>1-32</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>Number of workers to use for a physical transport.</tr>
<tr><td>pg_transport.timing</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Specifies whether to report timing information during transport.</tr>
<tr><td>pg_transport.work_mem</td><td></td><td>65536-2147483647</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>(kB) Amount of memory each worker can allocate for a physical transport.</tr>
<tr><td>plan_cache_mode</td><td></td><td>auto, force_generic_plan, force_custom_plan</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Controls the planner selection of custom or generic plan.</tr>
<tr><td>port</td><td>{EndPointPort}</td><td>1-65535</td><td>FALSE</td><td>system</td><td>static</td><td>integer</td><td>Sets the TCP port the server listens on.</tr>
<tr><td>postgis.gdal_enabled_drivers</td><td>ENABLE_ALL</td><td>ENABLE_ALL, DISABLE_ALL</td><td>TRUE</td><td>system</td><td>static</td><td>string</td><td>Enable for disable GDAL drivers used with PostGIS in Postgres 9.3.5 and above.</tr>
<tr><td>quote_all_identifiers</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>When generating SQL fragments, quote all identifiers.</tr>
<tr><td>random_page_cost</td><td></td><td>0-1.79769e+308</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>float</td><td>Sets the planners estimate of the cost of a nonsequentially fetched disk page.</tr>
<tr><td>rdkit.dice_threshold</td><td></td><td>0-1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>float</td><td>Lower threshold of Dice similarity. Molecules with similarity lower than threshold are not similar by # operation.</tr>
<tr><td>rdkit.do_chiral_sss</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Should stereochemistry be taken into account in substructure matching. If false, no stereochemistry information is used in substructure matches.</tr>
<tr><td>rdkit.tanimoto_threshold</td><td></td><td>0-1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>float</td><td>Lower threshold of Tanimoto similarity. Molecules with similarity lower than threshold are not similar by % operation.</tr>
<tr><td>rds.accepted_password_auth_method</td><td>md5+scram</td><td>md5+scram, scram</td><td>TRUE</td><td>system</td><td>dynamic</td><td>string</td><td>Force authentication for connections with password stored locally</tr>
<tr><td>rds.adaptive_autovacuum</td><td>1</td><td>0, 1</td><td>TRUE</td><td>system</td><td>dynamic</td><td>boolean</td><td>RDS parameter to enable/disable adaptive autovacuum.</tr>
<tr><td>rds.allowed_extensions</td><td></td><td></td><td>TRUE</td><td>system</td><td>dynamic</td><td>string</td><td>Comma-delimited list of extensions that may be installed.</tr>
<tr><td>rds.custom_dns_resolution</td><td>0</td><td>0, 1</td><td>TRUE</td><td>system</td><td>static</td><td>boolean</td><td>Allow DNS resolution in Customer VPC.</tr>
<tr><td>rds.force_admin_logging_level</td><td></td><td>disabled, debug5, debug4, debug3, debug2, debug1, info, notice, warning, error, log, fatal, panic</td><td>TRUE</td><td>system</td><td>dynamic</td><td>string</td><td>See log messages for RDS admin user actions in customer databases.</tr>
<tr><td>rds.force_autovacuum_logging_level</td><td>WARNING</td><td>disabled, debug5, debug4, debug3, debug2, debug1, info, notice, warning, error, log, fatal, panic</td><td>TRUE</td><td>system</td><td>dynamic</td><td>string</td><td>See log messages related to autovacuum operations.</tr>
<tr><td>rds.force_ssl</td><td>0</td><td>0, 1</td><td>TRUE</td><td>system</td><td>dynamic</td><td>boolean</td><td>Force SSL connections.</tr>
<tr><td>rds.logical_replication</td><td>0</td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>static</td><td>boolean</td><td>Enables logical decoding.</tr>
<tr><td>rds.log_retention_period</td><td>4320</td><td>1440-10080</td><td>TRUE</td><td>system</td><td>dynamic</td><td>integer</td><td>Amazon RDS will delete PostgreSQL log that are older than N minutes.</tr>
<tr><td>rds.max_tcp_buffers</td><td>33554432</td><td>4096-1000000000</td><td>FALSE</td><td>system</td><td>dynamic</td><td>integer</td><td>Sets the maximum size for tcp buffers.</tr>
<tr><td>rds.pg_stat_ramdisk_size</td><td>0</td><td>0-8196</td><td>TRUE</td><td>system</td><td>static</td><td>integer</td><td>Size of the stats ramdisk in MB. A nonzero value signals HM to set up the ramdisk.</tr>
<tr><td>rds.rds_superuser_reserved_connections</td><td>2</td><td>0-8388607</td><td>TRUE</td><td>system</td><td>static</td><td>integer</td><td>Sets the number of connection slots reserved for rds_superusers.</tr>
<tr><td>rds.restrict_password_commands</td><td></td><td>0, 1</td><td>TRUE</td><td>system</td><td>static</td><td>boolean</td><td>restricts password-related commands to members of rds_password</tr>
<tr><td>recovery_init_sync_method</td><td>syncfs</td><td>fsync, syncfs</td><td>FALSE</td><td>engine-default</td><td>static</td><td>string</td><td>When set to fsync, PostgreSQL will recursively open and synchronize all files in the data directory before crash recovery begins</tr>
<tr><td>remove_temp_files_after_crash</td><td>0</td><td>0-1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>float</td><td>When set to on, which is the default, PostgreSQL will automatically remove temporary files after a backend crash</tr>
<tr><td>restart_after_crash</td><td></td><td>0, 1</td><td>FALSE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Reinitialize server after backend crash.</tr>
<tr><td>row_security</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Enable row security.</tr>
<tr><td>search_path</td><td></td><td></td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Sets the schema search order for names that are not schema-qualified.</tr>
<tr><td>seq_page_cost</td><td></td><td>0-1.79769e+308</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>float</td><td>Sets the planners estimate of the cost of a sequentially fetched disk page.</tr>
<tr><td>session_preload_libraries</td><td></td><td>auto_explain, orafce, pg_bigm, pg_hint_plan, pg_prewarm, pg_similarity, pg_stat_statements, pg_transport, plprofiler</td><td>TRUE</td><td>system</td><td>static</td><td>list</td><td>Lists shared libraries to preload into each backend.</tr>
<tr><td>session_replication_role</td><td></td><td>origin, replica, local</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Sets the sessions behavior for triggers and rewrite rules.</tr>
<tr><td>shared_buffers</td><td>{DBInstanceClassMemory/32768}</td><td>16-1073741823</td><td>TRUE</td><td>system</td><td>static</td><td>integer</td><td>(8kB) Sets the number of shared memory buffers used by the server.</tr>
<tr><td>shared_preload_libraries</td><td>pg_stat_statements</td><td>auto_explain, orafce, pgaudit, pglogical, pg_bigm, pg_cron, pg_hint_plan, pg_prewarm, pg_similarity, pg_stat_statements, pg_transport, plprofiler</td><td>TRUE</td><td>system</td><td>static</td><td>list</td><td>Lists shared libraries to preload into server.</tr>
<tr><td>ssl</td><td>1</td><td>0, 1</td><td>FALSE</td><td>system</td><td>dynamic</td><td>boolean</td><td>Enables SSL connections.</tr>
<tr><td>ssl_ca_file</td><td>/rdsdbdata/rds-metadata/ca-cert.pem</td><td></td><td>FALSE</td><td>system</td><td>dynamic</td><td>string</td><td>Location of the SSL server authority file.</tr>
<tr><td>ssl_cert_file</td><td>/rdsdbdata/rds-metadata/server-cert.pem</td><td></td><td>FALSE</td><td>system</td><td>dynamic</td><td>string</td><td>Location of the SSL server certificate file.</tr>
<tr><td>ssl_ciphers</td><td></td><td></td><td>FALSE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Sets the list of allowed SSL ciphers.</tr>
<tr><td>ssl_key_file</td><td>/rdsdbdata/rds-metadata/server-key.pem</td><td></td><td>FALSE</td><td>system</td><td>dynamic</td><td>string</td><td>Location of the SSL server private key file</tr>
<tr><td>ssl_max_protocol_version</td><td></td><td>TLSv1, TLSv1.1, TLSv1.2</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Sets the maximum SSL/TLS protocol version to use.</tr>
<tr><td>ssl_min_protocol_version</td><td>TLSv1.2</td><td>TLSv1, TLSv1.1, TLSv1.2</td><td>TRUE</td><td>system</td><td>dynamic</td><td>string</td><td>Sets the minimum SSL/TLS protocol version to use.</tr>
<tr><td>standard_conforming_strings</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Causes ... strings to treat backslashes literally.</tr>
<tr><td>statement_timeout</td><td></td><td>0-2147483647</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>(ms) Sets the maximum allowed duration of any statement.</tr>
<tr><td>stats_temp_directory</td><td>/rdsdbdata/db/pg_stat_tmp</td><td></td><td>FALSE</td><td>system</td><td>dynamic</td><td>string</td><td>Writes temporary statistics files to the specified directory.</tr>
<tr><td>superuser_reserved_connections</td><td>3</td><td>0-8388607</td><td>FALSE</td><td>system</td><td>static</td><td>integer</td><td>Sets the number of connection slots reserved for superusers.</tr>
<tr><td>synchronize_seqscans</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Enable synchronized sequential scans.</tr>
<tr><td>synchronous_commit</td><td>on</td><td>local, on, off</td><td>TRUE</td><td>system</td><td>dynamic</td><td>string</td><td>Sets the current transactions synchronization level.</tr>
<tr><td>tcp_keepalives_count</td><td></td><td>0-2147483647</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>Maximum number of TCP keepalive retransmits.</tr>
<tr><td>tcp_keepalives_idle</td><td></td><td>0-2147483647</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>(s) Time between issuing TCP keepalives.</tr>
<tr><td>tcp_keepalives_interval</td><td></td><td>0-2147483647</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>(s) Time between TCP keepalive retransmits.</tr>
<tr><td>temp_buffers</td><td></td><td>100-1073741823</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>(8kB) Sets the maximum number of temporary buffers used by each session.</tr>
<tr><td>temp_file_limit</td><td></td><td>-2147483648</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>(kB) Limits the total size of all temporary files used by each process.</tr>
<tr><td>temp_tablespaces</td><td></td><td></td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Sets the tablespace(s) to use for temporary tables and sort files.</tr>
<tr><td>timezone</td><td>UTC</td><td></td><td>TRUE</td><td>system</td><td>dynamic</td><td>string</td><td>Sets the time zone for displaying and interpreting time stamps.</tr>
<tr><td>track_activities</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Collects information about executing commands.</tr>
<tr><td>track_activity_query_size</td><td>4096</td><td>100-1048576</td><td>TRUE</td><td>engine-default</td><td>static</td><td>integer</td><td>Sets the size reserved for pg_stat_activity.current_query, in bytes.</tr>
<tr><td>track_commit_timestamp</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>static</td><td>boolean</td><td>Collects transaction commit time.</tr>
<tr><td>track_counts</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Collects statistics on database activity.</tr>
<tr><td>track_functions</td><td>pl</td><td>none, pl, all</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Collects function-level statistics on database activity.</tr>
<tr><td>track_io_timing</td><td>1</td><td>0, 1</td><td>TRUE</td><td>system</td><td>dynamic</td><td>boolean</td><td>Collects timing statistics on database IO activity.</tr>
<tr><td>track_wal_io_timing</td><td></td><td>0, 1</td><td>TRUE</td><td>system</td><td>dynamic</td><td>boolean</td><td>Enables timing of WAL I/O calls.</tr>
<tr><td>transform_null_equals</td><td></td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Treats expr=NULL as expr IS NULL.</tr>
<tr><td>unix_socket_directories</td><td>/tmp</td><td></td><td>FALSE</td><td>system</td><td>static</td><td>string</td><td>Sets the directory where the Unix-domain socket will be created.</tr>
<tr><td>unix_socket_group</td><td>rdsdb</td><td></td><td>FALSE</td><td>system</td><td>static</td><td>string</td><td>Sets the owning group of the Unix-domain socket.</tr>
<tr><td>unix_socket_permissions</td><td>700</td><td>0-511</td><td>FALSE</td><td>system</td><td>static</td><td>integer</td><td>Sets the access permissions of the Unix-domain socket.</tr>
<tr><td>update_process_title</td><td>1</td><td>0, 1</td><td>FALSE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Updates the process title to show the active SQL command.</tr>
<tr><td>vacuum_cost_delay</td><td></td><td>0-100</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>(ms) Vacuum cost delay in milliseconds.</tr>
<tr><td>vacuum_cost_limit</td><td></td><td>1-10000</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>Vacuum cost amount available before napping.</tr>
<tr><td>vacuum_cost_page_dirty</td><td></td><td>0-10000</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>Vacuum cost for a page dirtied by vacuum.</tr>
<tr><td>vacuum_cost_page_hit</td><td></td><td>0-10000</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>Vacuum cost for a page found in the buffer cache.</tr>
<tr><td>vacuum_cost_page_miss</td><td>5</td><td>0-10000</td><td>TRUE</td><td>system</td><td>dynamic</td><td>integer</td><td>Vacuum cost for a page not found in the buffer cache.</tr>
<tr><td>vacuum_defer_cleanup_age</td><td></td><td>0-1000000</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>Number of transactions by which VACUUM and HOT cleanup should be deferred, if any.</tr>
<tr><td>vacuum_failsafe_age</td><td>1200000000</td><td>0-1200000000</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>Specifies the maximum age (in transactions) that a table's pg_class.relfrozenxid field can attain before VACUUM takes extraordinary measures to avoid system-wide transaction ID wraparound failure</tr>
<tr><td>vacuum_freeze_min_age</td><td></td><td>0-1000000000</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>Minimum age at which VACUUM should freeze a table row.</tr>
<tr><td>vacuum_freeze_table_age</td><td></td><td>0-2000000000</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>Age at which VACUUM should scan whole table to freeze tuples.</tr>
<tr><td>vacuum_multixact_failsafe_age</td><td>1200000000</td><td>0-1200000000</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>Specifies the maximum age (in transactions) that a table's pg_class.relminmxid field can attain before VACUUM takes extraordinary measures to avoid system-wide multixact ID wraparound failure</tr>
<tr><td>vacuum_multixact_freeze_min_age</td><td></td><td>0-1000000000</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>Minimum age at which VACUUM should freeze a MultiXactId in a table row.</tr>
<tr><td>vacuum_multixact_freeze_table_age</td><td></td><td>0-2000000000</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>Multixact age at which VACUUM should scan whole table to freeze tuples.</tr>
<tr><td>wal_buffers</td><td></td><td>-262144</td><td>TRUE</td><td>engine-default</td><td>static</td><td>integer</td><td>(8kB) Sets the number of disk-page buffers in shared memory for WAL.</tr>
<tr><td>wal_compression</td><td>1</td><td>0, 1</td><td>TRUE</td><td>engine-default</td><td>static</td><td>boolean</td><td>Compresses full-page writes written in WAL file.</tr>
<tr><td>wal_keep_size</td><td>2048</td><td>0-2147483647</td><td>TRUE</td><td>system</td><td>dynamic</td><td>integer</td><td>(MB) Sets the size of WAL files held for standby servers.</tr>
<tr><td>wal_receiver_create_temp_slot</td><td>0</td><td>0, 1</td><td>FALSE</td><td>engine-default</td><td>dynamic</td><td>boolean</td><td>Sets whether a WAL receiver should create a temporary replication slot if no permanent slot is configured.</tr>
<tr><td>wal_receiver_status_interval</td><td></td><td>0-2147483</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>(s) Sets the maximum interval between WAL receiver status reports to the primary.</tr>
<tr><td>wal_receiver_timeout</td><td>30000</td><td>0-3600000</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>(ms) Sets the maximum wait time to receive data from the primary.</tr>
<tr><td>wal_sender_timeout</td><td>30000</td><td>0-3600000</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>(ms) Sets the maximum time to wait for WAL replication.</tr>
<tr><td>wal_skip_threshold</td><td></td><td>0-2147483647</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>(kB) Size of new file to fsync instead of writing WAL.</tr>
<tr><td>wal_sync_method</td><td></td><td>fsync, fdatasync, open_sync, open_datasync</td><td>FALSE</td><td>system</td><td>dynamic</td><td>string</td><td>Selects the method used for forcing WAL updates to disk.</tr>
<tr><td>wal_writer_delay</td><td></td><td>1-10000</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>(ms) WAL writer sleep time between WAL flushes.</tr>
<tr><td>wal_writer_flush_after</td><td></td><td>0-2147483647</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>(8Kb) Amount of WAL written out by WAL writer triggering a flush.</tr>
<tr><td>work_mem</td><td></td><td>64-2147483647</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>integer</td><td>(kB) Sets the maximum memory to be used for query workspaces.</tr>
<tr><td>xmlbinary</td><td></td><td>base64, hex</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Sets how binary values are to be encoded in XML.</tr>
<tr><td>xmloption</td><td></td><td>content, document</td><td>TRUE</td><td>engine-default</td><td>dynamic</td><td>string</td><td>Sets whether XML data in implicit parsing and serialization operations is to be considered as documents or content fragments.</tr>
</table>