Autovacuum | autovacuum | on |
| autovacuum_analyze_scale_factor | 0.1 |
| autovacuum_analyze_threshold | 50 |
| autovacuum_freeze_max_age | 200000000 |
| autovacuum_max_workers | 3 |
| autovacuum_naptime | 60 |
| autovacuum_vacuum_cost_delay | 20 |
| autovacuum_vacuum_cost_limit | -1 |
| autovacuum_vacuum_scale_factor | 0.2 |
| autovacuum_vacuum_threshold | 50 |
Client Connection Defaults / Locale and Formatting | client_encoding | UTF8 |
| DateStyle | ISO, MDY |
| default_text_search_config | pg_catalog.english |
| extra_float_digits | 0 |
| IntervalStyle | postgres |
| lc_messages | English_United States.1252 |
| lc_monetary | English_United States.1252 |
| lc_numeric | English_United States.1252 |
| lc_time | English_United States.1252 |
| TimeZone | Asia/Kuala_Lumpur |
| timezone_abbreviations | Default |
Client Connection Defaults / Other Defaults | dynamic_library_path | $libdir |
| gin_fuzzy_search_limit | 0 |
| local_preload_libraries | |
| tcp_keepalives_count | 0 |
| tcp_keepalives_idle | -1 |
| tcp_keepalives_interval | -1 |
Client Connection Defaults / Statement Behavior | bytea_output | hex |
| check_function_bodies | on |
| default_tablespace | |
| default_transaction_deferrable | off |
| default_transaction_isolation | read committed |
| default_transaction_read_only | off |
| lock_timeout | 0 |
| search_path | "$user",public |
| session_replication_role | origin |
| statement_timeout | 0 |
| temp_tablespaces | |
| transaction_deferrable | off |
| transaction_isolation | read committed |
| transaction_read_only | off |
| vacuum_freeze_min_age | 50000000 |
| vacuum_freeze_table_age | 150000000 |
| xmlbinary | base64 |
| xmloption | content |
Connections and Authentication / Connection Settings | bonjour | off |
| bonjour_name | |
| listen_addresses | * |
| max_connections | 100 |
| port | 5433 |
| superuser_reserved_connections | 3 |
| unix_socket_directories | |
| unix_socket_group | |
| unix_socket_permissions | 0777 |
Connections and Authentication / Security and Authentication | authentication_timeout | 60 |
| db_user_namespace | off |
| krb_caseins_users | off |
| krb_server_keyfile | |
| krb_srvname | postgres |
| password_encryption | on |
| ssl | off |
| ssl_ca_file | |
| ssl_cert_file | server.crt |
| ssl_ciphers | DEFAULT:!LOW:!EXP:!MD5:@STRENGTH |
| ssl_crl_file | |
| ssl_key_file | server.key |
| ssl_renegotiation_limit | 524288 |
Developer Options | allow_system_table_mods | off |
| debug_assertions | off |
| ignore_checksum_failure | off |
| ignore_system_indexes | off |
| post_auth_delay | 0 |
| pre_auth_delay | 0 |
| trace_notify | off |
| trace_recovery_messages | log |
| trace_sort | off |
| zero_damaged_pages | off |
Error Handling | exit_on_error | off |
| restart_after_crash | on |
File Locations | config_file | E:/Program Files/PostgreSQL/9.3/data/postgresql.conf |
| data_directory | E:/Program Files/PostgreSQL/9.3/data |
| external_pid_file | |
| hba_file | E:/Program Files/PostgreSQL/9.3/data/pg_hba.conf |
| ident_file | E:/Program Files/PostgreSQL/9.3/data/pg_ident.conf |
Lock Management | deadlock_timeout | 1000 |
| max_locks_per_transaction | 256 |
| max_pred_locks_per_transaction | 64 |
Query Tuning / Genetic Query Optimizer | geqo | on |
| geqo_effort | 5 |
| geqo_generations | 0 |
| geqo_pool_size | 0 |
| geqo_seed | 0 |
| geqo_selection_bias | 2 |
| geqo_threshold | 12 |
Query Tuning / Other Planner Options | constraint_exclusion | partition |
| cursor_tuple_fraction | 0.1 |
| default_statistics_target | 100 |
| from_collapse_limit | 8 |
| join_collapse_limit | 8 |
Query Tuning / Planner Cost Constants | cpu_index_tuple_cost | 0.005 |
| cpu_operator_cost | 0.0025 |
| cpu_tuple_cost | 0.01 |
| effective_cache_size | 16384 |
| random_page_cost | 4 |
| seq_page_cost | 1 |
Query Tuning / Planner Method Configuration | 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 |
Replication / Master Server | synchronous_standby_names | |
| vacuum_defer_cleanup_age | 0 |
Replication / Sending Servers | max_wal_senders | 0 |
| wal_keep_segments | 0 |
| wal_sender_timeout | 60000 |
Replication / Standby Servers | hot_standby | off |
| hot_standby_feedback | off |
| max_standby_archive_delay | 30000 |
| max_standby_streaming_delay | 30000 |
| wal_receiver_status_interval | 10 |
| wal_receiver_timeout | 60000 |
Reporting and Logging / What to Log | application_name | |
| debug_pretty_print | on |
| debug_print_parse | off |
| debug_print_plan | off |
| debug_print_rewritten | off |
| log_autovacuum_min_duration | -1 |
| log_checkpoints | off |
| log_connections | off |
| log_disconnections | off |
| log_duration | off |
| log_error_verbosity | default |
| log_hostname | off |
| log_line_prefix | %t |
| log_lock_waits | off |
| log_statement | none |
| log_temp_files | -1 |
| log_timezone | Asia/Kuala_Lumpur |
Reporting and Logging / When to Log | client_min_messages | notice |
| log_min_duration_statement | -1 |
| log_min_error_statement | error |
| log_min_messages | warning |
Reporting and Logging / Where to Log | event_source | PostgreSQL |
| log_destination | stderr |
| log_directory | pg_log |
| log_file_mode | 0600 |
| log_filename | postgresql-%Y-%m-%d_%H%M%S.log |
| log_rotation_age | 1440 |
| log_rotation_size | 10240 |
| log_truncate_on_rotation | off |
| logging_collector | on |
| syslog_facility | none |
| syslog_ident | postgres |
Resource Usage / Background Writer | bgwriter_delay | 200 |
| bgwriter_lru_maxpages | 100 |
| bgwriter_lru_multiplier | 2 |
Resource Usage / Cost-Based Vacuum Delay | vacuum_cost_delay | 0 |
| vacuum_cost_limit | 200 |
| vacuum_cost_page_dirty | 20 |
| vacuum_cost_page_hit | 1 |
| vacuum_cost_page_miss | 10 |
Resource Usage / Disk | temp_file_limit | -1 |
Resource Usage / Kernel Resources | max_files_per_process | 1000 |
| shared_preload_libraries | |
Resource Usage / Memory | maintenance_work_mem | 16384 |
| max_prepared_transactions | 0 |
| max_stack_depth | 2048 |
| shared_buffers | 16384 |
| temp_buffers | 1024 |
| track_activity_query_size | 1024 |
| work_mem | 1024 |
Statistics / Monitoring | log_executor_stats | off |
| log_parser_stats | off |
| log_planner_stats | off |
| log_statement_stats | off |
Statistics / Query and Index Statistics Collector | stats_temp_directory | pg_stat_tmp |
| track_activities | on |
| track_counts | on |
| track_functions | none |
| track_io_timing | off |
| update_process_title | on |
Version and Platform Compatibility / Other Platforms and Clients | transform_null_equals | off |
Version and Platform Compatibility / Previous PostgreSQL Versions | array_nulls | on |
| backslash_quote | safe_encoding |
| default_with_oids | off |
| escape_string_warning | on |
| lo_compat_privileges | off |
| quote_all_identifiers | off |
| sql_inheritance | on |
| standard_conforming_strings | on |
| synchronize_seqscans | on |
Write-Ahead Log / Archiving | archive_command | (disabled) |
| archive_mode | off |
| archive_timeout | 0 |
Write-Ahead Log / Checkpoints | checkpoint_completion_target | 0.5 |
| checkpoint_segments | 3 |
| checkpoint_timeout | 300 |
| checkpoint_warning | 30 |
Write-Ahead Log / Settings | commit_delay | 0 |
| commit_siblings | 5 |
| fsync | on |
| full_page_writes | on |
| synchronous_commit | on |
| wal_buffers | 512 |
| wal_level | minimal |
| wal_sync_method | open_datasync |
| wal_writer_delay | 200 |