Created
October 19, 2023 16:30
-
-
Save ronaldbradford/fe7f8180277a5a48fba21f979cc08129 to your computer and use it in GitHub Desktop.
RDS PostgreSQL 15.4 Configuration Settings via psql
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name | setting | |
| -------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
| allow_in_place_tablespaces | off | |
| allow_system_table_mods | off | |
| ansi_constraint_trigger_ordering | off | |
| ansi_force_foreign_key_checks | off | |
| ansi_qualified_update_set_target | off | |
| apg_buffer_invalid_lookup_strategy | on | |
| apg_enable_batch_mode_function_execution | on | |
| apg_enable_correlated_any_transform | off | |
| apg_enable_function_migration | on | |
| apg_enable_logical_skip_aborted_txn | on | |
| apg_enable_not_in_transform | on | |
| apg_enable_remove_redundant_inner_joins | off | |
| apg_enable_semijoin_push_down | off | |
| apg_force_full_key_semijoin | off | |
| apg_force_semijoin_push_down | off | |
| apg_force_single_key_semijoin | off | |
| apg_write_forward.connect_timeout | 30 | |
| apg_write_forward.consistency_mode | session | |
| apg_write_forward.idle_in_transaction_session_timeout | 86400000 | |
| apg_write_forward.idle_session_timeout | 300000 | |
| apg_write_forward.max_forwarding_connections_percent | 25 | |
| application_name | psql | |
| archive_cleanup_command | | |
| archive_command | (disabled) | |
| archive_library | rds_archive | |
| archive_mode | off | |
| archive_timeout | 300 | |
| array_nulls | on | |
| async_notifications_cache_size | 8 | |
| authentication_timeout | 60 | |
| autovacuum | on | |
| autovacuum_analyze_scale_factor | 0.05 | |
| autovacuum_analyze_threshold | 50 | |
| autovacuum_freeze_max_age | 200000000 | |
| autovacuum_max_workers | 3 | |
| autovacuum_multixact_freeze_max_age | 400000000 | |
| autovacuum_naptime | 5 | |
| autovacuum_vacuum_cost_delay | 5 | |
| autovacuum_vacuum_cost_limit | 600 | |
| autovacuum_vacuum_insert_scale_factor | 0.2 | |
| autovacuum_vacuum_insert_threshold | 1000 | |
| autovacuum_vacuum_scale_factor | 0.1 | |
| autovacuum_vacuum_threshold | 50 | |
| autovacuum_work_mem | 1223360 | |
| backend_flush_after | 0 | |
| backslash_quote | safe_encoding | |
| backtrace_functions | | |
| bgwriter_delay | 200 | |
| bgwriter_flush_after | 64 | |
| bgwriter_lru_maxpages | 100 | |
| bgwriter_lru_multiplier | 2 | |
| block_size | 8192 | |
| bonjour | off | |
| bonjour_name | | |
| buffer_cache_mode | dynamic | |
| buffer_table_mode | dynamic | |
| bytea_output | hex | |
| check_function_bodies | on | |
| checkpoint_completion_target | 0.9 | |
| checkpoint_flush_after | 32 | |
| checkpoint_timeout | 60 | |
| checkpoint_warning | 30 | |
| client_connection_check_interval | 0 | |
| client_encoding | UTF8 | |
| client_min_messages | notice | |
| cluster_name | | |
| commit_delay | 0 | |
| commit_siblings | 5 | |
| commit_timestamp_cache_size | 16 | |
| compute_query_id | auto | |
| config_file | /rdsdbdata/config/postgresql.conf | |
| constraint_exclusion | partition | |
| cpu_index_tuple_cost | 0.005 | |
| cpu_operator_cost | 0.0025 | |
| cpu_tuple_cost | 0.01 | |
| cursor_tuple_fraction | 0.1 | |
| data_checksums | off | |
| data_directory | /rdsdbdata/db | |
| data_directory_mode | 0700 | |
| data_sync_retry | off | |
| database_instance_type | serverless | |
| DateStyle | ISO, MDY | |
| db_user_namespace | off | |
| deadlock_timeout | 1000 | |
| debug_assertions | off | |
| debug_discard_caches | 0 | |
| debug_pretty_print | on | |
| debug_print_parse | off | |
| debug_print_plan | off | |
| debug_print_rewritten | off | |
| default_statistics_target | 100 | |
| default_table_access_method | heap | |
| default_tablespace | | |
| default_text_search_config | pg_catalog.simple | |
| default_toast_compression | pglz | |
| default_transaction_deferrable | off | |
| default_transaction_isolation | read committed | |
| default_transaction_read_only | off | |
| dynamic_library_path | $libdir | |
| dynamic_shared_memory_type | posix | |
| effective_cache_size | 3280040 | |
| effective_io_concurrency | 256 | |
| enable_async_append | on | |
| enable_bitmapscan | on | |
| enable_gathermerge | on | |
| enable_hashagg | on | |
| enable_hashjoin | on | |
| enable_incremental_sort | on | |
| enable_indexonlyscan | on | |
| enable_indexscan | on | |
| enable_material | on | |
| enable_memoize | on | |
| enable_mergejoin | on | |
| enable_nestloop | on | |
| enable_parallel_append | on | |
| enable_parallel_hash | on | |
| enable_partition_pruning | on | |
| enable_partitionwise_aggregate | off | |
| enable_partitionwise_join | off | |
| enable_seqscan | on | |
| enable_sort | on | |
| enable_tidscan | on | |
| escape_string_warning | on | |
| event_source | PostgreSQL | |
| eventpoints_mode | off | |
| exit_on_error | off | |
| external_pid_file | | |
| extra_float_digits | 1 | |
| force_parallel_mode | off | |
| from_collapse_limit | 8 | |
| fsync | on | |
| full_page_writes | off | |
| geqo | on | |
| geqo_effort | 5 | |
| geqo_generations | 0 | |
| geqo_pool_size | 0 | |
| geqo_seed | 0 | |
| geqo_selection_bias | 2 | |
| geqo_threshold | 12 | |
| gin_fuzzy_search_limit | 0 | |
| gin_pending_list_limit | 4096 | |
| hash_mem_multiplier | 2 | |
| hba_file | /rdsdbdata/config/pg_hba.conf | |
| hot_standby | off | |
| hot_standby_feedback | on | |
| huge_page_size | 0 | |
| huge_pages | on | |
| ident_file | /rdsdbdata/config/pg_ident.conf | |
| idle_in_transaction_session_timeout | 86400000 | |
| idle_session_timeout | 0 | |
| ignore_checksum_failure | off | |
| ignore_invalid_pages | off | |
| ignore_system_indexes | off | |
| in_hot_standby | off | |
| integer_datetimes | on | |
| IntervalStyle | postgres | |
| jit | off | |
| jit_above_cost | 100000 | |
| jit_debugging_support | off | |
| jit_dump_bitcode | off | |
| jit_expressions | on | |
| jit_inline_above_cost | 500000 | |
| jit_optimize_above_cost | 500000 | |
| jit_profiling_support | off | |
| jit_provider | llvmjit | |
| jit_tuple_deforming | on | |
| join_collapse_limit | 8 | |
| krb_caseins_users | off | |
| krb_server_keyfile | /rdsdbdata/config/keytab | |
| lc_collate | en_US.UTF-8 | |
| lc_ctype | en_US.UTF-8 | |
| lc_messages | | |
| lc_monetary | C | |
| lc_numeric | C | |
| lc_time | C | |
| listen_addresses | * | |
| lo_compat_privileges | off | |
| local_preload_libraries | | |
| lock_timeout | 0 | |
| log_autovacuum_min_duration | 10000 | |
| log_checkpoints | off | |
| log_connections | off | |
| log_destination | stderr | |
| log_directory | /rdsdbdata/log/error | |
| log_disconnections | off | |
| log_duration | off | |
| log_error_verbosity | default | |
| log_executor_stats | off | |
| log_file_mode | 0644 | |
| log_filename | postgresql.log.%Y-%m-%d-%H%M | |
| log_hostname | off | |
| log_line_prefix | %t:%r:%u@%d:[%p]: | |
| log_lock_waits | off | |
| log_min_duration_sample | -1 | |
| log_min_duration_statement | -1 | |
| log_min_error_statement | error | |
| log_min_messages | warning | |
| log_parameter_max_length | -1 | |
| log_parameter_max_length_on_error | 0 | |
| log_parser_stats | off | |
| log_planner_stats | off | |
| log_replication_commands | off | |
| log_rotation_age | 60 | |
| log_rotation_size | 100000 | |
| log_startup_progress_interval | 10000 | |
| log_statement | none | |
| log_statement_sample_rate | 1 | |
| log_statement_stats | off | |
| log_temp_files | -1 | |
| log_timezone | UTC | |
| log_transaction_sample_rate | 0 | |
| log_truncate_on_rotation | off | |
| logging_collector | on | |
| logical_decoding_work_mem | 65536 | |
| maintenance_io_concurrency | 1 | |
| maintenance_work_mem | 641024 | |
| max_connections | 2000 | |
| max_files_per_process | 1000 | |
| max_function_args | 100 | |
| max_identifier_length | 63 | |
| max_index_keys | 32 | |
| max_locks_per_transaction | 64 | |
| max_logical_replication_workers | 4 | |
| max_parallel_maintenance_workers | 2 | |
| max_parallel_workers | 8 | |
| max_parallel_workers_per_gather | 2 | |
| max_pred_locks_per_page | 2 | |
| max_pred_locks_per_relation | -2 | |
| max_pred_locks_per_transaction | 64 | |
| max_prepared_transactions | 0 | |
| max_replication_slots | 20 | |
| max_slot_wal_keep_size | -1 | |
| max_stack_depth | 6144 | |
| max_standby_archive_delay | 30000 | |
| max_standby_streaming_delay | 14000 | |
| max_sync_workers_per_subscription | 2 | |
| max_wal_senders | 20 | |
| max_wal_size | 1024 | |
| max_worker_processes | 10 | |
| min_dynamic_shared_memory | 0 | |
| min_parallel_index_scan_size | 64 | |
| min_parallel_table_scan_size | 1024 | |
| min_wal_size | 512 | |
| multixact_members_cache_size | 16 | |
| multixact_offsets_cache_size | 8 | |
| old_snapshot_threshold | -1 | |
| parallel_leader_participation | on | |
| parallel_setup_cost | 1000 | |
| parallel_tuple_cost | 0.1 | |
| password_encryption | scram-sha-256 | |
| pg_stat_statements.max | 5000 | |
| pg_stat_statements.save | on | |
| pg_stat_statements.track | top | |
| pg_stat_statements.track_planning | off | |
| pg_stat_statements.track_utility | on | |
| plan_cache_mode | auto | |
| port | 5432 | |
| post_auth_delay | 0 | |
| pre_auth_delay | 0 | |
| primary_slot_name | | |
| promote_trigger_file | | |
| quote_all_identifiers | off | |
| random_page_cost | 4 | |
| rds.allowed_extensions | * | |
| rds.blue_green_block_restricted_commands | off | |
| rds.blue_green_monitoring | none | |
| rds.check_execution_context | on | |
| rds.check_extension_connections | on | |
| rds.enable_delayed_hot_standby_locking | on | |
| rds.enable_global_db_rpo | on | |
| rds.enable_global_db_rpo_abort_commits_at_rpo_limit | off | |
| rds.enable_rsdl_counters | on | |
| rds.extensions | address_standardizer, address_standardizer_data_us, amcheck, apg_plan_mgmt, aurora_stat_utils, autoinc, aws_commons, aws_lambda, aws_ml, aws_s3, babelfishpg_common, babelfishpg_money, babelfishpg_tds, babelfishpg_telemetry, babelfishpg_tsql, bloom, bool_plperl, 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, mysql_fdw, old_snapshot, oracle_fdw, orafce, 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_tle, pg_trgm, pg_visibility, pg_walinspect, pgaudit, pgcrypto, pglogical, pglogical_origin, pgrouting, pgrowlocks, pgstattuple, pgtap, plcoffee, plls, plperl, plpgsql, plprofiler, pltcl, plv8, postgis, postgis_raster, postgis_tiger_geocoder, postgis_topology, postgres_fdw, prefix, rdkit, rds_activity_stream, rds_tools, refint, seg, sslinfo, tablefunc, tcn, tds_fdw, tsm_system_rows, tsm_system_time, unaccent, uuid-ossp, vector | |
| rds.fast_forward_test_lock_all_overlay | off | |
| rds.force_admin_logging_level | disabled | |
| rds.force_autovacuum_logging_level | warning | |
| rds.global_db_rpo | -1 | |
| rds.internal_databases | rdsadmin | |
| rds.local_volume_spill_enabled | on | |
| rds.logical_decoding_work_disk | -1 | |
| rds.logical_replication | off | |
| rds.logical_slot_prefetch_max | 32 | |
| rds.logical_wal_cache | 0 | |
| rds.logically_replicate_unlogged_tables | off | |
| rds.max_rsdl_counters_entries | 5000 | |
| rds.max_stored_credentials | 10 | |
| rds.memory_allocation_guard | off | |
| rds.persist_standby_wal | off | |
| rds.rds_superuser_reserved_connections | 2 | |
| rds.rdsadmin_max_connections | 100 | |
| rds.restrict_logical_slot_creation | off | |
| rds.restrict_password_commands | off | |
| rds.restrict_subconninfo | off | |
| rds.rsdl_counters_dealloc_percent | 5 | |
| rds.standby_resource_conflict_probe_delay | 40000 | |
| rds.superuser_variables | session_replication_role | |
| rds.survivable_global_readers | on | |
| rds.survivable_readers | on | |
| rds.survivable_readers_stale_replica_reconnect | on | |
| rds.tablespace_path_prefix | /rdsdbdata/db/base/tablespace | |
| rds.temp_tablespaces | rds_temp_tablespace,aurora_temp_tablespace | |
| rds.tidal_htap_support | off | |
| rds_stat_connections.max | 5000 | |
| rds_stat_connections.max_sl | 1000 | |
| recovery_end_command | | |
| recovery_init_sync_method | syncfs | |
| recovery_min_apply_delay | 0 | |
| recovery_prefetch | off | |
| recovery_target | | |
| recovery_target_action | pause | |
| recovery_target_inclusive | on | |
| recovery_target_lsn | | |
| recovery_target_name | | |
| recovery_target_time | | |
| recovery_target_timeline | latest | |
| recovery_target_xid | | |
| recursive_worktable_factor | 10 | |
| remove_temp_files_after_crash | off | |
| restart_after_crash | on | |
| restore_command | | |
| row_security | on | |
| search_path | "$user", public | |
| segment_size | 131072 | |
| seq_page_cost | 1 | |
| server_encoding | UTF8 | |
| server_version | 15.4 | |
| server_version_num | 150004 | |
| session_preload_libraries | | |
| session_replication_role | origin | |
| shared_buffers | 16384 | |
| shared_memory_size | 9290 | |
| shared_memory_size_in_huge_pages | 4646 | |
| shared_memory_type | mmap | |
| shared_preload_libraries | rdsutils,pg_stat_statements,writeforward | |
| slru_cache_mode | on | |
| ssl | on | |
| ssl_ca_file | /rdsdbdata/rds-metadata/ca-cert.pem | |
| ssl_cert_file | /rdsdbdata/rds-metadata/server-cert.pem | |
| ssl_ciphers | TLS_RSA_WITH_AES_128_CBC_SHA256:TLS_RSA_WITH_AES_128_GCM_SHA256:ECDHE-RSA-AES128-SHA:DHE-RSA-AES256-GCM-SHA384:TLS_RSA_WITH_AES_256_GCM_SHA384:DHE-RSA-AES128-GCM-SHA256:TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA:ECDHE-RSA-AES256-SHA384:TLS_RSA_WITH_AES_256_CBC_SHA:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-RSA-AES128-SHA256:DHE-RSA-AES256-SHA:ECDHE-ECDSA-AES256-GCM-SHA384:TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256:DHE-RSA-AES128-SHA256:TLS_ECDHE_RSA_WITH_CHACHA20_POLY1305_SHA256:TLS_RSA_WITH_AES_128_CBC_SHA:TLS_ECDHE_ECDSA_WITH_AES_256_GCM_SHA384:DHE-RSA-AES128-SHA:TLS_AES_128_GCM_SHA256:TLS_AES_256_GCM_SHA384:DHE-RSA-AES256-SHA256:TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256:ECDHE-RSA-AES256-GCM-SHA384:TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA:ECDHE-RSA-AES256-SHA:TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 | |
| ssl_crl_dir | /rdsdbdata/rds-metadata/ssl_crl_dir/ | |
| ssl_crl_file | | |
| ssl_dh_params_file | | |
| ssl_ecdh_curve | prime256v1 | |
| ssl_key_file | /rdsdbdata/rds-metadata/server-key.pem | |
| ssl_library | OpenSSL | |
| ssl_max_protocol_version | TLSv1.3 | |
| ssl_min_protocol_version | TLSv1.2 | |
| ssl_passphrase_command | | |
| ssl_passphrase_command_supports_reload | off | |
| ssl_prefer_server_ciphers | on | |
| standard_conforming_strings | on | |
| statement_timeout | 0 | |
| stats_fetch_consistency | cache | |
| subtrans_cache_size | 32 | |
| superuser_reserved_connections | 3 | |
| survivable_cache_mode | on | |
| synchronize_seqscans | on | |
| synchronous_commit | on | |
| synchronous_standby_names | | |
| syslog_facility | local0 | |
| syslog_ident | postgres | |
| syslog_sequence_numbers | on | |
| syslog_split_messages | on | |
| tcp_keepalives_count | 2 | |
| tcp_keepalives_idle | 300 | |
| tcp_keepalives_interval | 30 | |
| tcp_user_timeout | 0 | |
| temp_buffers | 1024 | |
| temp_file_limit | -1 | |
| temp_tablespaces | | |
| TimeZone | UTC | |
| timezone_abbreviations | Default | |
| trace_notify | off | |
| trace_recovery_messages | log | |
| trace_sort | off | |
| track_activities | on | |
| track_activity_query_size | 4096 | |
| track_commit_timestamp | off | |
| track_counts | on | |
| track_functions | pl | |
| track_io_timing | on | |
| track_wal_io_timing | off | |
| transaction_deferrable | off | |
| transaction_isolation | read committed | |
| transaction_read_only | off | |
| transform_null_equals | off | |
| unix_socket_directories | /tmp | |
| unix_socket_group | rdsdb | |
| unix_socket_permissions | 0706 | |
| update_process_title | on | |
| vacuum_cost_delay | 0 | |
| vacuum_cost_limit | 200 | |
| vacuum_cost_page_dirty | 20 | |
| vacuum_cost_page_hit | 1 | |
| vacuum_cost_page_miss | 0 | |
| vacuum_defer_cleanup_age | 0 | |
| vacuum_failsafe_age | 1200000000 | |
| vacuum_freeze_min_age | 50000000 | |
| vacuum_freeze_table_age | 150000000 | |
| vacuum_multixact_failsafe_age | 1200000000 | |
| vacuum_multixact_freeze_min_age | 5000000 | |
| vacuum_multixact_freeze_table_age | 150000000 | |
| wal_block_size | 8192 | |
| wal_buffers | -1 | |
| wal_compression | off | |
| wal_consistency_checking | | |
| wal_decode_buffer_size | 524288 | |
| wal_init_zero | on | |
| wal_keep_size | 0 | |
| wal_level | replica | |
| wal_log_hints | off | |
| wal_receiver_create_temp_slot | off | |
| wal_receiver_status_interval | 10 | |
| wal_receiver_timeout | 30000 | |
| wal_recycle | on | |
| wal_retrieve_retry_interval | 5000 | |
| wal_segment_size | 67108864 | |
| wal_sender_timeout | 60000 | |
| wal_skip_threshold | 2048 | |
| wal_sync_method | fdatasync | |
| wal_writer_delay | 200 | |
| wal_writer_flush_after | 128 | |
| work_mem | 4096 | |
| xmlbinary | base64 | |
| xmloption | content | |
| zero_damaged_pages | off | |
| (426 rows) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment