Amazon Aurora PostgreSQL parameters - Amazon Aurora
Viewing Aurora PostgreSQL parametersAurora PostgreSQL cluster-level parametersAurora PostgreSQL instance-level parameters

Amazon Aurora PostgreSQL parameters

You manage your Amazon Aurora DB cluster in the same way that you manage Amazon RDS DB instances, by using parameters in a DB parameter group. However, Amazon Aurora differs from Amazon RDS in that an Aurora DB cluster has multiple DB instances. Some of the parameters that you use to manage your Amazon Aurora DB cluster apply to the entire cluster, while other parameters apply only to a given DB instance in the DB cluster, as follows:

  • DB cluster parameter group – A DB cluster parameter group contains the set of engine configuration parameters that apply throughout the Aurora DB cluster. For example, cluster cache management is a feature of an Aurora DB cluster that's controlled by the apg_ccm_enabled parameter which is part of the DB cluster parameter group. The DB cluster parameter group also contains default settings for the DB parameter group for the DB instances that make up the cluster.

  • DB parameter group – A DB parameter group is the set of engine configuration values that apply to a specific DB instance of that engine type. The DB parameter groups for the PostgreSQL DB engine are used by an RDS for PostgreSQL DB instance and Aurora PostgreSQL DB cluster. These configuration settings apply to properties that can vary among the DB instances within an Aurora cluster, such as the sizes for memory buffers.

You manage cluster-level parameters in DB cluster parameter groups. You manage instance-level parameters in DB parameter groups. You can manage parameters using the Amazon RDS console, the AWS CLI, or the Amazon RDS API. There are separate commands for managing cluster-level parameters and instance-level parameters.

To learn more about the AWS CLI, see Using the AWS CLI in the AWS Command Line Interface User Guide.

For more information about parameter groups, see Working with parameter groups.

Viewing Aurora PostgreSQL DB cluster and DB parameters

You can view all available default parameter groups for RDS for PostgreSQL DB instances and for Aurora PostgreSQL DB clusters in the AWS Management Console. The default parameter groups for all DB engines and DB cluster types and versions are listed for each AWS Region. Any custom parameter groups are also listed.

Rather than viewing in the AWS Management Console, you can also list parameters contained in DB cluster parameter groups and DB parameter groups by using the AWS CLI or the Amazon RDS API. For example, to list parameters in a DB cluster parameter group you use the describe-db-cluster-parameters AWS CLI command as follows:

aws rds describe-db-cluster-parameters --db-cluster-parameter-group-name default.aurora-postgresql12

The command returns detailed JSON descriptions of each parameter. To reduce the amount of information returned, you can specify what you want by using the --query option. For example, you can get the parameter name, its description, and allowed values for the default Aurora PostgreSQL 12 DB cluster parameter group as follows:

For Linux, macOS, or Unix:

aws rds describe-db-cluster-parameters --db-cluster-parameter-group-name default.aurora-postgresql12 \
    --query 'Parameters[].[{ParameterName:ParameterName,Description:Description,ApplyType:ApplyType,AllowedValues:AllowedValues}]'

For Windows:

aws rds describe-db-cluster-parameters --db-cluster-parameter-group-name default.aurora-postgresql12 ^
    --query "Parameters[].[{ParameterName:ParameterName,Description:Description,ApplyType:ApplyType,AllowedValues:AllowedValues}]"

An Aurora DB cluster parameter group includes the DB instance parameter group and default values for a given Aurora DB engine. You can get the list of DB parameters from the same default Aurora PostgreSQL default parameter group by usng the describe-db-parameters AWS CLI command as shown following.

For Linux, macOS, or Unix:

aws rds describe-db-parameters --db-parameter-group-name default.aurora-postgresql12 \
    --query 'Parameters[].[{ParameterName:ParameterName,Description:Description,ApplyType:ApplyType,AllowedValues:AllowedValues}]'

For Windows:

aws rds describe-db-parameters --db-parameter-group-name default.aurora-postgresql12 ^
    --query "Parameters[].[{ParameterName:ParameterName,Description:Description,ApplyType:ApplyType,AllowedValues:AllowedValues}]"

The preceding commands return lists of parameters from the DB cluster or DB parameter group with descriptions and other details specified in the query. Following is an example response.

