Created
November 16, 2013 02:35
-
-
Save snaga/7495184 to your computer and use it in GitHub Desktop.
postgresql.conf @ RDS for PostgreSQL
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
| testdb=> SELECT name,setting,unit FROM pg_settings; | |
| name | setting | unit | |
| ---------------------------------+---------------------------------------------+------ | |
| allow_system_table_mods | off | | |
| application_name | psql | | |
| archive_command | /etc/rds/dbbin/pgscripts/rds_wal_archive %p | | |
| archive_mode | on | | |
| archive_timeout | 300 | s | |
| array_nulls | on | | |
| authentication_timeout | 60 | s | |
| autovacuum | on | | |
| autovacuum_analyze_scale_factor | 0.1 | | |
| autovacuum_analyze_threshold | 50 | | |
| autovacuum_freeze_max_age | 200000000 | | |
| autovacuum_max_workers | 3 | | |
| autovacuum_naptime | 60 | s | |
| autovacuum_vacuum_cost_delay | 20 | ms | |
| autovacuum_vacuum_cost_limit | -1 | | |
| autovacuum_vacuum_scale_factor | 0.2 | | |
| autovacuum_vacuum_threshold | 50 | | |
| backslash_quote | safe_encoding | | |
| bgwriter_delay | 200 | ms | |
| bgwriter_lru_maxpages | 100 | | |
| bgwriter_lru_multiplier | 2 | | |
| block_size | 8192 | | |
| bonjour | off | | |
| bonjour_name | | | |
| bytea_output | hex | | |
| check_function_bodies | on | | |
| checkpoint_completion_target | 0.9 | | |
| checkpoint_segments | 16 | | |
| checkpoint_timeout | 300 | s | |
| checkpoint_warning | 30 | s | |
| client_encoding | SQL_ASCII | | |
| client_min_messages | warning | | |
| commit_delay | 0 | | |
| commit_siblings | 5 | | |
| constraint_exclusion | partition | | |
| cpu_index_tuple_cost | 0.005 | | |
| cpu_operator_cost | 0.0025 | | |
| cpu_tuple_cost | 0.01 | | |
| cursor_tuple_fraction | 0.1 | | |
| DateStyle | ISO, MDY | | |
| db_user_namespace | off | | |
| deadlock_timeout | 1000 | ms | |
| debug_assertions | off | | |
| debug_pretty_print | on | | |
| debug_print_parse | off | | |
| debug_print_plan | off | | |
| debug_print_rewritten | off | | |
| default_statistics_target | 100 | | |
| default_tablespace | | | |
| default_text_search_config | pg_catalog.simple | | |
| default_transaction_deferrable | off | | |
| default_transaction_isolation | read committed | | |
| default_transaction_read_only | off | | |
| default_with_oids | off | | |
| effective_cache_size | 464296 | 8kB | |
| effective_io_concurrency | 1 | | |
| enable_bitmapscan | on | | |
| enable_hashagg | on | | |
| enable_hashjoin | on | | |
| enable_indexonlyscan | on | | |
| enable_indexscan | on | | |
| enable_material | on | | |
| enable_mergejoin | on | | |
| enable_nestloop | on | | |
| enable_seqscan | on | | |
| enable_sort | on | | |
| enable_tidscan | on | | |
| escape_string_warning | on | | |
| event_source | PostgreSQL | | |
| exit_on_error | off | | |
| extra_float_digits | 0 | | |
| from_collapse_limit | 8 | | |
| fsync | on | | |
| full_page_writes | on | | |
| 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 | | |
| hot_standby | off | | |
| hot_standby_feedback | off | | |
| ignore_checksum_failure | off | | |
| ignore_system_indexes | off | | |
| integer_datetimes | on | | |
| IntervalStyle | postgres | | |
| join_collapse_limit | 8 | | |
| krb_caseins_users | off | | |
| krb_srvname | postgres | | |
| lc_collate | C | | |
| lc_ctype | C | | |
| lc_messages | | | |
| lc_monetary | C | | |
| lc_numeric | C | | |
| lc_time | C | | |
| listen_addresses | * | | |
| lo_compat_privileges | off | | |
| local_preload_libraries | | | |
| lock_timeout | 0 | ms | |
| log_autovacuum_min_duration | -1 | ms | |
| log_checkpoints | on | | |
| log_connections | off | | |
| log_destination | stderr | | |
| log_disconnections | off | | |
| log_duration | off | | |
| log_error_verbosity | default | | |
| log_executor_stats | off | | |
| log_file_mode | 0644 | | |
| log_hostname | on | | |
| log_line_prefix | %t:%r:%u@%d:[%p]: | | |
| log_lock_waits | off | | |
| log_min_duration_statement | -1 | ms | |
| log_min_error_statement | error | | |
| log_min_messages | warning | | |
| log_parser_stats | off | | |
| log_planner_stats | off | | |
| log_rotation_age | 60 | min | |
| log_rotation_size | 10240 | kB | |
| log_statement | none | | |
| log_statement_stats | off | | |
| log_temp_files | -1 | kB | |
| log_timezone | UTC | | |
| log_truncate_on_rotation | off | | |
| logging_collector | on | | |
| maintenance_work_mem | 16384 | kB | |
| max_connections | 604 | | |
| max_files_per_process | 1000 | | |
| max_function_args | 100 | | |
| max_identifier_length | 63 | | |
| max_index_keys | 32 | | |
| max_locks_per_transaction | 64 | | |
| max_pred_locks_per_transaction | 64 | | |
| max_prepared_transactions | 0 | | |
| max_stack_depth | 6144 | kB | |
| max_standby_archive_delay | 30000 | ms | |
| max_standby_streaming_delay | 30000 | ms | |
| max_wal_senders | 0 | | |
| password_encryption | on | | |
| plpgsql.variable_conflict | error | | |
| port | 5432 | | |
| post_auth_delay | 0 | s | |
| postgis.backend | geos | | |
| pre_auth_delay | 0 | s | |
| quote_all_identifiers | off | | |
| random_page_cost | 4 | | |
| restart_after_crash | on | | |
| search_path | "$user",public | | |
| segment_size | 131072 | 8kB | |
| seq_page_cost | 1 | | |
| server_encoding | UTF8 | | |
| server_version | 9.3.1 | | |
| server_version_num | 90301 | | |
| session_replication_role | origin | | |
| shared_buffers | 232148 | 8kB | |
| sql_inheritance | on | | |
| ssl | on | | |
| ssl_ca_file | /rdsdbdata/rds-metadata/ca-cert.pem | | |
| ssl_cert_file | /rdsdbdata/rds-metadata/server-cert.pem | | |
| ssl_crl_file | | | |
| ssl_key_file | /rdsdbdata/rds-metadata/server-key.pem | | |
| ssl_renegotiation_limit | 524288 | kB | |
| standard_conforming_strings | on | | |
| statement_timeout | 0 | ms | |
| superuser_reserved_connections | 3 | | |
| synchronize_seqscans | on | | |
| synchronous_commit | on | | |
| synchronous_standby_names | | | |
| syslog_facility | local0 | | |
| syslog_ident | postgres | | |
| tcp_keepalives_count | 2 | | |
| tcp_keepalives_idle | 300 | s | |
| tcp_keepalives_interval | 30 | s | |
| temp_buffers | 1024 | 8kB | |
| temp_file_limit | -1 | kB | |
| temp_tablespaces | | | |
| TimeZone | UTC | | |
| timezone_abbreviations | Default | | |
| trace_notify | off | | |
| trace_recovery_messages | log | | |
| trace_sort | off | | |
| track_activities | on | | |
| track_activity_query_size | 1024 | | |
| track_counts | on | | |
| track_functions | none | | |
| track_io_timing | off | | |
| transaction_deferrable | off | | |
| transaction_isolation | read committed | | |
| transaction_read_only | off | | |
| transform_null_equals | off | | |
| unix_socket_group | rdsdb | | |
| unix_socket_permissions | 0700 | | |
| update_process_title | on | | |
| vacuum_cost_delay | 0 | ms | |
| vacuum_cost_limit | 200 | | |
| vacuum_cost_page_dirty | 20 | | |
| vacuum_cost_page_hit | 1 | | |
| vacuum_cost_page_miss | 10 | | |
| vacuum_defer_cleanup_age | 0 | | |
| vacuum_freeze_min_age | 50000000 | | |
| vacuum_freeze_table_age | 150000000 | | |
| wal_block_size | 8192 | | |
| wal_buffers | 2048 | 8kB | |
| wal_keep_segments | 0 | | |
| wal_level | archive | | |
| wal_receiver_status_interval | 10 | s | |
| wal_receiver_timeout | 60000 | ms | |
| wal_segment_size | 2048 | 8kB | |
| wal_sender_timeout | 60000 | ms | |
| wal_sync_method | fdatasync | | |
| wal_writer_delay | 200 | ms | |
| work_mem | 1024 | kB | |
| xmlbinary | base64 | | |
| xmloption | content | | |
| zero_damaged_pages | off | | |
| (216 rows) | |
| testdb=> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment