DROP GLOBAL CONFIGURATION

Description

Drops parameter values from the gs_global_config system catalog.

Precautions

• Only the initial database user can run this command.
• The parameter name cannot be weak_password or undostoragetype.
• If the name of parameter for redistribution after scale-out is used, set the GUC parameter enable_cluster_resize to on. 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

DROP GLOBAL CONFIGURATION name [, ...];

Parameters

name

The parameter must exist in the gs_global_config system catalog. If you delete a parameter that does not exist, an error will be reported.

If the name of parameter for redistribution after scale-out is used, set the GUC parameter enable_cluster_resize to on.

Examples

See Examples.

Helpful Links

ALTER GLOBAL CONFIGURATION