[
    [
        {
            "ParameterName": "apg_enable_batch_mode_function_execution",
            "ApplyType": "dynamic",
            "Description": "Enables batch-mode functions to process sets of rows at a time.",
            "AllowedValues": "0,1"
        }
    ],
    [
        {
            "ParameterName": "apg_enable_correlated_any_transform",
            "ApplyType": "dynamic",
            "Description": "Enables the planner to transform correlated ANY Sublink (IN/NOT IN subquery) to JOIN when possible.",
            "AllowedValues": "0,1"
        }
    ],...

Following are tables containing values for the default DB cluster parameter and DB parameter for Aurora PostgreSQL version 14.

Aurora PostgreSQL cluster-level parameters

You can view the cluster-level parameters available for a specific Aurora PostgreSQL version using the AWS Management console, the AWS CLI, or the Amazon RDS API. For information about viewing the parameters in an Aurora PostgreSQL DB cluster parameter groups in the RDS console, see Viewing parameter values for a DB cluster parameter group.

Some cluster-level parameters aren't available in all versions and some are being deprecated. For information about viewing the parameters of a specific Aurora PostgreSQL version, see Viewing Aurora PostgreSQL DB cluster and DB parameters.

For example, the following table lists the parameters available in the default DB cluster parameter group for Aurora PostgreSQL version 14. If you create an Aurora PostgreSQL DB cluster without specifying your own custom DB parameter group, your DB cluster is created using the default Aurora DB cluster parameter group for the version chosen, such as default.aurora-postgresql14, default.aurora-postgresql13, and so on.

For a listing of the DB instance parameters for this same default DB cluster parameter group, see Aurora PostgreSQL instance-level parameters.

Parameter name

Description

Default

ansi_constraint_trigger_ordering

Change the firing order of constraint triggers to be compatible with the ANSI SQL standard.

–

ansi_force_foreign_key_checks

Ensure referential actions such as cascaded delete or cascaded update will always occur regardless of the various trigger contexts that exist for the action.

–

ansi_qualified_update_set_target

Support table and schema qualifiers in UPDATE ... SET statements.

–

apg_ccm_enabled

Enable or disable cluster cache management for the cluster.

–

apg_enable_batch_mode_function_execution

Enables batch-mode functions to process sets of rows at a time.

–

apg_enable_correlated_any_transform

Enables the planner to transform correlated ANY Sublink (IN/NOT IN subquery) to JOIN when possible.

–

apg_enable_function_migration

Enables the planner to migrate eligible scalar functions to the FROM clause.

–

apg_enable_not_in_transform

Enables the planner to transform NOT IN subquery to ANTI JOIN when possible.

–

apg_enable_remove_redundant_inner_joins

Enables the planner to remove redundant inner joins.

–

apg_enable_semijoin_push_down

Enables the use of semijoin filters for hash joins.

–

apg_plan_mgmt.capture_plan_baselines

Capture plan baseline mode. manual - enable plan capture for any SQL statement, off - disable plan capture, automatic - enable plan capture for for statements in pg_stat_statements that satisfy the eligibility criteria.

off

apg_plan_mgmt.max_databases

Sets the maximum number of databases that that may manage queries using apg_plan_mgmt.

10

apg_plan_mgmt.max_plans

Sets the maximum number of plans that may be cached by apg_plan_mgmt.

10000

apg_plan_mgmt.plan_retention_period

Maximum number of days since a plan was last_used before a plan will be automatically deleted.

32

apg_plan_mgmt.unapproved_plan_execution_threshold

Estimated total plan cost below which an Unapproved plan will be executed.

0

apg_plan_mgmt.use_plan_baselines

Use only approved or fixed plans for managed statements.

false

application_name

Sets the application name to be reported in statistics and logs.

–

array_nulls

Enable input of NULL elements in arrays.

–

aurora_compute_plan_id

Monitors query execution plans to detect the execution plans contributing to current database load and to track performance statistics of execution plans over time. For more information, see Monitoring query execution plans for Aurora PostgreSQL.

on

authentication_timeout

(s) Sets the maximum allowed time to complete client authentication.

–

auto_explain.log_analyze

Use EXPLAIN ANALYZE for plan logging.

–

auto_explain.log_buffers

Log buffers usage.

–

auto_explain.log_format

EXPLAIN format to be used for plan logging.

–

auto_explain.log_min_duration

Sets the minimum execution time above which plans will be logged.

–

auto_explain.log_nested_statements

Log nested statements.

–

auto_explain.log_timing

Collect timing data, not just row counts.

–

auto_explain.log_triggers

Include trigger statistics in plans.

–

auto_explain.log_verbose

Use EXPLAIN VERBOSE for plan logging.

–

auto_explain.sample_rate

Fraction of queries to process.

–

autovacuum

Starts the autovacuum subprocess.

–

autovacuum_analyze_scale_factor

Number of tuple inserts, updates or deletes prior to analyze as a fraction of reltuples.

0.05

autovacuum_analyze_threshold

Minimum number of tuple inserts, updates or deletes prior to analyze.

–

autovacuum_freeze_max_age

Age at which to autovacuum a table to prevent transaction ID wraparound.

–

autovacuum_max_workers

Sets the maximum number of simultaneously running autovacuum worker processes.

GREATEST(DBInstanceClassMemory/64371566592,3)

autovacuum_multixact_freeze_max_age

Multixact age at which to autovacuum a table to prevent multixact wraparound.

–

autovacuum_naptime

(s) Time to sleep between autovacuum runs.

5

autovacuum_vacuum_cost_delay

(ms) Vacuum cost delay in milliseconds, for autovacuum.

5

autovacuum_vacuum_cost_limit

Vacuum cost amount available before napping, for autovacuum.

GREATEST(log(DBInstanceClassMemory/21474836480)*600,200)

autovacuum_vacuum_insert_scale_factor

Number of tuple inserts prior to vacuum as a fraction of reltuples.

–

autovacuum_vacuum_insert_threshold

Minimum number of tuple inserts prior to vacuum, or -1 to disable insert vacuums.

–

autovacuum_vacuum_scale_factor

Number of tuple updates or deletes prior to vacuum as a fraction of reltuples.

0.1

autovacuum_vacuum_threshold

Minimum number of tuple updates or deletes prior to vacuum.

–

autovacuum_work_mem

(kB) Sets the maximum memory to be used by each autovacuum worker process.

GREATEST(DBInstanceClassMemory/32768,131072)

babelfishpg_tds.default_server_name

Default Babelfish server name

Microsoft SQL Server

babelfishpg_tds.listen_addresses

Sets the host name or IP address(es) to listen TDS to.

*

babelfishpg_tds.port

Sets the TDS TCP port the server listens on.

1433

babelfishpg_tds.tds_debug_log_level

Sets logging level in TDS, 0 disables logging

1

babelfishpg_tds.tds_default_numeric_precision

Sets the default precision of numeric type to be sent in the TDS column metadata if the engine does not specify one.

38

babelfishpg_tds.tds_default_numeric_scale

Sets the default scale of numeric type to be sent in the TDS column metadata if the engine does not specify one.

8

babelfishpg_tds.tds_default_packet_size

Sets the default packet size for all the SQL Server clients being connected

4096

babelfishpg_tds.tds_default_protocol_version

Sets a default TDS protocol version for all the clients being connected

DEFAULT

babelfishpg_tds.tds_ssl_encrypt

Sets the SSL Encryption option

0

babelfishpg_tds.tds_ssl_max_protocol_version

Sets the maximum SSL/TLS protocol version to use for tds session.

TLSv1.2

babelfishpg_tds.tds_ssl_min_protocol_version

Sets the minimum SSL/TLS protocol version to use for tds session.

TLSv1.2 from Aurora PostgreSQL version 16, TLSv1 for versions older than Aurora PostgreSQL version 16

babelfishpg_tsql.default_locale

Default locale to be used for collations created by CREATE COLLATION.

en-US

babelfishpg_tsql.migration_mode

Defines if multiple user databases are supported

multi-db from Aurora PostgreSQL version 16, single-db for versions older than Aurora PostgreSQL version 16

babelfishpg_tsql.server_collation_name

Name of the default server collation

sql_latin1_general_cp1_ci_as

babelfishpg_tsql.version

Sets the output of @@VERSION variable

default

backend_flush_after

(8Kb) Number of pages after which previously performed writes are flushed to disk.

–

backslash_quote

Sets whether \\ is allowed in string literals.

–

backtrace_functions

Log backtrace for errors in these functions.

–

bytea_output

Sets the output format for bytea.

–

check_function_bodies

Check function bodies during CREATE FUNCTION.

–

client_connection_check_interval

Sets the time interval between checks for disconnection while running queries.

–

client_encoding

Sets the clients character set encoding.

UTF8

client_min_messages

Sets the message levels that are sent to the client.

–

compute_query_id

Compute query identifiers.

auto

config_file

Sets the servers main configuration file.

/rdsdbdata/config/postgresql.conf

constraint_exclusion

Enables the planner to use constraints to optimize queries.

–

cpu_index_tuple_cost

Sets the planners estimate of the cost of processing each index entry during an index scan.

–

cpu_operator_cost

Sets the planners estimate of the cost of processing each operator or function call.

–

cpu_tuple_cost

Sets the planners estimate of the cost of processing each tuple (row).

–

cron.database_name

Sets the database to store pg_cron metadata tables

postgres

cron.log_run

Log all jobs runs into the job_run_details table

on

cron.log_statement

Log all cron statements prior to execution.

off

cron.max_running_jobs

Maximum number of jobs that can run concurrently.

5

cron.use_background_workers

Enables background workers for pg_cron

on

cursor_tuple_fraction

Sets the planners estimate of the fraction of a cursors rows that will be retrieved.

–

data_directory

Sets the servers data directory.

/rdsdbdata/db

datestyle

Sets the display format for date and time values.

–

db_user_namespace

Enables per-database user names.

–

deadlock_timeout

(ms) Sets the time to wait on a lock before checking for deadlock.

–

debug_pretty_print

Indents parse and plan tree displays.

–

debug_print_parse

Logs each querys parse tree.

–

debug_print_plan

Logs each querys execution plan.

–

debug_print_rewritten

Logs each querys rewritten parse tree.

–

default_statistics_target

Sets the default statistics target.

–

default_tablespace

Sets the default tablespace to create tables and indexes in.

–

default_toast_compression

Sets the default compression method for compressible values.

–

default_transaction_deferrable

Sets the default deferrable status of new transactions.

–

default_transaction_isolation

Sets the transaction isolation level of each new transaction.

–

default_transaction_read_only

Sets the default read-only status of new transactions.

–

effective_cache_size

(8kB) Sets the planners assumption about the size of the disk cache.

SUM(DBInstanceClassMemory/12038,-50003)

effective_io_concurrency

Number of simultaneous requests that can be handled efficiently by the disk subsystem.

–

enable_async_append

Enables the planners use of async append plans.

–

enable_bitmapscan

Enables the planners use of bitmap-scan plans.

–

enable_gathermerge

Enables the planners use of gather merge plans.

–

enable_hashagg

Enables the planners use of hashed aggregation plans.

–

enable_hashjoin

Enables the planners use of hash join plans.

–

enable_incremental_sort

Enables the planners use of incremental sort steps.

–

enable_indexonlyscan

Enables the planners use of index-only-scan plans.

–

enable_indexscan

Enables the planners use of index-scan plans.

–

enable_material

Enables the planners use of materialization.

–

enable_memoize

Enables the planners use of memoization

–

enable_mergejoin

Enables the planners use of merge join plans.

–

enable_nestloop

Enables the planners use of nested-loop join plans.

–

enable_parallel_append

Enables the planners use of parallel append plans.

–

enable_parallel_hash

Enables the planners user of parallel hash plans.

–

enable_partition_pruning

Enable plan-time and run-time partition pruning.

–

enable_partitionwise_aggregate

Enables partitionwise aggregation and grouping.

–

enable_partitionwise_join

Enables partitionwise join.

–

enable_seqscan

Enables the planners use of sequential-scan plans.

–

enable_sort

Enables the planners use of explicit sort steps.

–

enable_tidscan

Enables the planners use of TID scan plans.

–

escape_string_warning

Warn about backslash escapes in ordinary string literals.

–

exit_on_error

Terminate session on any error.

–

extra_float_digits

Sets the number of digits displayed for floating-point values.

–

force_parallel_mode

Forces use of parallel query facilities.

–

from_collapse_limit

Sets the FROM-list size beyond which subqueries are not collapsed.

–

geqo

Enables genetic query optimization.

–

geqo_effort

GEQO: effort is used to set the default for other GEQO parameters.

–

geqo_generations

GEQO: number of iterations of the algorithm.

–

geqo_pool_size

GEQO: number of individuals in the population.

–

geqo_seed

GEQO: seed for random path selection.

–

geqo_selection_bias

GEQO: selective pressure within the population.

–

geqo_threshold

Sets the threshold of FROM items beyond which GEQO is used.

–

gin_fuzzy_search_limit

Sets the maximum allowed result for exact search by GIN.

–

gin_pending_list_limit

(kB) Sets the maximum size of the pending list for GIN index.

–

hash_mem_multiplier

Multiple of work_mem to use for hash tables.

–

hba_file

Sets the servers hba configuration file.

/rdsdbdata/config/pg_hba.conf

hot_standby_feedback

Allows feedback from a hot standby to the primary that will avoid query conflicts.

on

huge_pages

Reduces overhead when a DB instance is working with large contiguous chunks of memory, such as that used by shared buffers. It is turned on by default for all the DB instance classes other than t3.medium,db.t3.large,db.t4g.medium,db.t4g.large instance classes.

on

ident_file

Sets the servers ident configuration file.

/rdsdbdata/config/pg_ident.conf

idle_in_transaction_session_timeout

(ms) Sets the maximum allowed duration of any idling transaction.

86400000

idle_session_timeout

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

–

intervalstyle

Sets the display format for interval values.

–

join_collapse_limit

Sets the FROM-list size beyond which JOIN constructs are not flattened.

–

krb_caseins_users

Sets whether GSSAPI (Generic Security Service API) user names should be treated case-insensitively (true) or not. By default, this parameter is set to false, so Kerberos expects user names to be case sensitive. For more information, see GSSAPI Authentication in the PostgreSQL documentation.

false

lc_messages

Sets the language in which messages are displayed.

–

lc_monetary

Sets the locale for formatting monetary amounts.

–

lc_numeric

Sets the locale for formatting numbers.

–

lc_time

Sets the locale for formatting date and time values.

–

listen_addresses

Sets the host name or IP address(es) to listen to.

*

lo_compat_privileges

Enables backward compatibility mode for privilege checks on large objects.

0

log_autovacuum_min_duration

(ms) Sets the minimum execution time above which autovacuum actions will be logged.

10000

log_connections

Logs each successful connection.

–

log_destination

Sets the destination for server log output.

stderr

log_directory

Sets the destination directory for log files.

/rdsdbdata/log/error

log_disconnections

Logs end of a session, including duration.

–

log_duration

Logs the duration of each completed SQL statement.

–

log_error_verbosity

Sets the verbosity of logged messages.

–

log_executor_stats

Writes executor performance statistics to the server log.

–

log_file_mode

Sets the file permissions for log files.

0644

log_filename

Sets the file name pattern for log files.

postgresql.log.%Y-%m-%d-%H%M

logging_collector

Start a subprocess to capture stderr output and/or csvlogs into log files.

1

log_hostname

Logs the host name in the connection logs.

0

logical_decoding_work_mem

(kB) This much memory can be used by each internal reorder buffer before spilling to disk.

–

log_line_prefix

Controls information prefixed to each log line.

%t:%r:%u@%d:%p]:

