gs_guc reload -N all -I all -c "authentication_timeout=15s" && gs_guc reload -N all -I all -c "cstore_buffers = 32MB" && gs_guc reload -N all -I all -c "enable_alarm = off" && gs_guc reload -N all -I all -c "enable_delta_store = on" && gs_guc reload -N all -I all -c "enable_double_write = on" && gs_guc reload -N all -I all -c "enable_incremental_checkpoint = on" && gs_guc reload -N all -I all -c "enable_wdr_snapshot = off" && gs_guc reload -N all -I all -c "enable_xlog_prune = on" && gs_guc reload -N all -I all -c "log_min_duration_statement = 1s" && gs_guc reload -N all -I all -c "maintenance_work_mem=2GB" && gs_guc reload -N all -I all -c "max_connections = 2000" && gs_guc reload -N all -I all -c "max_files_per_process = 10000" && gs_guc reload -N all -I all -c "max_prepared_transactions = 2000" && gs_guc reload -N all -I all -c "modify_initial_password = off" && gs_guc reload -N all -I all -c "password_effect_time = 0" && gs_guc reload -N all -I all -c "password_lock_time = 0" && gs_guc reload -N all -I all -c "password_reuse_time=0" && gs_guc reload -N all -I all -c "password_min_digital=1" && gs_guc reload -N all -I all -c "password_min_length=8" && gs_guc reload -N all -I all -c "password_min_lowercase=1" && gs_guc reload -N all -I all -c "password_min_special=1" && gs_guc reload -N all -I all -c "password_min_uppercase=1" && gs_guc reload -N all -I all -c "password_policy=1" && gs_guc reload -N all -I all -c "session_timeout = 0" && gs_guc reload -N all -I all -c "shared_buffers = 20GB" && gs_guc reload -N all -I all -c "synchronous_commit = remote_receive" && gs_guc reload -N all -I all -c "temp_buffers = 1GB" && gs_guc reload -N all -I all -c "update_lockwait_timeout = 30s" && gs_guc reload -N all -I all -c "wal_buffers = 64MB" && gs_guc reload -N all -I all -c "wdr_snapshot_interval = 10min" && gs_guc reload -N all -I all -c "work_mem = 512MB" && gs_guc reload -N all -I all -c "log_temp_files = 100MB" && gs_guc reload -N all -I all -c "most_available_sync = ON" && gs_guc reload -N all -I all -c "enable_mergejoin = ON" && gs_guc reload -N all -I all -c "enable_nestloop = ON" && gs_guc reload -N all -I all -c "advance_xlog_file_num = 10" && gs_guc reload -N all -I all -c "pagewriter_sleep = 1000ms" && gs_guc reload -N all -I all -c "xloginsert_locks = 50" && gs_guc reload -N all -I all -c "lockwait_timeout = 30s" && gs_guc reload -N all -I all -c "enable_opfusion = off" && gs_guc reload -N all -I all -c "max_process_memory=60GB" && gs_guc reload -N all -I all -c "log_file_mode = 0755" && gs_guc reload -N all -I all -c "catchup2normal_wait_time = 0" && gs_guc reload -N all -I all -c "audit_enabled=on" && gs_guc reload -N all -I all -c "audit_resource_policy=on" && gs_guc reload -N all -I all -c "audit_space_limit=10GB" && gs_guc reload -N all -I all -c "audit_set_parameter=0" && gs_guc reload -N all -I all -c "audit_system_object=524287" && gs_guc reload -N all -I all -c "audit_grant_revoke=1" && gs_guc reload -N all -I all -c "audit_database_process=1" && gs_guc reload -N all -I all -c "audit_user_locked=1" && gs_guc reload -N all -I all -c "audit_login_logout=2" && gs_guc reload -N all -I all -c "max_size_for_xlog_prune=10GB" && gs_guc reload -N all -I all -c "wal_sender_timeout=180s" && gs_guc reload -N all -I all -c "wal_receiver_timeout=180s" && gs_guc reload -N all -I all -c "log_hostname=off" && gs_guc reload -N all -I all -c "instr_unique_sql_count=20000" && gs_guc reload -N all -I all -c "track_activity_query_size=10240" && gs_guc reload -N all -I all -c "enable_asp=on" && gs_guc reload -N all -I all -c "listen_addresses='*'" && gs_guc reload -N all -I all -c "wal_keep_segments=640" && gs_guc reload -N all -I all -c "pagewriter_sleep=500ms" && gs_guc reload -N all -I all -c "bgwriter_delay=1s" && gs_guc reload -N all -I all -c "enable_auto_clean_unique_sql=on" && gs_guc reload -N all -I all -c "autoanalyze_timeout=1200" && gs_guc reload -N all -I all -c "autovacuum_max_workers=10" && gs_guc reload -N all -I all -c "autovacuum_naptime=300" && gs_guc reload -N all -I all -c "autovacuum_vacuum_threshold=1000" && gs_guc reload -N all -I all -c "autovacuum_analyze_threshold=1000" && gs_guc reload -N all -I all -c "autovacuum_vacuum_scale_factor=0.05" && gs_guc reload -N all -I all -c "autovacuum_vacuum_cost_delay=0" && gs_guc reload -N all -I all -c "autovacuum_vacuum_cost_limit=10000" && gs_guc reload -N all -I all -c "vacuum_cost_delay=0" && gs_guc reload -N all -I all -c "vacuum_cost_limit=10000" && gs_guc reload -N all -I all -c "log_lock_waits=on" && gs_guc reload -N all -I all -c "wal_level=logical" && gs_guc reload -I all -N all -c "enable_recyclebin=on" && gs_guc reload -I all -N all -c "recyclebin_retention_time=3600" && gs_guc reload -I all -N all -c "undo_space_limit_size=256GB" && gs_guc reload -I all -N all -c "undo_limit_size_per_transaction=32GB" && gs_guc reload -I all -N all -c "enable_ustore=off" && gs_guc reload -I all -N all -c "recovery_max_workers=4" && gs_guc reload -I all -N all -c "local_syscache_threshold=32MB" && gs_guc reload -I all -N all -c "idle_in_transaction_session_timeout=3600" && gs_guc reload -I all -N all -c "enable_save_confirmed_lsn=on" && gs_guc reload -I all -N all -c "hot standby = off" &&
gs_guc reload -I all -N all -c "enable_double_write = off" &&
gs_guc reload -I all -N all -c "enable_recyclebin = off"
最后修改时间:2025-03-07 09:43:42
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。