Updated on 2025-05-29 GMT+08:00

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)