ALTER GLOBAL CONFIGURATION
Description
Adds or modifies key-value of the gs_global_config system catalog. You can modify an existing parameter or add a new one.
Precautions
- Only the initial database user can run this command.
- The parameter name cannot be weak_password or undostoragetype.
- If a parameter name belongs to a parameter reserved for scale-out redistribution, set the GUC parameter enable_cluster_resize to on or use the scale-out tool to modify the name. The involved parameters are lockwait_timeout, lockwait_interval, trylock_threshold, enable_cancel, last_catchup_threshold, catchup_times, write_error_mode, catchup_query_dop, parallel_catchup_threshold, parallel_reindex_jobs, redis_retry_times, redis_retry_interval, redis_bucket_expansion, redis_bucket_batchsize, redis_bucket_log_level, redis_bucket_lockhold_timeout, redis_bucket_timeout_penalty, redis_bucket_max_lockwait_timeout_retry, redis_bucket_max_lockhold_timeout_retry, redis_bucket_strategy_history_capacity, redis_bucket_strategy_recent_threshold, redis_bucket_workload_rule, redis_bucket_lsn_rule, redis_bucket_tx_bucket_min, redis_bucket_tx_bucket_max, redis_max_expected_tps, redis_bucket_sender_concurrency, redis_bucket_receiver_concurrency, redis_bucket_parse_redo_num, redis_bucket_workers_per_paser, and redis_bucket_keep_bucketxlogs.
Syntax
ALTER GLOBAL CONFIGURATION with(name=value, name=value...);
Parameters
- name
Parameter name, which is of the text type. The value cannot be weak_password or undostoragetype.
If a parameter name belongs to a parameter reserved for scale-out redistribution, set the GUC parameter enable_cluster_resize to on or use the scale-out tool to modify the name.
- value
Parameter value, which is of the text type.
Examples
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 |
-- Insert. gaussdb=# ALTER GLOBAL CONFIGURATION with(redis_is_ok = true); -- Query. gaussdb=# SELECT * FROM gs_global_config; name | value -----------------+------- buckets_len | 16384 undostoragetype | page redis_is_ok | true (3 rows) -- Change. gaussdb=# ALTER GLOBAL CONFIGURATION with(redis_is_ok = false); -- Query. gaussdb=# SELECT * FROM gs_global_config; name | value -----------------+------- buckets_len | 16384 undostoragetype | page redis_is_ok | false (3 rows) -- Delete. gaussdb=# DROP GLOBAL CONFIGURATION redis_is_ok; -- Query. gaussdb=# SELECT * FROM gs_global_config; name | value -----------------+------- buckets_len | 16384 undostoragetype | page (2 rows) |
Helpful Links
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot