postgres14_options

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