diff options
Diffstat (limited to 't/9.0.conf')
| -rw-r--r-- | t/9.0.conf | 178 |
1 files changed, 178 insertions, 0 deletions
diff --git a/t/9.0.conf b/t/9.0.conf new file mode 100644 index 0000000..27b18f2 --- /dev/null +++ b/t/9.0.conf @@ -0,0 +1,178 @@ +external_pid_file = '(none)' +listen_addresses = 'localhost' +port = 5432 +max_connections = 100 +superuser_reserved_connections = 3 +unix_socket_directory = '' +unix_socket_group = '' +unix_socket_permissions = 0777 +bonjour = off +bonjour_name = '' +authentication_timeout = 1min +ssl = off +ssl_ciphers = 'ALL:!ADH:!LOW:!EXP:!MD5:@STRENGTH' +ssl_renegotiation_limit = 512MB +password_encryption = on +db_user_namespace = off +krb_server_keyfile = '' +krb_srvname = 'postgres' +krb_caseins_users = off +tcp_keepalives_idle = 0 +tcp_keepalives_interval = 0 +tcp_keepalives_count = 0 +shared_buffers = 24MB +temp_buffers = 8MB +max_prepared_transactions = 0 +work_mem = 1MB +maintenance_work_mem = 16MB +max_stack_depth = 2MB +max_files_per_process = 1000 +shared_preload_libraries = '' +vacuum_cost_delay = 0ms +vacuum_cost_page_hit = 1 +vacuum_cost_page_miss = 10 +vacuum_cost_page_dirty = 20 +vacuum_cost_limit = 200 +bgwriter_delay = 200ms +bgwriter_lru_maxpages = 100 +bgwriter_lru_multiplier = 2.0 +effective_io_concurrency = 1 +wal_level = minimal +fsync = on +synchronous_commit = on +wal_sync_method = fsync +full_page_writes = on +wal_buffers = 64kB +wal_writer_delay = 200ms +commit_delay = 0 +commit_siblings = 5 +checkpoint_segments = 3 +checkpoint_timeout = 5min +checkpoint_completion_target = 0.5 +checkpoint_warning = 30s +archive_mode = off +archive_command = '' +archive_timeout = 0 +max_wal_senders = 0 +wal_sender_delay = 200ms +wal_keep_segments = 0 +vacuum_defer_cleanup_age = 0 +hot_standby = off +max_standby_archive_delay = 30s +max_standby_streaming_delay = 30s +enable_bitmapscan = on +enable_hashagg = on +enable_hashjoin = on +enable_indexscan = on +enable_material = on +enable_mergejoin = on +enable_nestloop = on +enable_seqscan = on +enable_sort = on +enable_tidscan = on +seq_page_cost = 1.0 +random_page_cost = 4.0 +cpu_tuple_cost = 0.01 +cpu_index_tuple_cost = 0.005 +cpu_operator_cost = 0.0025 +effective_cache_size = 128MB +geqo = on +geqo_threshold = 12 +geqo_effort = 5 +geqo_pool_size = 0 +geqo_generations = 0 +geqo_selection_bias = 2.0 +geqo_seed = 0.0 +default_statistics_target = 100 +constraint_exclusion = partition +cursor_tuple_fraction = 0.1 +from_collapse_limit = 8 +join_collapse_limit = 8 +log_destination = 'stderr' +logging_collector = off +log_directory = 'pg_log' +log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' +log_truncate_on_rotation = off +log_rotation_age = 1d +log_rotation_size = 10MB +syslog_facility = 'LOCAL0' +syslog_ident = 'postgres' +silent_mode = off +client_min_messages = notice +log_min_messages = warning +log_min_error_statement = error +log_min_duration_statement = -1 +debug_print_parse = off +debug_print_rewritten = off +debug_print_plan = off +debug_pretty_print = on +log_checkpoints = off +log_connections = off +log_disconnections = off +log_duration = off +log_error_verbosity = default +log_hostname = off +log_line_prefix = '' +log_lock_waits = off +log_statement = 'none' +log_temp_files = -1 +log_timezone = 'Europe/Berlin' +track_activities = on +track_counts = on +track_functions = none +track_activity_query_size = 1024 +update_process_title = on +stats_temp_directory = '/var/run/postgresql/9.0-main.pg_stat_tmp' +log_parser_stats = off +log_planner_stats = off +log_executor_stats = off +log_statement_stats = off +autovacuum = on +log_autovacuum_min_duration = -1 +autovacuum_max_workers = 3 +autovacuum_naptime = 1min +autovacuum_vacuum_threshold = 50 +autovacuum_analyze_threshold = 50 +autovacuum_vacuum_scale_factor = 0.2 +autovacuum_analyze_scale_factor = 0.1 +autovacuum_freeze_max_age = 200000000 +autovacuum_vacuum_cost_delay = 20ms +autovacuum_vacuum_cost_limit = -1 +search_path = '"$user",public' +default_tablespace = '' +temp_tablespaces = '' +check_function_bodies = on +default_transaction_isolation = 'read committed' +default_transaction_read_only = off +session_replication_role = 'origin' +statement_timeout = 0 +vacuum_freeze_min_age = 50000000 +vacuum_freeze_table_age = 150000000 +bytea_output = 'hex' +xmlbinary = 'base64' +xmloption = 'content' +datestyle = 'iso, mdy' +intervalstyle = 'postgres' +timezone = 'Europe/Berlin' +timezone_abbreviations = 'Default' +extra_float_digits = 0 +client_encoding = sql_ascii +lc_messages = 'C' +lc_monetary = 'C' +lc_numeric = 'C' +lc_time = 'C' +default_text_search_config = 'pg_catalog.simple' +dynamic_library_path = '$libdir' +local_preload_libraries = '' +deadlock_timeout = 1s +max_locks_per_transaction = 64 +array_nulls = on +backslash_quote = safe_encoding +default_with_oids = off +escape_string_warning = on +lo_compat_privileges = off +sql_inheritance = on +standard_conforming_strings = off +synchronize_seqscans = on +transform_null_equals = off +custom_variable_classes = '' |