log_lock_waits

Logs long lock waits.

–

log_min_duration_sample

(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

(ms) Sets the minimum execution time above which statements will be logged.

–

log_min_error_statement

Causes all statements generating error at or above this level to be logged.

–

log_min_messages

Sets the message levels that are logged.

–

log_parameter_max_length

(B) When logging statements, limit logged parameter values to first N bytes.

–

log_parameter_max_length_on_error

(B) When reporting an error, limit logged parameter values to first N bytes.

–

log_parser_stats

Writes parser performance statistics to the server log.

–

log_planner_stats

Writes planner performance statistics to the server log.

–

log_replication_commands

Logs each replication command.

–

log_rotation_age

(min) Automatic log file rotation will occur after N minutes.

60

log_rotation_size

(kB) Automatic log file rotation will occur after N kilobytes.

100000

log_statement

Sets the type of statements logged.

–

log_statement_sample_rate

Fraction of statements exceeding log_min_duration_sample to be logged.

–

log_statement_stats

Writes cumulative performance statistics to the server log.

–

log_temp_files

(kB) Log the use of temporary files larger than this number of kilobytes.

–

log_timezone

Sets the time zone to use in log messages.

UTC

log_transaction_sample_rate

Set the fraction of transactions to log for new transactions.

–

log_truncate_on_rotation

Truncate existing log files of same name during log rotation.

0

maintenance_io_concurrency

A variant of effective_io_concurrency that is used for maintenance work.

1

maintenance_work_mem

(kB) Sets the maximum memory to be used for maintenance operations.

GREATEST(DBInstanceClassMemory/63963136*1024,65536)

max_connections

Sets the maximum number of concurrent connections.

LEAST(DBInstanceClassMemory/9531392,5000)

max_files_per_process

Sets the maximum number of simultaneously open files for each server process.

–

max_locks_per_transaction

Sets the maximum number of locks per transaction.

64

max_logical_replication_workers

Maximum number of logical replication worker processes.

–

max_parallel_maintenance_workers

Sets the maximum number of parallel processes per maintenance operation.

–

max_parallel_workers

Sets the maximum number of parallel workers than can be active at one time.

GREATEST($DBInstanceVCPU/2,8)

max_parallel_workers_per_gather

Sets the maximum number of parallel processes per executor node.

–

max_pred_locks_per_page

Sets the maximum number of predicate-locked tuples per page.

–

max_pred_locks_per_relation

Sets the maximum number of predicate-locked pages and tuples per relation.

–

max_pred_locks_per_transaction

Sets the maximum number of predicate locks per transaction.

–

max_prepared_transactions

Sets the maximum number of simultaneously prepared transactions.

0

max_replication_slots

Sets the maximum number of replication slots that the server can support.

20

max_slot_wal_keep_size

(MB) Replication slots will be marked as failed, and segments released for deletion or recycling, if this much space is occupied by WAL on disk.

–

max_stack_depth

(kB) Sets the maximum stack depth, in kilobytes.

6144

max_standby_streaming_delay

(ms) Sets the maximum delay before canceling queries when a hot standby server is processing streamed WAL data.

14000

max_sync_workers_per_subscription

Maximum number of synchronization workers per subscription

2

max_wal_senders

Sets the maximum number of simultaneously running WAL sender processes.

10

max_worker_processes

Sets the maximum number of concurrent worker processes.

GREATEST($DBInstanceVCPU*2,8)

min_dynamic_shared_memory

(MB) Amount of dynamic shared memory reserved at startup.

–

min_parallel_index_scan_size

(8kB) Sets the minimum amount of index data for a parallel scan.

–

min_parallel_table_scan_size

(8kB) Sets the minimum amount of table data for a parallel scan.

–

old_snapshot_threshold

(min) Time before a snapshot is too old to read pages changed after the snapshot was taken.

–

orafce.nls_date_format

Emulate oracles date output behaviour.

–

orafce.timezone

Specify timezone used for sysdate function.

–

parallel_leader_participation

Controls whether Gather and Gather Merge also run subplans.

–

parallel_setup_cost

Sets the planners estimate of the cost of starting up worker processes for parallel query.

–

parallel_tuple_cost

Sets the planners estimate of the cost of passing each tuple (row) from worker to master backend.

–

password_encryption

Encrypt passwords.

–

pgaudit.log

Specifies which classes of statements will be logged by session audit logging.

–

pgaudit.log_catalog

Specifies that session logging should be enabled in the case where all relations in a statement are in pg_catalog.

–

pgaudit.log_level

Specifies the log level that will be used for log entries.

–

pgaudit.log_parameter

Specifies that audit logging should include the parameters that were passed with the statement.

–

pgaudit.log_relation

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_statement_once

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

Specifies the master role to use for object audit logging.

–

pg_bigm.enable_recheck

It specifies whether to perform Recheck which is an internal process of full text search.

on

pg_bigm.gin_key_limit

It specifies the maximum number of 2-grams of the search keyword to be used for full text search.

0

pg_bigm.last_update

It reports the last updated date of the pg_bigm module.

2013.11.22

pg_bigm.similarity_limit

It specifies the minimum threshold used by the similarity search.

0.3

pg_hint_plan.debug_print

Logs results of hint parsing.

–

pg_hint_plan.enable_hint

Force planner to use plans specified in the hint comment preceding to the query.

–

pg_hint_plan.enable_hint_table

Force planner to not get hint by using table lookups.

–

pg_hint_plan.message_level

Message level of debug messages.

–

pg_hint_plan.parse_messages

Message level of parse errors.

–

pglogical.batch_inserts

Batch inserts if possible

–

pglogical.conflict_log_level

Sets log level used for logging resolved conflicts.

–

pglogical.conflict_resolution

Sets method used for conflict resolution for resolvable conflicts.

–

pglogical.extra_connection_options

connection options to add to all peer node connections

–

pglogical.synchronous_commit

pglogical specific synchronous commit value

–

pglogical.use_spi

Use SPI instead of low-level API for applying changes

–

pg_prewarm.autoprewarm

Starts the autoprewarm worker.

–

pg_prewarm.autoprewarm_interval

Sets the interval between dumps of shared buffers

–

pg_similarity.block_is_normalized

Sets if the result value is normalized or not.

–

pg_similarity.block_threshold

Sets the threshold used by the Block similarity function.

–

pg_similarity.block_tokenizer

Sets the tokenizer for Block similarity function.

–

pg_similarity.cosine_is_normalized

Sets if the result value is normalized or not.

–

pg_similarity.cosine_threshold

Sets the threshold used by the Cosine similarity function.

–

pg_similarity.cosine_tokenizer

Sets the tokenizer for Cosine similarity function.

–

pg_similarity.dice_is_normalized

Sets if the result value is normalized or not.

–

pg_similarity.dice_threshold

Sets the threshold used by the Dice similarity measure.

–

pg_similarity.dice_tokenizer

Sets the tokenizer for Dice similarity measure.

–

pg_similarity.euclidean_is_normalized

Sets if the result value is normalized or not.

–

pg_similarity.euclidean_threshold

Sets the threshold used by the Euclidean similarity measure.

–

pg_similarity.euclidean_tokenizer

Sets the tokenizer for Euclidean similarity measure.

–

pg_similarity.hamming_is_normalized

Sets if the result value is normalized or not.

–

pg_similarity.hamming_threshold

Sets the threshold used by the Block similarity metric.

–

pg_similarity.jaccard_is_normalized

Sets if the result value is normalized or not.

–

pg_similarity.jaccard_threshold

Sets the threshold used by the Jaccard similarity measure.

–

pg_similarity.jaccard_tokenizer

Sets the tokenizer for Jaccard similarity measure.

–

pg_similarity.jaro_is_normalized

Sets if the result value is normalized or not.

–

pg_similarity.jaro_threshold

Sets the threshold used by the Jaro similarity measure.

–

pg_similarity.jarowinkler_is_normalized

Sets if the result value is normalized or not.

–

pg_similarity.jarowinkler_threshold

Sets the threshold used by the Jarowinkler similarity measure.

–

pg_similarity.levenshtein_is_normalized

Sets if the result value is normalized or not.

–

pg_similarity.levenshtein_threshold

Sets the threshold used by the Levenshtein similarity measure.

–

pg_similarity.matching_is_normalized

Sets if the result value is normalized or not.

–

pg_similarity.matching_threshold

Sets the threshold used by the Matching Coefficient similarity measure.

–

pg_similarity.matching_tokenizer

Sets the tokenizer for Matching Coefficient similarity measure.

–

pg_similarity.mongeelkan_is_normalized

Sets if the result value is normalized or not.

–

pg_similarity.mongeelkan_threshold

Sets the threshold used by the Monge-Elkan similarity measure.

–

pg_similarity.mongeelkan_tokenizer

Sets the tokenizer for Monge-Elkan similarity measure.

–

pg_similarity.nw_gap_penalty

Sets the gap penalty used by the Needleman-Wunsch similarity measure.

–

pg_similarity.nw_is_normalized

Sets if the result value is normalized or not.

–

pg_similarity.nw_threshold

Sets the threshold used by the Needleman-Wunsch similarity measure.

–

pg_similarity.overlap_is_normalized

Sets if the result value is normalized or not.

–

pg_similarity.overlap_threshold

Sets the threshold used by the Overlap Coefficient similarity measure.

–

pg_similarity.overlap_tokenizer

Sets the tokenizer for Overlap Coefficientsimilarity measure.

–

pg_similarity.qgram_is_normalized

Sets if the result value is normalized or not.

–

pg_similarity.qgram_threshold

Sets the threshold used by the Q-Gram similarity measure.

–

pg_similarity.qgram_tokenizer

Sets the tokenizer for Q-Gram measure.

–

pg_similarity.swg_is_normalized

Sets if the result value is normalized or not.

–

pg_similarity.swg_threshold

Sets the threshold used by the Smith-Waterman-Gotoh similarity measure.

–

pg_similarity.sw_is_normalized

Sets if the result value is normalized or not.

–

pg_similarity.sw_threshold

Sets the threshold used by the Smith-Waterman similarity measure.

–

pg_stat_statements.max

Sets the maximum number of statements tracked by pg_stat_statements.

–

pg_stat_statements.save

Save pg_stat_statements statistics across server shutdowns.

–

pg_stat_statements.track

Selects which statements are tracked by pg_stat_statements.

–

pg_stat_statements.track_planning

Selects whether planning duration is tracked by pg_stat_statements.

–

pg_stat_statements.track_utility

Selects whether utility commands are tracked by pg_stat_statements.

–

plan_cache_mode

Controls the planner selection of custom or generic plan.

–

port

Sets the TCP port the server listens on.

EndPointPort

postgis.gdal_enabled_drivers

Enable or disable GDAL drivers used with PostGIS in Postgres 9.3.5 and above.

ENABLE_ALL

quote_all_identifiers

When generating SQL fragments, quote all identifiers.

–

random_page_cost

Sets the planners estimate of the cost of a nonsequentially fetched disk page.

–

rdkit.dice_threshold

Lower threshold of Dice similarity. Molecules with similarity lower than threshold are not similar by # operation.

–

rdkit.do_chiral_sss

Should stereochemistry be taken into account in substructure matching. If false, no stereochemistry information is used in substructure matches.

–

rdkit.tanimoto_threshold

Lower threshold of Tanimoto similarity. Molecules with similarity lower than threshold are not similar by % operation.

–

rds.accepted_password_auth_method

Force authentication for connections with password stored locally.

md5+scram

rds.adaptive_autovacuum

RDS parameter to enable/disable adaptive autovacuum.

1

rds.babelfish_status

RDS parameter to enable/disable Babelfish for Aurora PostgreSQL.

off

rds.enable_plan_management

Enable or disable the apg_plan_mgmt extension.

0

rds.extensions

List of extensions provided by RDS

address_standardizer, address_standardizer_data_us, apg_plan_mgmt, aurora_stat_utils, amcheck, autoinc, aws_commons, aws_ml, aws_s3, aws_lambda, bool_plperl, bloom, btree_gin, btree_gist, citext, cube, dblink, dict_int, dict_xsyn, earthdistance, fuzzystrmatch, hll, hstore, hstore_plperl, insert_username, intagg, intarray, ip4r, isn, jsonb_plperl, lo, log_fdw, ltree, moddatetime, old_snapshot, oracle_fdw, orafce, pgaudit, pgcrypto, pglogical, pgrouting, pgrowlocks, pgstattuple, pgtap, pg_bigm, pg_buffercache, pg_cron, pg_freespacemap, pg_hint_plan, pg_partman, pg_prewarm, pg_proctab, pg_repack, pg_similarity, pg_stat_statements, pg_trgm, pg_visibility, plcoffee, plls, plperl, plpgsql, plprofiler, pltcl, plv8, postgis, postgis_tiger_geocoder, postgis_raster, postgis_topology, postgres_fdw, prefix, rdkit, rds_tools, refint, sslinfo, tablefunc, tds_fdw, test_parser, tsm_system_rows, tsm_system_time, unaccent, uuid-ossp

rds.force_admin_logging_level

See log messages for RDS admin user actions in customer databases.

–

rds.force_autovacuum_logging_level

See log messages related to autovacuum operations.

WARNING

rds.force_ssl

Force SSL connections.

0

rds.global_db_rpo

(s) Recovery point objective threshold, in seconds, that blocks user commits when it is violated.

Important

This parameter is meant for Aurora PostgreSQL-based global databases. For a nonglobal database, leave it at the default value. For more information about using this parameter, see Managing RPOs for Aurora PostgreSQL–based global databases.

–

rds.logical_replication

Enables logical decoding.

0

rds.logically_replicate_unlogged_tables

Unlogged tables are logically replicated.

1

rds.log_retention_period

Amazon RDS will delete PostgreSQL log that are older than N minutes.

4320

rds.pg_stat_ramdisk_size

Size of the stats ramdisk in MB. A nonzero value will setup the ramdisk. This parameter is only available in Aurora PostgreSQL 14 and lower versions.

0

rds.rds_superuser_reserved_connections

Sets the number of connection slots reserved for rds_superusers.

2

rds.restrict_password_commands

restricts password-related commands to members of rds_password

–

rds.superuser_variables

List of superuser-only variables for which we elevate rds_superuser modification statements.

session_replication_role

recovery_init_sync_method

Sets the method for synchronizing the data directory before crash recovery.

syncfs

remove_temp_files_after_crash

Remove temporary files after backend crash.

0

restart_after_crash

Reinitialize server after backend crash.

–

row_security

Enable row security.

–

search_path

Sets the schema search order for names that are not schema-qualified.

–

seq_page_cost

Sets the planners estimate of the cost of a sequentially fetched disk page.

–

session_replication_role

Sets the sessions behavior for triggers and rewrite rules.

–

shared_buffers

(8kB) Sets the number of shared memory buffers used by the server.

SUM(DBInstanceClassMemory/12038,-50003)

shared_preload_libraries

Lists shared libraries to preload into server.

pg_stat_statements

ssl

Enables SSL connections.

1

ssl_ca_file

Location of the SSL server authority file.

/rdsdbdata/rds-metadata/ca-cert.pem

ssl_cert_file

Location of the SSL server certificate file.

/rdsdbdata/rds-metadata/server-cert.pem

ssl_ciphers

Sets the list of allowed TLS ciphers to be used on secure connections.

–

ssl_crl_dir

Location of the SSL certificate revocation list directory.

/rdsdbdata/rds-metadata/ssl_crl_dir/

ssl_key_file

Location of the SSL server private key file

/rdsdbdata/rds-metadata/server-key.pem

ssl_max_protocol_version

Sets the maximum SSL/TLS protocol version allowed

–

ssl_min_protocol_version

Sets the minimum SSL/TLS protocol version allowed

TLSv1.2

standard_conforming_strings

Causes ... strings to treat backslashes literally.

–

statement_timeout

(ms) Sets the maximum allowed duration of any statement.

–

stats_temp_directory

Writes temporary statistics files to the specified directory.

/rdsdbdata/db/pg_stat_tmp

superuser_reserved_connections

Sets the number of connection slots reserved for superusers.

3

synchronize_seqscans

Enable synchronized sequential scans.

–

synchronous_commit

Sets the current transactions synchronization level.

on

tcp_keepalives_count

Maximum number of TCP keepalive retransmits.

–

tcp_keepalives_idle

(s) Time between issuing TCP keepalives.

–

tcp_keepalives_interval

(s) Time between TCP keepalive retransmits.

–

temp_buffers

(8kB) Sets the maximum number of temporary buffers used by each session.

–

temp_file_limit

Constrains the total amount disk space in kilobytes that a given PostgreSQL process can use for temporary files, excluding space used for explicit temporary tables

-1

temp_tablespaces

Sets the tablespace(s) to use for temporary tables and sort files.

–

timezone

Sets the time zone for displaying and interpreting time stamps.

UTC

track_activities

Collects information about executing commands.

–

track_activity_query_size

Sets the size reserved for pg_stat_activity.current_query, in bytes.

4096

track_commit_timestamp

Collects transaction commit time.

–

track_counts

Collects statistics on database activity.

–

track_functions

Collects function-level statistics on database activity.

pl

track_io_timing

Collects timing statistics on database IO activity.

1

track_wal_io_timing

Collects timing statistics for WAL I/O activity.

–

transform_null_equals

Treats expr=NULL as expr IS NULL.

–

update_process_title

Updates the process title to show the active SQL command.

–

vacuum_cost_delay

(ms) Vacuum cost delay in milliseconds.

–

vacuum_cost_limit

Vacuum cost amount available before napping.

–

vacuum_cost_page_dirty

Vacuum cost for a page dirtied by vacuum.

–

vacuum_cost_page_hit

Vacuum cost for a page found in the buffer cache.

–

vacuum_cost_page_miss

Vacuum cost for a page not found in the buffer cache.

0

vacuum_defer_cleanup_age

Number of transactions by which VACUUM and HOT cleanup should be deferred, if any.

–

vacuum_failsafe_age

Age at which VACUUM should trigger failsafe to avoid a wraparound outage.

1200000000

vacuum_freeze_min_age

Minimum age at which VACUUM should freeze a table row.

–

vacuum_freeze_table_age

Age at which VACUUM should scan whole table to freeze tuples.

–

vacuum_multixact_failsafe_age

Multixact age at which VACUUM should trigger failsafe to avoid a wraparound outage.

1200000000

vacuum_multixact_freeze_min_age

Minimum age at which VACUUM should freeze a MultiXactId in a table row.

–

vacuum_multixact_freeze_table_age

Multixact age at which VACUUM should scan whole table to freeze tuples.

–

wal_buffers

(8kB) Sets the number of disk-page buffers in shared memory for WAL.

–

wal_receiver_create_temp_slot

Sets whether a WAL receiver should create a temporary replication slot if no permanent slot is configured.

0

wal_receiver_status_interval

(s) Sets the maximum interval between WAL receiver status reports to the primary.

–

wal_receiver_timeout

(ms) Sets the maximum wait time to receive data from the primary.

30000

wal_sender_timeout

(ms) Sets the maximum time to wait for WAL replication.

–

work_mem

(kB) Sets the maximum memory to be used for query workspaces.

–

xmlbinary

Sets how binary values are to be encoded in XML.

–

xmloption

Sets whether XML data in implicit parsing and serialization operations is to be considered as documents or content fragments.

–

Aurora PostgreSQL instance-level parameters

You can view the instance-level parameters available for a specific Aurora PostgreSQL version using the AWS Management console, the AWS CLI, or the Amazon RDS API. For information about viewing the parameters in an Aurora PostgreSQL DB parameter groups in the RDS console, see Viewing parameter values for a DB parameter group.

Some instance-level parameters aren't available in all versions and some are being deprecated. For information about viewing the parameters of a specific Aurora PostgreSQL version, see Viewing Aurora PostgreSQL DB cluster and DB parameters.

For example, the following table lists the parameters that apply to a specific DB instance in an Aurora PostgreSQL DB cluster. This list was generated by running the describe-db-parameters AWS CLI command with default.aurora-postgresql14 for the --db-parameter-group-name value.

For a listing of the DB cluster parameters for this same default DB parameter group, see Aurora PostgreSQL cluster-level parameters.

Parameter name

Description

Default

apg_enable_batch_mode_function_execution

Enables batch-mode functions to process sets of rows at a time.

–

apg_enable_correlated_any_transform

Enables the planner to transform correlated ANY Sublink (IN/NOT IN subquery to JOIN when possible.

–

apg_enable_function_migration

Enables the planner to migrate eligible scalar functions to the FROM clause.

–

apg_enable_not_in_transform

Enables the planner to transform NOT IN subquery to ANTI JOIN when possible.

–

apg_enable_remove_redundant_inner_joins

Enables the planner to remove redundant inner joins.

–

apg_enable_semijoin_push_down

Enables the use of semijoin filters for hash joins.

–

apg_plan_mgmt.capture_plan_baselines

Capture plan baseline mode. manual - enable plan capture for any SQL statement, off - disable plan capture, automatic - enable plan capture for for statements in pg_stat_statements that satisfy the eligibility criteria.

off

apg_plan_mgmt.max_databases

Sets the maximum number of databases that that may manage queries using apg_plan_mgmt.

10

apg_plan_mgmt.max_plans

Sets the maximum number of plans that may be cached by apg_plan_mgmt.

10000

apg_plan_mgmt.plan_retention_period

Maximum number of days since a plan was last_used before a plan will be automatically deleted.

32

apg_plan_mgmt.unapproved_plan_execution_threshold

Estimated total plan cost below which an Unapproved plan will be executed.

0

apg_plan_mgmt.use_plan_baselines

Use only approved or fixed plans for managed statements.

false

application_name

Sets the application name to be reported in statistics and logs.

–

aurora_compute_plan_id

Monitors query execution plans to detect the execution plans contributing to current database load and to track performance statistics of execution plans over time. For more information, see Monitoring query execution plans for Aurora PostgreSQL.

on

authentication_timeout

(s Sets the maximum allowed time to complete client authentication.

–

auto_explain.log_analyze

Use EXPLAIN ANALYZE for plan logging.

–

auto_explain.log_buffers

Log buffers usage.

–

auto_explain.log_format

EXPLAIN format to be used for plan logging.

–

auto_explain.log_min_duration

Sets the minimum execution time above which plans will be logged.

–

auto_explain.log_nested_statements

Log nested statements.

–

auto_explain.log_timing

Collect timing data, not just row counts.

–

auto_explain.log_triggers

Include trigger statistics in plans.

–

auto_explain.log_verbose

Use EXPLAIN VERBOSE for plan logging.

–

auto_explain.sample_rate

Fraction of queries to process.

–

babelfishpg_tds.listen_addresses

Sets the host name or IP address(es to listen TDS to.

*

babelfishpg_tds.tds_debug_log_level

Sets logging level in TDS, 0 disables logging

1

backend_flush_after

(8Kb Number of pages after which previously performed writes are flushed to disk.

–

bytea_output

Sets the output format for bytea.

–

check_function_bodies

Check function bodies during CREATE FUNCTION.

–

client_connection_check_interval

Sets the time interval between checks for disconnection while running queries.

–

client_min_messages

Sets the message levels that are sent to the client.

–

config_file

Sets the servers main configuration file.

/rdsdbdata/config/postgresql.conf

constraint_exclusion

Enables the planner to use constraints to optimize queries.

–

cpu_index_tuple_cost

Sets the planners estimate of the cost of processing each index entry during an index scan.

–

cpu_operator_cost

Sets the planners estimate of the cost of processing each operator or function call.

–

cpu_tuple_cost

Sets the planners estimate of the cost of processing each tuple (row.

–

cron.database_name

Sets the database to store pg_cron metadata tables

postgres

cron.log_run

Log all jobs runs into the job_run_details table

on

cron.log_statement

Log all cron statements prior to execution.

off

cron.max_running_jobs

Maximum number of jobs that can run concurrently.

5

cron.use_background_workers

Enables background workers for pg_cron

on

cursor_tuple_fraction

Sets the planners estimate of the fraction of a cursors rows that will be retrieved.

–

db_user_namespace

Enables per-database user names.

–

deadlock_timeout

(ms Sets the time to wait on a lock before checking for deadlock.

–

debug_pretty_print

Indents parse and plan tree displays.

–

debug_print_parse

Logs each querys parse tree.

–

debug_print_plan

Logs each querys execution plan.

–

debug_print_rewritten

Logs each querys rewritten parse tree.

–

default_statistics_target

Sets the default statistics target.

–

default_transaction_deferrable

Sets the default deferrable status of new transactions.

–

default_transaction_isolation

Sets the transaction isolation level of each new transaction.

–

default_transaction_read_only

Sets the default read-only status of new transactions.

–

effective_cache_size

(8kB Sets the planners assumption about the size of the disk cache.

SUM(DBInstanceClassMemory/12038,-50003

effective_io_concurrency

Number of simultaneous requests that can be handled efficiently by the disk subsystem.

–

enable_async_append

Enables the planners use of async append plans.

–

enable_bitmapscan

Enables the planners use of bitmap-scan plans.

–

enable_gathermerge

Enables the planners use of gather merge plans.

–

enable_hashagg

Enables the planners use of hashed aggregation plans.

–

enable_hashjoin

Enables the planners use of hash join plans.

–

enable_incremental_sort

Enables the planners use of incremental sort steps.

–

enable_indexonlyscan

Enables the planners use of index-only-scan plans.

–

enable_indexscan

Enables the planners use of index-scan plans.

–

enable_material

Enables the planners use of materialization.

–

enable_memoize

Enables the planners use of memoization

–

enable_mergejoin

Enables the planners use of merge join plans.

–

enable_nestloop

Enables the planners use of nested-loop join plans.

–

enable_parallel_append

Enables the planners use of parallel append plans.

–

enable_parallel_hash

Enables the planners user of parallel hash plans.

–

enable_partition_pruning

Enable plan-time and run-time partition pruning.

–

enable_partitionwise_aggregate

Enables partitionwise aggregation and grouping.

–

enable_partitionwise_join

Enables partitionwise join.

–

enable_seqscan

Enables the planners use of sequential-scan plans.

–

enable_sort

Enables the planners use of explicit sort steps.

–

enable_tidscan

Enables the planners use of TID scan plans.

–

escape_string_warning

Warn about backslash escapes in ordinary string literals.

–

exit_on_error

Terminate session on any error.

–

force_parallel_mode

Forces use of parallel query facilities.

–

from_collapse_limit

Sets the FROM-list size beyond which subqueries are not collapsed.

–

geqo

Enables genetic query optimization.

–

geqo_effort

GEQO: effort is used to set the default for other GEQO parameters.

–

geqo_generations

GEQO: number of iterations of the algorithm.

–

geqo_pool_size

GEQO: number of individuals in the population.

–

geqo_seed

GEQO: seed for random path selection.

–

geqo_selection_bias

GEQO: selective pressure within the population.

–

geqo_threshold

Sets the threshold of FROM items beyond which GEQO is used.

–

gin_fuzzy_search_limit

Sets the maximum allowed result for exact search by GIN.

–

gin_pending_list_limit

(kB Sets the maximum size of the pending list for GIN index.

–

hash_mem_multiplier

Multiple of work_mem to use for hash tables.

–

hba_file

Sets the servers hba configuration file.

/rdsdbdata/config/pg_hba.conf

hot_standby_feedback

Allows feedback from a hot standby to the primary that will avoid query conflicts.

on

ident_file

Sets the servers ident configuration file.

/rdsdbdata/config/pg_ident.conf

idle_in_transaction_session_timeout

(ms Sets the maximum allowed duration of any idling transaction.

86400000

idle_session_timeout

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

–

join_collapse_limit

Sets the FROM-list size beyond which JOIN constructs are not flattened.

–

lc_messages

Sets the language in which messages are displayed.

–

listen_addresses

Sets the host name or IP address(es to listen to.

*

lo_compat_privileges

Enables backward compatibility mode for privilege checks on large objects.

0

log_connections

Logs each successful connection.

–

log_destination

Sets the destination for server log output.

stderr

log_directory

Sets the destination directory for log files.

/rdsdbdata/log/error

log_disconnections

Logs end of a session, including duration.

–

log_duration

Logs the duration of each completed SQL statement.

–

log_error_verbosity

Sets the verbosity of logged messages.

–

log_executor_stats

Writes executor performance statistics to the server log.

–

log_file_mode

Sets the file permissions for log files.

0644

log_filename

Sets the file name pattern for log files.

postgresql.log.%Y-%m-%d-%H%M

logging_collector

Start a subprocess to capture stderr output and/or csvlogs into log files.

1

log_hostname

Logs the host name in the connection logs.

0

logical_decoding_work_mem

(kB This much memory can be used by each internal reorder buffer before spilling to disk.

–

log_line_prefix

Controls information prefixed to each log line.

%t:%r:%u@%d:%p]:

log_lock_waits

Logs long lock waits.

–

log_min_duration_sample

(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

(ms Sets the minimum execution time above which statements will be logged.

–

log_min_error_statement

Causes all statements generating error at or above this level to be logged.

–

log_min_messages

Sets the message levels that are logged.

–

log_parameter_max_length

(B When logging statements, limit logged parameter values to first N bytes.

–

log_parameter_max_length_on_error

(B When reporting an error, limit logged parameter values to first N bytes.

–

log_parser_stats

Writes parser performance statistics to the server log.

–

log_planner_stats

Writes planner performance statistics to the server log.

–

log_replication_commands

Logs each replication command.

–

log_rotation_age

(min Automatic log file rotation will occur after N minutes.

60

log_rotation_size

(kB Automatic log file rotation will occur after N kilobytes.

100000

log_statement

Sets the type of statements logged.

–

log_statement_sample_rate

Fraction of statements exceeding log_min_duration_sample to be logged.

–

log_statement_stats

Writes cumulative performance statistics to the server log.

–

log_temp_files

(kB Log the use of temporary files larger than this number of kilobytes.

–

log_timezone

Sets the time zone to use in log messages.

UTC

log_truncate_on_rotation

Truncate existing log files of same name during log rotation.

0

maintenance_io_concurrency

A variant of effective_io_concurrency that is used for maintenance work.

1

maintenance_work_mem

(kB Sets the maximum memory to be used for maintenance operations.

GREATEST(DBInstanceClassMemory/63963136*1024,65536

max_connections

Sets the maximum number of concurrent connections.

LEAST(DBInstanceClassMemory/9531392,5000

max_files_per_process

Sets the maximum number of simultaneously open files for each server process.

–

max_locks_per_transaction

Sets the maximum number of locks per transaction.

64

max_parallel_maintenance_workers

Sets the maximum number of parallel processes per maintenance operation.

–

max_parallel_workers

Sets the maximum number of parallel workers than can be active at one time.

GREATEST($DBInstanceVCPU/2,8

max_parallel_workers_per_gather

Sets the maximum number of parallel processes per executor node.

–

max_pred_locks_per_page

Sets the maximum number of predicate-locked tuples per page.

–

max_pred_locks_per_relation

Sets the maximum number of predicate-locked pages and tuples per relation.

–

max_pred_locks_per_transaction

Sets the maximum number of predicate locks per transaction.

–

max_slot_wal_keep_size

(MB Replication slots will be marked as failed, and segments released for deletion or recycling, if this much space is occupied by WAL on disk.

–

max_stack_depth

(kB Sets the maximum stack depth, in kilobytes.

6144

max_standby_streaming_delay

(ms Sets the maximum delay before canceling queries when a hot standby server is processing streamed WAL data.

14000

max_worker_processes

Sets the maximum number of concurrent worker processes.

GREATEST($DBInstanceVCPU*2,8

min_dynamic_shared_memory

(MB Amount of dynamic shared memory reserved at startup.

–

min_parallel_index_scan_size

(8kB Sets the minimum amount of index data for a parallel scan.

–

min_parallel_table_scan_size

(8kB Sets the minimum amount of table data for a parallel scan.

–

old_snapshot_threshold

(min Time before a snapshot is too old to read pages changed after the snapshot was taken.

–

parallel_leader_participation

Controls whether Gather and Gather Merge also run subplans.

–

parallel_setup_cost

Sets the planners estimate of the cost of starting up worker processes for parallel query.

–

parallel_tuple_cost

Sets the planners estimate of the cost of passing each tuple (row from worker to master backend.

–

pgaudit.log

Specifies which classes of statements will be logged by session audit logging.

–

pgaudit.log_catalog

Specifies that session logging should be enabled in the case where all relations in a statement are in pg_catalog.

–

pgaudit.log_level

Specifies the log level that will be used for log entries.

–

pgaudit.log_parameter

Specifies that audit logging should include the parameters that were passed with the statement.

–

pgaudit.log_relation

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_statement_once

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

Specifies the master role to use for object audit logging.

–

pg_bigm.enable_recheck

It specifies whether to perform Recheck which is an internal process of full text search.

on

pg_bigm.gin_key_limit

It specifies the maximum number of 2-grams of the search keyword to be used for full text search.

0

pg_bigm.last_update

It reports the last updated date of the pg_bigm module.

2013.11.22

pg_bigm.similarity_limit

It specifies the minimum threshold used by the similarity search.

0.3

pg_hint_plan.debug_print

Logs results of hint parsing.

–

pg_hint_plan.enable_hint

Force planner to use plans specified in the hint comment preceding to the query.

–

pg_hint_plan.enable_hint_table

Force planner to not get hint by using table lookups.

–

pg_hint_plan.message_level

Message level of debug messages.

–

pg_hint_plan.parse_messages

Message level of parse errors.

–

pglogical.batch_inserts

Batch inserts if possible

–

pglogical.conflict_log_level

Sets log level used for logging resolved conflicts.

–

pglogical.conflict_resolution

Sets method used for conflict resolution for resolvable conflicts.

–

pglogical.extra_connection_options

connection options to add to all peer node connections

–

pglogical.synchronous_commit

pglogical specific synchronous commit value

–

pglogical.use_spi

Use SPI instead of low-level API for applying changes

–

pg_similarity.block_is_normalized

Sets if the result value is normalized or not.

–

pg_similarity.block_threshold

Sets the threshold used by the Block similarity function.

–

pg_similarity.block_tokenizer

Sets the tokenizer for Block similarity function.

–

pg_similarity.cosine_is_normalized

Sets if the result value is normalized or not.

–

pg_similarity.cosine_threshold

Sets the threshold used by the Cosine similarity function.

–

pg_similarity.cosine_tokenizer

Sets the tokenizer for Cosine similarity function.

–

pg_similarity.dice_is_normalized

Sets if the result value is normalized or not.

–

pg_similarity.dice_threshold

Sets the threshold used by the Dice similarity measure.

–

pg_similarity.dice_tokenizer

Sets the tokenizer for Dice similarity measure.

–

pg_similarity.euclidean_is_normalized

Sets if the result value is normalized or not.

–

pg_similarity.euclidean_threshold

Sets the threshold used by the Euclidean similarity measure.

–

pg_similarity.euclidean_tokenizer

Sets the tokenizer for Euclidean similarity measure.

–

pg_similarity.hamming_is_normalized

Sets if the result value is normalized or not.

–

pg_similarity.hamming_threshold

Sets the threshold used by the Block similarity metric.

–

pg_similarity.jaccard_is_normalized

Sets if the result value is normalized or not.

–

pg_similarity.jaccard_threshold

Sets the threshold used by the Jaccard similarity measure.

–

pg_similarity.jaccard_tokenizer

Sets the tokenizer for Jaccard similarity measure.

–

pg_similarity.jaro_is_normalized

Sets if the result value is normalized or not.

–

pg_similarity.jaro_threshold

Sets the threshold used by the Jaro similarity measure.

–

pg_similarity.jarowinkler_is_normalized

Sets if the result value is normalized or not.

–

pg_similarity.jarowinkler_threshold

Sets the threshold used by the Jarowinkler similarity measure.

–

pg_similarity.levenshtein_is_normalized

Sets if the result value is normalized or not.

–

pg_similarity.levenshtein_threshold

Sets the threshold used by the Levenshtein similarity measure.

–

pg_similarity.matching_is_normalized

Sets if the result value is normalized or not.

–

pg_similarity.matching_threshold

Sets the threshold used by the Matching Coefficient similarity measure.

–

pg_similarity.matching_tokenizer

Sets the tokenizer for Matching Coefficient similarity measure.

–

pg_similarity.mongeelkan_is_normalized

Sets if the result value is normalized or not.

–

pg_similarity.mongeelkan_threshold

Sets the threshold used by the Monge-Elkan similarity measure.

–

pg_similarity.mongeelkan_tokenizer

Sets the tokenizer for Monge-Elkan similarity measure.

–

pg_similarity.nw_gap_penalty

Sets the gap penalty used by the Needleman-Wunsch similarity measure.

–

pg_similarity.nw_is_normalized

Sets if the result value is normalized or not.

–

pg_similarity.nw_threshold

Sets the threshold used by the Needleman-Wunsch similarity measure.

–

pg_similarity.overlap_is_normalized

Sets if the result value is normalized or not.

–

pg_similarity.overlap_threshold

Sets the threshold used by the Overlap Coefficient similarity measure.

–

pg_similarity.overlap_tokenizer

Sets the tokenizer for Overlap Coefficientsimilarity measure.

–

pg_similarity.qgram_is_normalized

Sets if the result value is normalized or not.

–

pg_similarity.qgram_threshold

Sets the threshold used by the Q-Gram similarity measure.

–

pg_similarity.qgram_tokenizer

Sets the tokenizer for Q-Gram measure.

–

pg_similarity.swg_is_normalized

Sets if the result value is normalized or not.

–

pg_similarity.swg_threshold

Sets the threshold used by the Smith-Waterman-Gotoh similarity measure.

–

pg_similarity.sw_is_normalized

Sets if the result value is normalized or not.

–

pg_similarity.sw_threshold

Sets the threshold used by the Smith-Waterman similarity measure.

–

pg_stat_statements.max

Sets the maximum number of statements tracked by pg_stat_statements.

–

pg_stat_statements.save

Save pg_stat_statements statistics across server shutdowns.

–

pg_stat_statements.track

Selects which statements are tracked by pg_stat_statements.

–

pg_stat_statements.track_planning

Selects whether planning duration is tracked by pg_stat_statements.

–

pg_stat_statements.track_utility

Selects whether utility commands are tracked by pg_stat_statements.

–

postgis.gdal_enabled_drivers

Enable or disable GDAL drivers used with PostGIS in Postgres 9.3.5 and above.

ENABLE_ALL

quote_all_identifiers

When generating SQL fragments, quote all identifiers.

–

random_page_cost

Sets the planners estimate of the cost of a nonsequentially fetched disk page.

–

rds.enable_memory_management

Improves memory management capabilities in Aurora PostgreSQL 12.17, 13.13, 14.10, 15.5, and higher versions that prevents stability issues and database restarts caused by insufficient free memory. For more information, see Improved memory management in Aurora PostgreSQL.

True

rds.force_admin_logging_level

See log messages for RDS admin user actions in customer databases.

–

rds.log_retention_period

Amazon RDS will delete PostgreSQL log that are older than N minutes.

4320

rds.memory_allocation_guard

Improves memory management capabilities in Aurora PostgreSQL 11.21, 12.16, 13.12, 14.9, 15.4, and older versions that prevents stability issues and database restarts caused by insufficient free memory. For more information, see Improved memory management in Aurora PostgreSQL.

False

rds.pg_stat_ramdisk_size

Size of the stats ramdisk in MB. A nonzero value will setup the ramdisk.

0

rds.rds_superuser_reserved_connections

Sets the number of connection slots reserved for rds_superusers.

2

rds.superuser_variables

List of superuser-only variables for which we elevate rds_superuser modification statements.

session_replication_role

remove_temp_files_after_crash

Remove temporary files after backend crash.

0

restart_after_crash

Reinitialize server after backend crash.

–

row_security

Enable row security.

–

search_path

Sets the schema search order for names that are not schema-qualified.

–

seq_page_cost

Sets the planners estimate of the cost of a sequentially fetched disk page.

–

session_replication_role

Sets the sessions behavior for triggers and rewrite rules.

–

shared_buffers

(8kB Sets the number of shared memory buffers used by the server.

SUM(DBInstanceClassMemory/12038,-50003

shared_preload_libraries

Lists shared libraries to preload into server.

pg_stat_statements

ssl_ca_file

Location of the SSL server authority file.

/rdsdbdata/rds-metadata/ca-cert.pem

ssl_cert_file

Location of the SSL server certificate file.

/rdsdbdata/rds-metadata/server-cert.pem

ssl_crl_dir

Location of the SSL certificate revocation list directory.

/rdsdbdata/rds-metadata/ssl_crl_dir/

ssl_key_file

Location of the SSL server private key file

/rdsdbdata/rds-metadata/server-key.pem

standard_conforming_strings

Causes ... strings to treat backslashes literally.

–

statement_timeout

(ms Sets the maximum allowed duration of any statement.

–

stats_temp_directory

Writes temporary statistics files to the specified directory.

/rdsdbdata/db/pg_stat_tmp

superuser_reserved_connections

Sets the number of connection slots reserved for superusers.

3

synchronize_seqscans

Enable synchronized sequential scans.

–

tcp_keepalives_count

Maximum number of TCP keepalive retransmits.

–

tcp_keepalives_idle

(s Time between issuing TCP keepalives.

–

tcp_keepalives_interval

(s Time between TCP keepalive retransmits.

–

temp_buffers

(8kB Sets the maximum number of temporary buffers used by each session.

–

temp_file_limit

Constrains the total amount disk space in kilobytes that a given PostgreSQL process can use for temporary files, excluding space used for explicit temporary tables

-1

temp_tablespaces

Sets the tablespace(s to use for temporary tables and sort files.

–

track_activities

Collects information about executing commands.

–

track_activity_query_size

Sets the size reserved for pg_stat_activity.current_query, in bytes.

4096

track_counts

Collects statistics on database activity.

–

track_functions

Collects function-level statistics on database activity.

pl

track_io_timing

Collects timing statistics on database IO activity.

1

transform_–_equals

Treats expr=– as expr IS –.

–

update_process_title

Updates the process title to show the active SQL command.

–

wal_receiver_status_interval

(s Sets the maximum interval between WAL receiver status reports to the primary.

–

work_mem

(kB Sets the maximum memory to be used for query workspaces.

–

xmlbinary

Sets how binary values are to be encoded in XML.

–

xmloption

Sets whether XML data in implicit parsing and serialization operations is to be considered as documents or content fragments.

–