github.com/1aal/kubeblocks@v0.0.0-20231107070852-e1c03e598921/test/testdata/cue_testdata/pg14.conf (about) 1 listen_addresses = '*' 2 port = '5432' 3 #archive_command = 'wal_dir=/pg/arcwal; [[ $(date +%H%M) == 1200 ]] && rm -rf ${wal_dir}/$(date -d"yesterday" +%Y%m%d); /bin/mkdir -p ${wal_dir}/$(date +%Y%m%d) && /usr/bin/lz4 -q -z %p > ${wal_dir}/$(date +%Y%m%d)/%f.lz4' 4 #archive_mode = 'True' 5 auto_explain.log_analyze = 'True' 6 auto_explain.log_min_duration = '1s' 7 auto_explain.log_nested_statements = 'True' 8 auto_explain.log_timing = 'True' 9 auto_explain.log_verbose = 'True' 10 autovacuum_analyze_scale_factor = '0.05' 11 autovacuum_freeze_max_age = '100000000' 12 autovacuum_max_workers = '1' 13 autovacuum_naptime = '1min' 14 autovacuum_vacuum_cost_delay = '-1' 15 autovacuum_vacuum_cost_limit = '-1' 16 autovacuum_vacuum_scale_factor = '0.1' 17 bgwriter_delay = '10ms' 18 bgwriter_lru_maxpages = '800' 19 bgwriter_lru_multiplier = '5.0' 20 checkpoint_completion_target = '0.95' 21 checkpoint_timeout = '10min' 22 citus.node_conninfo = 'sslmode=prefer' 23 cluster_name = 'prod-osm-pigsty000' 24 commit_delay = '20' 25 commit_siblings = '10' 26 deadlock_timeout = '50ms' 27 default_statistics_target = '500' 28 effective_cache_size = '12GB' 29 hot_standby = 'on' 30 hot_standby_feedback = 'True' 31 huge_pages = 'try' 32 idle_in_transaction_session_timeout = '1h' 33 listen_addresses = '0.0.0.0' 34 log_autovacuum_min_duration = '1s' 35 log_checkpoints = 'True' 36 log_destination = 'csvlog' 37 log_directory = 'log' 38 log_filename = 'postgresql-%Y-%m-%d.log' 39 log_lock_waits = 'True' 40 log_min_duration_statement = '100' 41 log_replication_commands = 'True' 42 log_statement = 'ddl' 43 logging_collector = 'True' 44 #maintenance_work_mem = '3952MB' 45 max_connections = '10000' 46 max_locks_per_transaction = '128' 47 max_logical_replication_workers = '8' 48 max_parallel_maintenance_workers = '2' 49 max_parallel_workers = '8' 50 max_parallel_workers_per_gather = '0' 51 max_prepared_transactions = '0' 52 max_replication_slots = '16' 53 max_standby_archive_delay = '10min' 54 max_standby_streaming_delay = '3min' 55 max_sync_workers_per_subscription = '6' 56 max_wal_senders = '24' 57 max_wal_size = '100GB' 58 max_worker_processes = '8' 59 min_wal_size = '20GB' 60 password_encryption = 'md5' 61 pg_stat_statements.max = '5000' 62 pg_stat_statements.track = 'all' 63 pg_stat_statements.track_planning = 'False' 64 pg_stat_statements.track_utility = 'False' 65 random_page_cost = '1.1' 66 #auto generated 67 shared_buffers = '1GB' 68 #shared_preload_libraries = 'timescaledb, pg_stat_statements, auto_explain' 69 superuser_reserved_connections = '10' 70 temp_file_limit = '100GB' 71 #timescaledb.max_background_workers = '6' 72 #timescaledb.telemetry_level = 'off' 73 track_activity_query_size = '8192' 74 track_commit_timestamp = 'True' 75 track_functions = 'all' 76 track_io_timing = 'True' 77 vacuum_cost_delay = '2ms' 78 vacuum_cost_limit = '10000' 79 vacuum_defer_cleanup_age = '50000' 80 wal_buffers = '16MB' 81 wal_keep_size = '20GB' 82 wal_level = 'replica' 83 wal_log_hints = 'on' 84 wal_receiver_status_interval = '1s' 85 wal_receiver_timeout = '60s' 86 wal_writer_delay = '20ms' 87 wal_writer_flush_after = '1MB' 88 work_mem = '32MB'