greenplumn guc_gp 源码
greenplumn guc_gp 代码
文件路径：/src/backend/utils/misc/guc_gp.c
/*--------------------------------------------------------------------
* guc_gp.c
*
* Additional Greenplum-specific GUCs are defined in this file, to
* avoid adding so much stuff to guc.c. This makes it easier to diff
* and merge with upstream.
*
* Portions Copyright (c) 2005-2010, Greenplum inc
* Portions Copyright (c) 2012-Present VMware, Inc. or its affiliates.
* Copyright (c) 2000-2009, PostgreSQL Global Development Group
*
* IDENTIFICATION
* src/backend/utils/misc/guc_gp.c
*
*--------------------------------------------------------------------
*/
#include "postgres.h"
#include <float.h>
#include <sys/stat.h>
#include <sys/unistd.h>
#include "access/reloptions.h"
#include "access/transam.h"
#include "access/url.h"
#include "access/xlog_internal.h"
#include "cdb/cdbappendonlyam.h"
#include "cdb/cdbendpoint.h"
#include "cdb/cdbdisp.h"
#include "cdb/cdbdisp_query.h"
#include "cdb/cdbhash.h"
#include "cdb/cdbsreh.h"
#include "cdb/cdbvars.h"
#include "cdb/memquota.h"
#include "commands/defrem.h"
#include "commands/vacuum.h"
#include "miscadmin.h"
#include "optimizer/cost.h"
#include "optimizer/planmain.h"
#include "pgstat.h"
#include "parser/scansup.h"
#include "postmaster/syslogger.h"
#include "postmaster/fts.h"
#include "replication/walsender.h"
#include "storage/proc.h"
#include "utils/builtins.h"
#include "utils/gdd.h"
#include "utils/guc_tables.h"
#include "utils/inval.h"
#include "utils/resscheduler.h"
#include "utils/resgroup.h"
#include "utils/resource_manager.h"
#include "utils/varlena.h"
#include "utils/vmem_tracker.h"
/*
* These constants are copied from guc.c. They should not bitrot when we
* merge guc.c with upstream, as these are natural constants that never
* change. guc.c might acquire more of these, though. In that case, we'll
* just copy the new ones too, as needed.
*/
#define KB_PER_MB (1024)
#define KB_PER_GB (1024*1024)
#define MS_PER_S 1000
#define S_PER_MIN 60
#define MS_PER_MIN (1000 * 60)
#define MIN_PER_H 60
#define S_PER_H (60 * 60)
#define MS_PER_H (1000 * 60 * 60)
#define MIN_PER_D (60 * 24)
#define S_PER_D (60 * 60 * 24)
#define MS_PER_D (1000 * 60 * 60 * 24)
/*
* Assign/Show hook functions defined in this module
*/
static bool check_optimizer(bool *newval, void **extra, GucSource source);
static bool check_verify_gpfdists_cert(bool *newval, void **extra, GucSource source);
static bool check_dispatch_log_stats(bool *newval, void **extra, GucSource source);
static bool check_gp_hashagg_default_nbatches(int *newval, void **extra, GucSource source);
static bool check_gp_workfile_compression(bool *newval, void **extra, GucSource source);
/* Helper function for guc setter */
bool gpvars_check_gp_resqueue_priority_default_value(char **newval,
void **extra,
GucSource source);
static bool check_gp_default_storage_options(char **newval, void **extra, GucSource source);
static void assign_gp_default_storage_options(const char *newval, void *extra);
static bool check_pljava_classpath_insecure(bool *newval, void **extra, GucSource source);
static void assign_pljava_classpath_insecure(bool newval, void *extra);
static bool check_gp_resource_group_bypass(bool *newval, void **extra, GucSource source);
static int guc_array_compare(const void *a, const void *b);
extern struct config_generic *find_option(const char *name, bool create_placeholders, int elevel);
extern int listenerBacklog;
/* GUC lists for gp_guc_list_init(). (List of struct config_generic) */
List *gp_guc_list_for_explain;
List *gp_guc_list_for_no_plan;
/* For synchronized GUC value is cache in HashTable,
* dispatch value along with query when some guc changed
*/
List *gp_guc_restore_list = NIL;
bool gp_guc_need_restore = false;
char *Debug_dtm_action_sql_command_tag;
bool Debug_print_full_dtm = false;
bool Debug_print_snapshot_dtm = false;
bool Debug_disable_distributed_snapshot = false;
bool Debug_abort_after_distributed_prepared = false;
bool Debug_appendonly_print_insert = false;
bool Debug_appendonly_print_insert_tuple = false;
bool Debug_appendonly_print_scan = false;
bool Debug_appendonly_print_scan_tuple = false;
bool Debug_appendonly_print_delete = false;
bool Debug_appendonly_print_storage_headers = false;
bool Debug_appendonly_print_verify_write_block = false;
bool Debug_appendonly_use_no_toast = false;
bool Debug_appendonly_print_blockdirectory = false;
bool Debug_appendonly_print_read_block = false;
bool Debug_appendonly_print_append_block = false;
bool Debug_appendonly_print_segfile_choice = false;
bool test_AppendOnlyHash_eviction_vs_just_marking_not_inuse = false;
bool Debug_appendonly_print_datumstream = false;
bool Debug_appendonly_print_visimap = false;
bool Debug_appendonly_print_compaction = false;
bool Debug_bitmap_print_insert = false;
bool Test_print_direct_dispatch_info = false;
bool Test_print_prefetch_joinqual = false;
bool Test_copy_qd_qe_split = false;
bool gp_permit_relation_node_change = false;
int gp_max_local_distributed_cache = 1024;
bool gp_appendonly_verify_block_checksums = true;
bool gp_appendonly_verify_write_block = false;
bool gp_appendonly_compaction = true;
int gp_appendonly_compaction_threshold = 0;
bool gp_heap_require_relhasoids_match = true;
bool gp_local_distributed_cache_stats = false;
bool debug_xlog_record_read = false;
bool Debug_cancel_print = false;
bool Debug_datumstream_write_print_small_varlena_info = false;
bool Debug_datumstream_write_print_large_varlena_info = false;
bool Debug_datumstream_read_check_large_varlena_integrity = false;
bool Debug_datumstream_block_read_check_integrity = false;
bool Debug_datumstream_block_write_check_integrity = false;
bool Debug_datumstream_read_print_varlena_info = false;
bool Debug_datumstream_write_use_small_initial_buffers = false;
bool gp_create_table_random_default_distribution = true;
bool gp_allow_non_uniform_partitioning_ddl = true;
int dtx_phase2_retry_second = 0;
bool log_dispatch_stats = false;
int explain_memory_verbosity = 0;
char *memory_profiler_run_id = "none";
char *memory_profiler_dataset_id = "none";
char *memory_profiler_query_id = "none";
int memory_profiler_dataset_size = 0;
/* WAL based replication debug GUCs */
bool debug_walrepl_snd = false;
bool debug_walrepl_syncrep = false;
bool debug_walrepl_rcv = false;
bool debug_basebackup = false;
int rep_lag_avoidance_threshold = 0;
#define DEBUG_DTM_ACTION_PRIMARY_DEFAULT true
bool Debug_dtm_action_primary = DEBUG_DTM_ACTION_PRIMARY_DEFAULT;
bool gp_log_optimization_time = false;
int Debug_dtm_action = DEBUG_DTM_ACTION_NONE;
#define DEBUG_DTM_ACTION_TARGET_DEFAULT DEBUG_DTM_ACTION_TARGET_NONE
int Debug_dtm_action_target = DEBUG_DTM_ACTION_TARGET_DEFAULT;
#define DEBUG_DTM_ACTION_PROTOCOL_DEFAULT DTX_PROTOCOL_COMMAND_COMMIT_PREPARED
int Debug_dtm_action_protocol = DEBUG_DTM_ACTION_PROTOCOL_DEFAULT;
#define DEBUG_DTM_ACTION_SEGMENT_DEFAULT -2
#define DEBUG_DTM_ACTION_NESTINGLEVEL_DEFAULT 0
int Debug_dtm_action_segment = DEBUG_DTM_ACTION_SEGMENT_DEFAULT;
int Debug_dtm_action_nestinglevel = DEBUG_DTM_ACTION_NESTINGLEVEL_DEFAULT;
int gp_connection_send_timeout;
bool create_restartpoint_on_ckpt_record_replay = false;
/*
* This variable is a dummy that doesn't do anything, except in some
* cases provide the value for SHOW to display. The real state is elsewhere
* and is kept in sync by assign_hooks.
*/
static char *gp_resource_manager_str;
/* Backoff-related GUCs */
bool gp_enable_resqueue_priority;
int gp_resqueue_priority_local_interval;
int gp_resqueue_priority_sweeper_interval;
int gp_resqueue_priority_inactivity_timeout;
int gp_resqueue_priority_grouping_timeout;
double gp_resqueue_priority_cpucores_per_segment;
char *gp_resqueue_priority_default_value;
bool gp_debug_resqueue_priority = false;
/* Resource group GUCs */
int gp_resource_group_cpu_priority;
double gp_resource_group_cpu_limit;
double gp_resource_group_memory_limit;
bool gp_resource_group_bypass;
bool gp_resource_group_cpu_ceiling_enforcement;
bool gp_resource_group_enable_recalculate_query_mem;
/* Metrics collector debug GUC */
bool vmem_process_interrupt = false;
bool execute_pruned_plan = false;
/* Upgrade & maintenance GUCs */
bool gp_maintenance_mode;
bool gp_maintenance_conn;
bool allow_segment_DML;
bool gp_allow_rename_relation_without_lock = false;
/* Time based authentication GUC */
char *gp_auth_time_override_str = NULL;
/* include file/line information to stack traces */
bool gp_log_stack_trace_lines;
/* ignore INTO error-table clauses for backwards compatibility */
bool gp_ignore_error_table = false;
/*
* If set to true, we will silently insert into the correct leaf
* part even if the user specifies a wrong leaf part as a insert target
*/
bool dml_ignore_target_partition_check = false;
/* Planner gucs */
bool gp_enable_hashjoin_size_heuristic = false;
bool gp_enable_predicate_propagation = false;
bool gp_enable_minmax_optimization = true;
bool gp_enable_multiphase_agg = true;
bool gp_enable_preunique = true;
bool gp_enable_agg_distinct = true;
bool gp_enable_dqa_pruning = true;
bool gp_dynamic_partition_pruning = true;
bool gp_log_dynamic_partition_pruning = false;
bool gp_cte_sharing = false;
bool gp_enable_relsize_collection = false;
bool gp_recursive_cte = true;
bool gp_eager_two_phase_agg = false;
/* Optimizer related gucs */
bool optimizer;
bool optimizer_log;
int optimizer_log_failure;
bool optimizer_control = true;
bool optimizer_trace_fallback;
bool optimizer_partition_selection_log;
int optimizer_minidump;
int optimizer_cost_model;
bool optimizer_metadata_caching;
int optimizer_mdcache_size;
bool optimizer_use_gpdb_allocators;
/* Optimizer debugging GUCs */
bool optimizer_print_query;
bool optimizer_print_plan;
bool optimizer_print_xform;
bool optimizer_print_memo_after_exploration;
bool optimizer_print_memo_after_implementation;
bool optimizer_print_memo_after_optimization;
bool optimizer_print_job_scheduler;
bool optimizer_print_expression_properties;
bool optimizer_print_group_properties;
bool optimizer_print_optimization_context;
bool optimizer_print_optimization_stats;
bool optimizer_print_xform_results;
/* array of xforms disable flags */
bool optimizer_xforms[OPTIMIZER_XFORMS_COUNT] = {[0 ... OPTIMIZER_XFORMS_COUNT - 1] = false};
char *optimizer_search_strategy_path = NULL;
/* GUCs to tell Optimizer to enable a physical operator */
bool optimizer_enable_nljoin;
bool optimizer_enable_indexjoin;
bool optimizer_enable_motions_masteronly_queries;
bool optimizer_enable_motions;
bool optimizer_enable_motion_broadcast;
bool optimizer_enable_motion_gather;
bool optimizer_enable_motion_redistribute;
bool optimizer_enable_sort;
bool optimizer_enable_materialize;
bool optimizer_enable_partition_propagation;
bool optimizer_enable_partition_selection;
bool optimizer_enable_outerjoin_rewrite;
bool optimizer_enable_multiple_distinct_aggs;
bool optimizer_enable_direct_dispatch;
bool optimizer_enable_hashjoin_redistribute_broadcast_children;
bool optimizer_enable_broadcast_nestloop_outer_child;
bool optimizer_enable_streaming_material;
bool optimizer_enable_gather_on_segment_for_dml;
bool optimizer_enable_assert_maxonerow;
bool optimizer_enable_constant_expression_evaluation;
bool optimizer_enable_bitmapscan;
bool optimizer_enable_outerjoin_to_unionall_rewrite;
bool optimizer_enable_ctas;
bool optimizer_enable_partial_index;
bool optimizer_enable_dml;
bool optimizer_enable_dml_constraints;
bool optimizer_enable_master_only_queries;
bool optimizer_enable_hashjoin;
bool optimizer_enable_dynamictablescan;
bool optimizer_enable_indexscan;
bool optimizer_enable_indexonlyscan;
bool optimizer_enable_tablescan;
bool optimizer_enable_hashagg;
bool optimizer_enable_groupagg;
bool optimizer_expand_fulljoin;
bool optimizer_enable_mergejoin;
bool optimizer_prune_unused_columns;
bool optimizer_enable_redistribute_nestloop_loj_inner_child;
bool optimizer_force_comprehensive_join_implementation;
bool optimizer_enable_replicated_table;
/* Optimizer plan enumeration related GUCs */
bool optimizer_enumerate_plans;
bool optimizer_sample_plans;
int optimizer_plan_id;
int optimizer_samples_number;
/* Cardinality estimation related GUCs used by the Optimizer */
bool optimizer_extract_dxl_stats;
bool optimizer_extract_dxl_stats_all_nodes;
bool optimizer_print_missing_stats;
double optimizer_damping_factor_filter;
double optimizer_damping_factor_join;
double optimizer_damping_factor_groupby;
bool optimizer_dpe_stats;
bool optimizer_enable_derive_stats_all_groups;
/* Costing related GUCs used by the Optimizer */
int optimizer_segments;
int optimizer_penalize_broadcast_threshold;
double optimizer_cost_threshold;
double optimizer_nestloop_factor;
double optimizer_sort_factor;
/* Optimizer hints */
int optimizer_join_arity_for_associativity_commutativity;
int optimizer_array_expansion_threshold;
int optimizer_join_order_threshold;
int optimizer_join_order;
int optimizer_cte_inlining_bound;
int optimizer_push_group_by_below_setop_threshold;
int optimizer_xform_bind_threshold;
bool optimizer_force_multistage_agg;
bool optimizer_force_three_stage_scalar_dqa;
bool optimizer_force_expanded_distinct_aggs;
bool optimizer_force_agg_skew_avoidance;
bool optimizer_penalize_skew;
bool optimizer_prune_computed_columns;
bool optimizer_push_requirements_from_consumer_to_producer;
bool optimizer_enforce_subplans;
bool optimizer_use_external_constant_expression_evaluation_for_ints;
bool optimizer_apply_left_outer_to_union_all_disregarding_stats;
bool optimizer_remove_order_below_dml;
bool optimizer_multilevel_partitioning;
bool optimizer_parallel_union;
bool optimizer_array_constraints;
bool optimizer_cte_inlining;
bool optimizer_enable_space_pruning;
bool optimizer_enable_associativity;
bool optimizer_enable_eageragg;
bool optimizer_enable_range_predicate_dpe;
/* Analyze related GUCs for Optimizer */
bool optimizer_analyze_root_partition;
bool optimizer_analyze_midlevel_partition;
/* GUCs for replicated table */
bool optimizer_replicated_table_insert;
/* GUCs for slice table*/
int gp_max_slices;
/* System Information */
static int gp_server_version_num;
static char *gp_server_version_string;
/* Query Metrics */
bool gp_enable_query_metrics = false;
int gp_instrument_shmem_size = 5120;
/* Security */
bool gp_reject_internal_tcp_conn = true;
/* copy */
bool gp_enable_segment_copy_checking = true;
/*
* Default storage options GUC. Value is comma-separated name=value
* pairs. E.g. "appendonly=true,orientation=column"
*/
char *gp_default_storage_options = NULL;
int writable_external_table_bufsize = 64;
bool gp_external_enable_filter_pushdown = true;
/* Enable GDD */
bool gp_enable_global_deadlock_detector = false;
bool gp_log_endpoints = false;
/* optional reject to parse ambigous 5-digits date in YYYMMDD format */
bool gp_allow_date_field_width_5digits = false;
static const struct config_enum_entry gp_log_format_options[] = {
{"text", 0},
{"csv", 1},
{NULL, 0}
};
static const struct config_enum_entry debug_dtm_action_protocol_options[] = {
{"none", DTX_PROTOCOL_COMMAND_NONE},
{"abort_no_prepared", DTX_PROTOCOL_COMMAND_ABORT_NO_PREPARED},
{"prepare", DTX_PROTOCOL_COMMAND_PREPARE},
{"abort_some_prepared", DTX_PROTOCOL_COMMAND_ABORT_SOME_PREPARED},
{"commit_onephase", DTX_PROTOCOL_COMMAND_COMMIT_ONEPHASE},
{"commit_prepared", DTX_PROTOCOL_COMMAND_COMMIT_PREPARED},
{"abort_prepared", DTX_PROTOCOL_COMMAND_ABORT_PREPARED},
{"retry_commit_prepared", DTX_PROTOCOL_COMMAND_RETRY_COMMIT_PREPARED},
{"retry_abort_prepared", DTX_PROTOCOL_COMMAND_RETRY_ABORT_PREPARED},
{"recovery_commit_prepared", DTX_PROTOCOL_COMMAND_RECOVERY_COMMIT_PREPARED},
{"recovery_abort_prepared", DTX_PROTOCOL_COMMAND_RECOVERY_ABORT_PREPARED},
{"subtransaction_begin", DTX_PROTOCOL_COMMAND_SUBTRANSACTION_BEGIN_INTERNAL},
{"subtransaction_release", DTX_PROTOCOL_COMMAND_SUBTRANSACTION_RELEASE_INTERNAL},
{"subtransaction_rollback", DTX_PROTOCOL_COMMAND_SUBTRANSACTION_ROLLBACK_INTERNAL},
{NULL, 0}
};
static const struct config_enum_entry optimizer_log_failure_options[] = {
{"all", OPTIMIZER_ALL_FAIL},
{"unexpected", OPTIMIZER_UNEXPECTED_FAIL},
{"expected", OPTIMIZER_EXPECTED_FAIL},
{NULL, 0}
};
static const struct config_enum_entry optimizer_minidump_options[] = {
{"onerror", OPTIMIZER_MINIDUMP_FAIL},
{"always", OPTIMIZER_MINIDUMP_ALWAYS},
{NULL, 0}
};
static const struct config_enum_entry optimizer_cost_model_options[] = {
{"legacy", OPTIMIZER_GPDB_LEGACY},
{"calibrated", OPTIMIZER_GPDB_CALIBRATED},
{"experimental", OPTIMIZER_GPDB_EXPERIMENTAL},
{NULL, 0}
};
static const struct config_enum_entry explain_memory_verbosity_options[] = {
{"suppress", EXPLAIN_MEMORY_VERBOSITY_SUPPRESS},
{"summary", EXPLAIN_MEMORY_VERBOSITY_SUMMARY},
{"detail", EXPLAIN_MEMORY_VERBOSITY_DETAIL},
{NULL, 0}
};
static const struct config_enum_entry debug_dtm_action_options[] = {
{"none", DEBUG_DTM_ACTION_NONE},
{"delay", DEBUG_DTM_ACTION_DELAY},
{"fail_begin_command", DEBUG_DTM_ACTION_FAIL_BEGIN_COMMAND},
{"fail_end_command", DEBUG_DTM_ACTION_FAIL_END_COMMAND},
{"panic_begin_command", DEBUG_DTM_ACTION_PANIC_BEGIN_COMMAND},
{NULL, 0}
};
static const struct config_enum_entry debug_dtm_action_target_options[] = {
{"none", DEBUG_DTM_ACTION_TARGET_NONE},
{"protocol", DEBUG_DTM_ACTION_TARGET_PROTOCOL},
{"sql", DEBUG_DTM_ACTION_TARGET_SQL},
{NULL, 0}
};
static const struct config_enum_entry gp_autostats_modes[] = {
{"none", GP_AUTOSTATS_NONE},
{"on_change", GP_AUTOSTATS_ON_CHANGE},
{"onchange", GP_AUTOSTATS_ON_CHANGE},
{"on_no_stats", GP_AUTOSTATS_ON_NO_STATS},
{NULL, 0}
};
static const struct config_enum_entry gp_interconnect_fc_methods[] = {
{"loss", INTERCONNECT_FC_METHOD_LOSS},
{"capacity", INTERCONNECT_FC_METHOD_CAPACITY},
{NULL, 0}
};
static const struct config_enum_entry gp_interconnect_types[] = {
{"udpifc", INTERCONNECT_TYPE_UDPIFC},
{"tcp", INTERCONNECT_TYPE_TCP},
#ifdef ENABLE_IC_PROXY
{"proxy", INTERCONNECT_TYPE_PROXY},
#endif /* ENABLE_IC_PROXY */
{NULL, 0}
};
static const struct config_enum_entry gp_interconnect_address_types[] = {
{"wildcard", INTERCONNECT_ADDRESS_TYPE_WILDCARD},
{"unicast", INTERCONNECT_ADDRESS_TYPE_UNICAST},
{NULL, 0}
};
static const struct config_enum_entry gp_log_verbosity[] = {
{"terse", GPVARS_VERBOSITY_TERSE},
{"off", GPVARS_VERBOSITY_OFF},
{"verbose", GPVARS_VERBOSITY_VERBOSE},
{"debug", GPVARS_VERBOSITY_DEBUG},
{NULL, 0}
};
static const struct config_enum_entry gp_resqueue_memory_policies[] = {
{"none", RESMANAGER_MEMORY_POLICY_NONE},
{"auto", RESMANAGER_MEMORY_POLICY_AUTO},
{"eager_free", RESMANAGER_MEMORY_POLICY_EAGER_FREE},
{NULL, 0}
};
static const struct config_enum_entry optimizer_join_order_options[] = {
{"query", JOIN_ORDER_IN_QUERY},
{"greedy", JOIN_ORDER_GREEDY_SEARCH},
{"exhaustive", JOIN_ORDER_EXHAUSTIVE_SEARCH},
{"exhaustive2", JOIN_ORDER_EXHAUSTIVE2_SEARCH},
{NULL, 0}
};
IndexCheckType gp_indexcheck_insert = INDEX_CHECK_NONE;
struct config_bool ConfigureNamesBool_gp[] =
{
{
{"maintenance_mode", PGC_POSTMASTER, CUSTOM_OPTIONS,
gettext_noop("Maintenance Mode"),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_maintenance_mode,
false,
NULL, NULL, NULL
},
{
{"gp_maintenance_conn", PGC_BACKEND, CUSTOM_OPTIONS,
gettext_noop("Maintenance Connection"),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_maintenance_conn,
false,
NULL, NULL, NULL
},
{
{"gp_use_legacy_hashops", PGC_USERSET, COMPAT_OPTIONS_PREVIOUS,
gettext_noop("If set, new tables will use legacy distribution hashops by default"),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_use_legacy_hashops,
false,
NULL, NULL, NULL
},
{
{"allow_segment_DML", PGC_USERSET, CUSTOM_OPTIONS,
gettext_noop("Allow DML on segments"),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&allow_segment_DML,
false,
NULL, NULL, NULL
},
{
{"gp_allow_rename_relation_without_lock", PGC_USERSET, CUSTOM_OPTIONS,
gettext_noop("Allow ALTER TABLE RENAME without AccessExclusiveLock"),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_allow_rename_relation_without_lock,
false,
NULL, NULL, NULL
},
{
{"enable_groupagg", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enables the planner's use of grouping aggregation plans."),
NULL
},
&enable_groupagg,
true,
NULL, NULL, NULL
},
{
{"gp_enable_hashjoin_size_heuristic", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("In hash join plans, the smaller of the two inputs "
"(as estimated) is used to build the hash table."),
gettext_noop("If false, either input could be used to build the "
"hash table; the choice depends on the estimated hash "
"join cost, which the planner computes for both "
"alternatives. Has no effect on outer or adaptive "
"joins."),
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_enable_hashjoin_size_heuristic,
false,
NULL, NULL, NULL
},
{
{"gp_enable_direct_dispatch", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enable dispatch for single-row-insert targeted mirror-pairs."),
gettext_noop("Don't involve the whole cluster if it isn't needed.")
},
&gp_enable_direct_dispatch,
true,
NULL, NULL, NULL
},
{
{"gp_enable_predicate_propagation", PGC_USERSET, QUERY_TUNING_OTHER,
gettext_noop("When two expressions are equivalent (such as with "
"equijoined keys) then the planner applies predicates "
"on one expression to the other expression."),
gettext_noop("If false, planner does not copy predicates.")
},
&gp_enable_predicate_propagation,
true,
NULL, NULL, NULL
},
{
{"debug_print_prelim_plan", PGC_USERSET, LOGGING_WHAT,
gettext_noop("Prints the preliminary execution plan to server log."),
NULL
},
&Debug_print_prelim_plan,
false,
NULL, NULL, NULL
},
{
{"debug_print_slice_table", PGC_USERSET, LOGGING_WHAT,
gettext_noop("Prints the slice table to server log."),
NULL
},
&Debug_print_slice_table,
false,
NULL, NULL, NULL
},
{
{"log_dispatch_stats", PGC_SUSET, STATS_MONITORING,
gettext_noop("Writes dispatcher performance statistics to the server log."),
NULL
},
&log_dispatch_stats,
false,
check_dispatch_log_stats, NULL, NULL
},
{
{"gp_enable_minmax_optimization", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enables the planner's use of index scans with limit to implement MIN/MAX."),
NULL,
GUC_NOT_IN_SAMPLE
},
&gp_enable_minmax_optimization,
true, NULL, NULL
},
{
{"gp_enable_multiphase_agg", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enables the planner's use of two- or three-stage parallel aggregation plans."),
gettext_noop("Allows partial aggregation before motion.")
},
&gp_enable_multiphase_agg,
true,
NULL, NULL, NULL
},
{
{"gp_enable_preunique", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enable 2-phase duplicate removal."),
gettext_noop("If true, planner may choose to remove duplicates in "
"two phases--before and after redistribution.")
},
&gp_enable_preunique,
true,
NULL, NULL, NULL
},
{
{"gp_enable_agg_distinct", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enable 2-phase aggregation to compute a single distinct-qualified aggregate."),
NULL,
},
&gp_enable_agg_distinct,
true,
NULL, NULL, NULL
},
{
{"gp_enable_agg_distinct_pruning", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enable 3-phase aggregation and join to compute distinct-qualified aggregates."),
NULL,
},
&gp_enable_dqa_pruning,
true,
NULL, NULL, NULL
},
{
{"gp_enable_explain_allstat", PGC_USERSET, CLIENT_CONN_OTHER,
gettext_noop("Experimental feature: dump stats for all segments in EXPLAIN ANALYZE."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_enable_explain_allstat,
false,
NULL, NULL, NULL
},
{
{"gp_enable_sort_limit", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enable LIMIT operation to be performed while sorting."),
gettext_noop("Sort more efficiently when plan requires the first <n> rows at most.")
},
&gp_enable_sort_limit,
true,
NULL, NULL, NULL
},
{
{"gp_enable_sort_distinct", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enable duplicate removal to be performed while sorting."),
gettext_noop("Reduces data handling when plan calls for removing duplicates from sorted rows.")
},
&gp_enable_sort_distinct,
true,
NULL, NULL, NULL
},
{
{"gp_enable_motion_deadlock_sanity", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Enable verbose check at planning time."),
NULL,
GUC_NO_RESET_ALL | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_enable_motion_deadlock_sanity,
false,
NULL, NULL, NULL
},
{
{"gp_adjust_selectivity_for_outerjoins", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Adjust selectivity of null tests over outer joins."),
NULL,
GUC_NOT_IN_SAMPLE
},
&gp_adjust_selectivity_for_outerjoins,
true,
NULL, NULL, NULL
},
{
{"gp_selectivity_damping_for_scans", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Damping of selectivities for clauses over the same base relation."),
NULL,
GUC_NOT_IN_SAMPLE | GUC_NO_SHOW_ALL
},
&gp_selectivity_damping_for_scans,
true,
NULL, NULL, NULL
},
{
{"gp_selectivity_damping_for_joins", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Damping of selectivities in join clauses."),
NULL,
GUC_NOT_IN_SAMPLE | GUC_NO_SHOW_ALL
},
&gp_selectivity_damping_for_joins,
false,
NULL, NULL, NULL
},
{
{"gp_selectivity_damping_sigsort", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Sort selectivities by ascending significance, i.e. smallest first"),
NULL,
GUC_NOT_IN_SAMPLE | GUC_NO_SHOW_ALL
},
&gp_selectivity_damping_sigsort,
true,
NULL, NULL, NULL
},
{
{"gp_enable_interconnect_aggressive_retry", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Enable application-level fast-track interconnect retries"),
NULL,
GUC_NO_RESET_ALL | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_interconnect_aggressive_retry,
true,
NULL, NULL, NULL
},
{
{"gp_select_invisible", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Use dummy snapshot for MVCC visibility calculation."),
NULL,
GUC_NOT_IN_SAMPLE | GUC_NO_SHOW_ALL
},
&gp_select_invisible,
false,
NULL, NULL, NULL
},
{
{"gp_enable_slow_writer_testmode", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Slow down writer gangs -- to facilitate race-condition testing."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_enable_slow_writer_testmode,
false,
NULL, NULL, NULL
},
{
{"gp_debug_pgproc", PGC_POSTMASTER, DEVELOPER_OPTIONS,
gettext_noop("Print debug info relevant to PGPROC."),
NULL /* long description */ ,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_debug_pgproc,
false,
NULL, NULL, NULL
},
{
{"gp_appendonly_verify_block_checksums", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Verify the append-only block checksum when reading."),
NULL,
GUC_NOT_IN_SAMPLE | GUC_NO_SHOW_ALL
},
&gp_appendonly_verify_block_checksums,
true,
NULL, NULL, NULL
},
{
{"gp_appendonly_verify_write_block", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Verify the append-only block as it is being written."),
NULL,
GUC_NOT_IN_SAMPLE | GUC_NO_SHOW_ALL
},
&gp_appendonly_verify_write_block,
false,
NULL, NULL, NULL
},
{
{"gp_appendonly_compaction", PGC_SUSET, APPENDONLY_TABLES,
gettext_noop("Perform append-only compaction instead of eof truncation on vacuum."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NOT_IN_SAMPLE | GUC_NO_SHOW_ALL
},
&gp_appendonly_compaction,
true,
NULL, NULL, NULL
},
{
{"gp_heap_require_relhasoids_match", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Issue an error on discovery of a mismatch between relhasoids and a tuple header."),
NULL,
GUC_NOT_IN_SAMPLE | GUC_NO_SHOW_ALL
},
&gp_heap_require_relhasoids_match,
true,
NULL, NULL, NULL
},
{
{"debug_burn_xids", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Consume a lot of XIDs, for testing purposes."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&Debug_burn_xids,
false,
NULL, NULL, NULL
},
{
{"gp_retrieve_conn", PGC_BACKEND, GP_WORKER_IDENTITY,
gettext_noop("Specify this is a connection for parallel cursor retrieve"),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE | GUC_DISALLOW_IN_FILE | GUC_NO_RESET_ALL
},
&am_cursor_retrieve_handler,
false,
NULL, NULL, NULL
},
{
{"gp_cost_hashjoin_chainwalk", PGC_USERSET, QUERY_TUNING_COST,
gettext_noop("Enable the cost for walking the chain in the hash join"),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_cost_hashjoin_chainwalk,
false,
NULL, NULL, NULL
},
{
{"gp_set_proc_affinity", PGC_POSTMASTER, RESOURCES_KERNEL,
gettext_noop("On postmaster startup, attempt to bind postmaster to a processor"),
NULL
},
&gp_set_proc_affinity,
false,
NULL, NULL, NULL
},
{
{"gp_is_writer", PGC_BACKEND, GP_WORKER_IDENTITY,
gettext_noop("True in a worker process which can directly update its local database segment."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE | GUC_DISALLOW_IN_FILE
},
&Gp_is_writer,
false,
NULL, NULL, NULL
},
{
{"gp_write_shared_snapshot", PGC_USERSET, UNGROUPED,
gettext_noop("Forces the writer gang to set the shared snapshot."),
NULL,
GUC_NO_SHOW_ALL | GUC_NO_RESET_ALL | GUC_NOT_IN_SAMPLE | GUC_DISALLOW_IN_FILE
},
&Gp_write_shared_snapshot,
false,
NULL, assign_gp_write_shared_snapshot, NULL
},
{
{"gp_workfile_compression", PGC_USERSET, RESOURCES_DISK,
gettext_noop("Enables compression of temporary files."),
NULL
},
&gp_workfile_compression,
false,
check_gp_workfile_compression, NULL, NULL
},
{
{"gp_reraise_signal", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Do we attempt to dump core when a serious problem occurs."),
NULL,
GUC_NO_RESET_ALL
},
&gp_reraise_signal,
true,
NULL, NULL, NULL
},
{
{"gp_external_enable_exec", PGC_POSTMASTER, EXTERNAL_TABLES,
gettext_noop("Enable selecting from an external table with an EXECUTE clause."),
NULL
},
&gp_external_enable_exec,
true,
NULL, NULL, NULL
},
{
{"gp_enable_fast_sri", PGC_USERSET, QUERY_TUNING_OTHER,
gettext_noop("Enable single-slice single-row inserts."),
NULL
},
&gp_enable_fast_sri,
true,
NULL, NULL, NULL
},
{
{"gp_interconnect_full_crc", PGC_USERSET, QUERY_TUNING_OTHER,
gettext_noop("Sanity check incoming data stream."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_interconnect_full_crc,
false,
NULL, NULL, NULL
},
{
{"gp_interconnect_log_stats", PGC_USERSET, QUERY_TUNING_OTHER,
gettext_noop("Emit statistics from the UDP-IC at the end of every statement."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_interconnect_log_stats,
false,
NULL, NULL, NULL
},
{
{"gp_interconnect_cache_future_packets", PGC_USERSET, GP_ARRAY_TUNING,
gettext_noop("Control whether future packets are cached."),
NULL,
},
&gp_interconnect_cache_future_packets,
true,
NULL, NULL, NULL
},
{
{"resource_scheduler", PGC_POSTMASTER, RESOURCES_MGM,
gettext_noop("Enable resource scheduling."),
NULL,
GUC_NOT_IN_SAMPLE
},
&ResourceScheduler,
true,
NULL, NULL, NULL
},
{
{"resource_select_only", PGC_POSTMASTER, RESOURCES_MGM,
gettext_noop("Enable resource locking of SELECT only."),
NULL
},
&ResourceSelectOnly,
false,
NULL, NULL, NULL
},
{
{"resource_cleanup_gangs_on_wait", PGC_USERSET, RESOURCES_MGM,
gettext_noop("Enable idle gang cleanup before resource lockwait."),
NULL
},
&ResourceCleanupIdleGangs,
true,
NULL, NULL, NULL
},
{
{"gp_debug_resqueue_priority", PGC_USERSET, RESOURCES_MGM,
gettext_noop("Print out debugging information about backoff calls."),
NULL,
GUC_NO_SHOW_ALL
},
&gp_debug_resqueue_priority,
false,
NULL, NULL, NULL
},
{
{"debug_print_full_dtm", PGC_SUSET, LOGGING_WHAT,
gettext_noop("Prints full DTM information to server log."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&Debug_print_full_dtm,
false,
NULL, NULL, NULL
},
{
{"debug_print_snapshot_dtm", PGC_SUSET, LOGGING_WHAT,
gettext_noop("Prints snapshot DTM information to server log."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&Debug_print_snapshot_dtm,
false,
NULL, NULL, NULL
},
{
{"debug_disable_distributed_snapshot", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Disables distributed snapshots."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&Debug_disable_distributed_snapshot,
false,
NULL, NULL, NULL
},
{
{"debug_abort_after_distributed_prepared", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Cause an abort after all segments are prepared but before the distributed commit is written."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&Debug_abort_after_distributed_prepared,
false,
NULL, NULL, NULL
},
{
{"debug_appendonly_print_blockdirectory", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Print log messages for append-only block directory."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&Debug_appendonly_print_blockdirectory,
false,
NULL, NULL, NULL
},
{
{"Debug_appendonly_print_read_block", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Print log messages for append-only reads."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&Debug_appendonly_print_read_block,
false,
NULL, NULL, NULL
},
{
{"Debug_appendonly_print_append_block", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Print log messages for append-only writes."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&Debug_appendonly_print_append_block,
false,
NULL, NULL, NULL
},
{
{"debug_appendonly_print_visimap", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Print log messages for append-only visibility bitmap information."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&Debug_appendonly_print_visimap,
false,
NULL, NULL, NULL
},
{
{"debug_appendonly_print_compaction", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Print log messages about append-only visibility compactions."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&Debug_appendonly_print_compaction,
false,
NULL, NULL, NULL
},
{
{"debug_appendonly_print_insert", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Print log messages for append-only insert."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&Debug_appendonly_print_insert,
false,
NULL, NULL, NULL
},
{
{"debug_appendonly_print_insert_tuple", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Print log messages for append-only insert tuples (caution -- generates a lot of log!)."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&Debug_appendonly_print_insert_tuple,
false,
NULL, NULL, NULL
},
{
{"debug_appendonly_print_scan", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Print log messages for append-only scan."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&Debug_appendonly_print_scan,
false,
NULL, NULL, NULL
},
{
{"debug_appendonly_print_scan_tuple", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Print log messages for append-only scan tuples (caution -- generates a lot of log!)."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&Debug_appendonly_print_scan_tuple,
false,
NULL, NULL, NULL
},
{
{"debug_appendonly_print_delete", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Print log messages for append-only delete."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&Debug_appendonly_print_delete,
false,
NULL, NULL, NULL
},
{
{"debug_appendonly_print_storage_headers", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Print log messages for append-only storage headers."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&Debug_appendonly_print_storage_headers,
false,
NULL, NULL, NULL
},
{
{"debug_appendonly_print_verify_write_block", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Print log messages for append-only verify block during write."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&Debug_appendonly_print_verify_write_block,
false,
NULL, NULL, NULL
},
{
{"debug_appendonly_use_no_toast", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Use no toast for an append-only table. Store the large row inline."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&Debug_appendonly_use_no_toast,
false,
NULL, NULL, NULL
},
{
{"debug_appendonly_print_segfile_choice", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Print log messages for append-only writers about their choice for AO segment file."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&Debug_appendonly_print_segfile_choice,
false,
NULL, NULL, NULL
},
{
{"test_AppendOnlyHash_eviction_vs_just_marking_not_inuse", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Helps to test evicting the entry for AppendOnlyHash as soon as its usage is done instead of just marking it not inuse."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&test_AppendOnlyHash_eviction_vs_just_marking_not_inuse,
false,
NULL, NULL, NULL
},
{
{"debug_appendonly_print_datumstream", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Print log messages for append-only datum stream content."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&Debug_appendonly_print_datumstream,
false,
NULL, NULL, NULL
},
{
{"debug_xlog_record_read", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Print debug information for xlog record read."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&debug_xlog_record_read,
false,
NULL, NULL, NULL
},
{
{"debug_cancel_print", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Print cancel detail information."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&Debug_cancel_print,
false,
NULL, NULL, NULL
},
{
{"debug_datumstream_write_print_small_varlena_info", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Print datum stream write small varlena information."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&Debug_datumstream_write_print_small_varlena_info,
false,
NULL, NULL, NULL
},
{
{"debug_datumstream_write_print_large_varlena_info", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Print datum stream write large varlena information."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&Debug_datumstream_write_print_large_varlena_info,
false,
NULL, NULL, NULL
},
{
{"debug_datumstream_read_check_large_varlena_integrity", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Check datum stream large object integrity."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&Debug_datumstream_read_check_large_varlena_integrity,
false,
NULL, NULL, NULL
},
{
{"debug_datumstream_block_read_check_integrity", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Check datum stream block read integrity."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&Debug_datumstream_block_read_check_integrity,
false,
NULL, NULL, NULL
},
{
{"debug_datumstream_block_write_check_integrity", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Check datum stream block write integrity."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&Debug_datumstream_block_write_check_integrity,
false,
NULL, NULL, NULL
},
{
{"debug_datumstream_read_print_varlena_info", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Print datum stream read varlena information."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&Debug_datumstream_read_print_varlena_info,
false,
NULL, NULL, NULL
},
{
{"debug_datumstream_write_use_small_initial_buffers", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Use small datum stream write buffers to stress growing logic."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&Debug_datumstream_write_use_small_initial_buffers,
false,
NULL, NULL, NULL
},
{
{"test_print_direct_dispatch_info", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("For testing purposes, print information about direct dispatch decisions."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&Test_print_direct_dispatch_info,
false,
NULL, NULL, NULL
},
{
{"test_print_prefetch_joinqual", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("For testing purposes, print information about if we prefetch join qual."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&Test_print_prefetch_joinqual,
false,
NULL, NULL, NULL
},
{
{"test_copy_qd_qe_split", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("For testing purposes, print information about which columns are parsed in QD and which in QE."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&Test_copy_qd_qe_split,
false,
NULL, NULL, NULL
},
{
{"debug_bitmap_print_insert", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Print log messages for bitmap index insert routines (caution-- generate a lot of logs!)"),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&Debug_bitmap_print_insert,
false,
NULL, NULL, NULL
},
{
{"debug_dtm_action_primary", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Specify if the primary or mirror segment is the target of the debug DTM action."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&Debug_dtm_action_primary,
DEBUG_DTM_ACTION_PRIMARY_DEFAULT, NULL, NULL, NULL
},
{
{"gp_disable_tuple_hints", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Specify if hint bits on tuples should be deferred."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
/*
* If gp_disable_tuple_hints is off, always mark buffer dirty.
* If gp_disable_tuple_hints is on, defer marking the buffer dirty
* until after transaction is identified as old.
* (unless it is a catalog table) See: markDirty
*/
&gp_disable_tuple_hints,
true,
NULL, NULL, NULL
},
{
{"gp_local_distributed_cache_stats", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Prints local-distributed cache statistics at end of commit / prepare."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_local_distributed_cache_stats,
false,
NULL, NULL, NULL
},
{
{"gp_enable_query_metrics", PGC_POSTMASTER, UNGROUPED,
gettext_noop("Enable all query metrics collection."),
NULL
},
&gp_enable_query_metrics,
false,
NULL, NULL, NULL
},
{
{"coredump_on_memerror", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Generate core dump on memory error."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&coredump_on_memerror,
false,
NULL, NULL, NULL
},
{
{"log_autostats", PGC_SUSET, LOGGING_WHAT,
gettext_noop("Logs details of auto-stats issued ANALYZEs."),
NULL
},
&log_autostats,
false,
NULL, NULL, NULL
},
{
{"gp_statistics_pullup_from_child_partition", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("This guc enables the planner to utilize statistics from partitions in planning queries on the parent."),
NULL
},
&gp_statistics_pullup_from_child_partition,
false,
NULL, NULL, NULL
},
{
{"gp_statistics_use_fkeys", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("This guc enables the planner to utilize statistics derived from foreign key relationships."),
NULL
},
&gp_statistics_use_fkeys,
false,
NULL, NULL, NULL
},
{
{"gp_resqueue_priority", PGC_POSTMASTER, RESOURCES_MGM,
gettext_noop("Enables priority scheduling."),
NULL
},
&gp_enable_resqueue_priority,
true,
NULL, NULL, NULL
},
{
{"debug_resource_group", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Prints resource groups debug logs."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&Debug_resource_group,
false,
NULL, NULL, NULL
},
{
{"debug_walrepl_snd", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Print debug messages for WAL sender in WAL based replication (Master Mirroring)."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&debug_walrepl_snd,
false,
NULL, NULL, NULL
},
{
{"debug_walrepl_syncrep", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Print debug messages for synchronous behavior in WAL based replication (Master Mirroring)."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&debug_walrepl_syncrep,
false,
NULL, NULL, NULL
},
{
{"debug_walrepl_rcv", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Print debug messages for WAL receiver in WAL based replication (Master Mirroring)."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&debug_walrepl_rcv,
false,
NULL, NULL, NULL
},
{
{"debug_basebackup", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Print debug messages for basebackup mechanism (Master Mirroring)."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&debug_basebackup,
false,
NULL, NULL, NULL
},
{
{"gp_encoding_check_locale_compatibility", PGC_POSTMASTER, CLIENT_CONN_LOCALE,
gettext_noop("Enable check for compatibility of encoding and locale in createdb"),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_encoding_check_locale_compatibility,
true,
NULL, NULL, NULL
},
/* for pljava */
{
{"pljava_release_lingering_savepoints", PGC_SUSET, CUSTOM_OPTIONS,
gettext_noop("If true, lingering savepoints will be released on function exit; if false, they will be rolled back"),
NULL,
GUC_NOT_IN_SAMPLE | GUC_SUPERUSER_ONLY
},
&pljava_release_lingering_savepoints,
false,
NULL, NULL, NULL
},
{
{"pljava_debug", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Stop the backend to attach a debugger"),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE | GUC_SUPERUSER_ONLY
},
&pljava_debug,
false,
NULL, NULL, NULL
},
{
{"gp_log_stack_trace_lines", PGC_USERSET, LOGGING_WHAT,
gettext_noop("Control if file/line information is included in stack traces"),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_log_stack_trace_lines,
true,
NULL, NULL, NULL
},
{
{"gp_log_resqueue_memory", PGC_USERSET, LOGGING_WHAT,
gettext_noop("Prints out messages related to resource queue's memory management."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_log_resqueue_memory,
false,
NULL, NULL, NULL
},
{
{"gp_log_resgroup_memory", PGC_USERSET, LOGGING_WHAT,
gettext_noop("Prints out messages related to resource group's memory management."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_log_resgroup_memory,
false,
NULL, NULL, NULL
},
{
{"gp_resqueue_print_operator_memory_limits", PGC_USERSET, LOGGING_WHAT,
gettext_noop("Prints out the memory limit for operators (in explain) assigned by resource queue's "
"memory management."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_resqueue_print_operator_memory_limits,
false,
NULL, NULL, NULL
},
{
{"gp_resgroup_print_operator_memory_limits", PGC_USERSET, LOGGING_WHAT,
gettext_noop("Prints out the memory limit for operators (in explain) assigned by resource group's "
"memory management."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_resgroup_print_operator_memory_limits,
false,
NULL, NULL, NULL
},
{
{"gp_resgroup_debug_wait_queue", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Enable the debugging check on the wait queue of resource group."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_resgroup_debug_wait_queue,
true,
NULL, NULL, NULL
},
{
{"gp_dynamic_partition_pruning", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("This guc enables plans that can dynamically eliminate scanning of partitions."),
NULL
},
&gp_dynamic_partition_pruning,
true,
NULL, NULL, NULL
},
{
{"gp_cte_sharing", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("This guc enables sharing of plan fragments for common table expressions."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_cte_sharing,
false,
NULL, NULL, NULL
},
{
{"gp_enable_relsize_collection", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("This guc enables relsize collection when stats are not present. If disabled and stats are not present a default "
"value is used."),
NULL
},
&gp_enable_relsize_collection,
false,
NULL, NULL, NULL
},
{
{"gp_log_dynamic_partition_pruning", PGC_USERSET, LOGGING_WHAT,
gettext_noop("This guc enables debug messages related to dynamic partition pruning."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_log_dynamic_partition_pruning,
false,
NULL, NULL, NULL
},
{
{"gp_create_table_random_default_distribution", PGC_USERSET, COMPAT_OPTIONS,
gettext_noop("Set the default distribution of a table to RANDOM."),
NULL,
GUC_NOT_IN_SAMPLE
},
&gp_create_table_random_default_distribution,
false,
NULL, NULL, NULL
},
{
{"gp_allow_non_uniform_partitioning_ddl", PGC_USERSET, COMPAT_OPTIONS,
gettext_noop("Allow DDL that will create multi-level partition table with non-uniform hierarchy."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_allow_non_uniform_partitioning_ddl,
true,
NULL, NULL, NULL
},
{
{"gp_recursive_cte_prototype", PGC_USERSET, DEPRECATED_OPTIONS,
gettext_noop("Enable RECURSIVE clauses in CTE queries (deprecated option, use \"gp_recursive_cte\" instead)."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_recursive_cte,
true, NULL, NULL
},
{
{"gp_recursive_cte", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enable RECURSIVE clauses in CTE queries."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_recursive_cte,
true, NULL, NULL
},
{
{"gp_eager_two_phase_agg", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Eager two stage agg."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_eager_two_phase_agg,
false, NULL, NULL
},
{
{"optimizer", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enable GPORCA."),
NULL
},
&optimizer,
#ifdef USE_ORCA
true,
#else
false,
#endif
check_optimizer, NULL, NULL
},
{
{"optimizer_log", PGC_USERSET, LOGGING_WHAT,
gettext_noop("Log optimizer messages."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_log,
true,
NULL, NULL, NULL
},
{
{"optimizer_trace_fallback", PGC_USERSET, LOGGING_WHAT,
gettext_noop("Print a message at INFO level, whenever GPORCA falls back."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_trace_fallback,
false,
NULL, NULL, NULL
},
{
{"optimizer_partition_selection_log", PGC_USERSET, LOGGING_WHAT,
gettext_noop("Log optimizer partition selection."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_partition_selection_log,
false,
NULL, NULL, NULL
},
{
{"optimizer_print_query", PGC_USERSET, LOGGING_WHAT,
gettext_noop("Prints the optimizer's input query expression tree."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_print_query,
false,
NULL, NULL, NULL
},
{
{"optimizer_print_plan", PGC_USERSET, LOGGING_WHAT,
gettext_noop("Prints the plan expression tree produced by the optimizer."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_print_plan,
false,
NULL, NULL, NULL
},
{
{"optimizer_print_xform", PGC_USERSET, LOGGING_WHAT,
gettext_noop("Prints optimizer transformation information."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_print_xform,
false,
NULL, NULL, NULL
},
{
{"optimizer_metadata_caching", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("This guc enables the optimizer to cache and reuse metadata."),
NULL
},
&optimizer_metadata_caching,
true,
NULL, NULL, NULL
},
{
{"optimizer_print_missing_stats", PGC_USERSET, LOGGING_WHAT,
gettext_noop("Print columns with missing statistics."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_print_missing_stats,
true,
NULL, NULL, NULL
},
{
{"optimizer_print_xform_results", PGC_USERSET, LOGGING_WHAT,
gettext_noop("Print the input and output of optimizer transformations."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_print_xform_results,
false,
NULL, NULL, NULL
},
{
{"optimizer_print_memo_after_exploration", PGC_USERSET, LOGGING_WHAT,
gettext_noop("Print optimizer memo structure after the exploration phase."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_print_memo_after_exploration,
false,
NULL, NULL, NULL
},
{
{"optimizer_print_memo_after_implementation", PGC_USERSET, LOGGING_WHAT,
gettext_noop("Print optimizer memo structure after the implementation phase."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_print_memo_after_implementation,
false,
NULL, NULL, NULL
},
{
{"optimizer_print_memo_after_optimization", PGC_USERSET, LOGGING_WHAT,
gettext_noop("Print optimizer memo structure after optimization."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_print_memo_after_optimization,
false,
NULL, NULL, NULL
},
{
{"optimizer_print_job_scheduler", PGC_USERSET, LOGGING_WHAT,
gettext_noop("Print the jobs in the scheduler on each job completion."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_print_job_scheduler,
false,
NULL, NULL, NULL
},
{
{"optimizer_print_expression_properties", PGC_USERSET, LOGGING_WHAT,
gettext_noop("Print expression properties."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_print_expression_properties,
false,
NULL, NULL, NULL
},
{
{"optimizer_print_group_properties", PGC_USERSET, LOGGING_WHAT,
gettext_noop("Print group properties."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_print_group_properties,
false,
NULL, NULL, NULL
},
{
{"optimizer_print_optimization_context", PGC_USERSET, LOGGING_WHAT,
gettext_noop("Print the optimization context."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_print_optimization_context,
false,
NULL, NULL, NULL
},
{
{"optimizer_print_optimization_stats", PGC_USERSET, LOGGING_WHAT,
gettext_noop("Print optimization stats."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_print_optimization_stats,
false,
NULL, NULL, NULL
},
{
{"optimizer_extract_dxl_stats", PGC_USERSET, LOGGING_WHAT,
gettext_noop("Extract plan stats in dxl."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_extract_dxl_stats,
false,
NULL, NULL, NULL
},
{
{"optimizer_extract_dxl_stats_all_nodes", PGC_USERSET, LOGGING_WHAT,
gettext_noop("Extract plan stats for all physical dxl nodes."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_extract_dxl_stats_all_nodes,
false,
NULL, NULL, NULL
},
{
{"optimizer_dpe_stats", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enable statistics derivation for partitioned tables with dynamic partition elimination."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_dpe_stats,
true,
NULL, NULL, NULL
},
{
{"optimizer_enable_nljoin", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enable nested loops join plans in the optimizer."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_enable_nljoin,
true,
NULL, NULL, NULL
},
{
{"optimizer_enable_indexjoin", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enable index nested loops join plans in the optimizer."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_enable_indexjoin,
true,
NULL, NULL, NULL
},
{
{"optimizer_enable_motions_masteronly_queries", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enable plans with Motion operators in the optimizer for queries with no distributed tables."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_enable_motions_masteronly_queries,
false,
NULL, NULL, NULL
},
{
{"optimizer_enable_motions", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enable plans with Motion operators in the optimizer."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_enable_motions,
true,
NULL, NULL, NULL
},
{
{"optimizer_enable_motion_broadcast", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enable plans with Motion Broadcast operators in the optimizer."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_enable_motion_broadcast,
true,
NULL, NULL, NULL
},
{
{"optimizer_enable_motion_gather", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enable plans with Motion Gather operators in the optimizer."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_enable_motion_gather,
true,
NULL, NULL, NULL
},
{
{"optimizer_enable_motion_redistribute", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enable plans with Motion Redistribute operators in the optimizer."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_enable_motion_redistribute,
true,
NULL, NULL, NULL
},
{
{"optimizer_enable_sort", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enable plans with Sort operators in the optimizer."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_enable_sort,
true,
NULL, NULL, NULL
},
{
{"optimizer_enable_materialize", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enable plans with Materialize operators in the optimizer."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_enable_materialize,
true,
NULL, NULL, NULL
},
{
{"optimizer_enable_partition_propagation", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enable plans with Partition Propagation operators in the optimizer."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_enable_partition_propagation,
true,
NULL, NULL, NULL
},
{
{"optimizer_enable_partition_selection", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enable plans with Partition Selection operators in the optimizer."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_enable_partition_selection,
true,
NULL, NULL, NULL
},
{
{"optimizer_enable_outerjoin_rewrite", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enable outer join to inner join rewrite in the optimizer."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_enable_outerjoin_rewrite,
true,
NULL, NULL, NULL
},
{
{"optimizer_enable_direct_dispatch", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enable direct dispatch in the optimizer."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_enable_direct_dispatch,
true,
NULL, NULL, NULL
},
{
{"optimizer_control", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Allow/disallow turning the optimizer on or off."),
NULL
},
&optimizer_control,
true,
NULL, NULL, NULL
},
{
{"optimizer_enable_space_pruning", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Enable space pruning in the optimizer."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_enable_space_pruning,
true,
NULL, NULL, NULL
},
{
{"optimizer_enable_master_only_queries", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Process master only queries via the optimizer."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_enable_master_only_queries,
false,
NULL, NULL, NULL
},
{
{"optimizer_enable_hashjoin", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enables the optimizer's use of hash join plans."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_enable_hashjoin,
true,
NULL, NULL, NULL
},
{
{"optimizer_enable_dynamictablescan", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enables the optimizer's use of plans with dynamic table scan."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_enable_dynamictablescan,
true,
NULL, NULL, NULL
},
{
{"optimizer_enable_indexscan", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enables the optimizer's use of plans with index scan."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_enable_indexscan,
true,
NULL, NULL, NULL
},
{
{"optimizer_enable_indexonlyscan", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enables the optimizer's use of plans with index only scan."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_enable_indexonlyscan,
true,
NULL, NULL, NULL
},
{
{"optimizer_enable_tablescan", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enables the optimizer's use of plans with table scan."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_enable_tablescan,
true,
NULL, NULL, NULL
},
{
{"optimizer_enable_hashagg", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enables Pivotal Optimizer (GPORCA) to use hash aggregates."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_enable_hashagg,
true,
NULL, NULL, NULL
},
{
{"optimizer_enable_groupagg", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enables Pivotal Optimizer (GPORCA) to use group aggregates."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_enable_groupagg,
true,
NULL, NULL, NULL
},
{
{"optimizer_force_agg_skew_avoidance", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Always pick a plan for aggregate distinct that minimizes skew."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_force_agg_skew_avoidance,
true,
NULL, NULL, NULL
},
{
{"optimizer_penalize_skew", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Penalize operators with skewed hash redistribute below it."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_penalize_skew,
true,
NULL, NULL, NULL
},
{
{"optimizer_multilevel_partitioning", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Enable optimization of queries on multilevel partitioned tables."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_multilevel_partitioning,
true,
NULL, NULL, NULL
},
{
{"optimizer_enable_derive_stats_all_groups", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Enable stats derivation for all groups after exploration."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_enable_derive_stats_all_groups,
false,
NULL, NULL, NULL
},
{
{"optimizer_force_multistage_agg", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Force optimizer to always pick multistage aggregates when such a plan alternative is generated."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_force_multistage_agg,
false,
NULL, NULL, NULL
},
{
{"optimizer_enable_multiple_distinct_aggs", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enable plans with multiple distinct aggregates in the optimizer."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_enable_multiple_distinct_aggs,
false,
NULL, NULL, NULL
},
{
{"optimizer_force_expanded_distinct_aggs", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Always pick plans that expand multiple distinct aggregates into join of single distinct aggregate in the optimizer."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_force_expanded_distinct_aggs,
true,
NULL, NULL, NULL
},
{
{"optimizer_prune_computed_columns", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Prune unused computed columns when pre-processing query"),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_prune_computed_columns,
true,
NULL, NULL, NULL
},
{
{"optimizer_push_requirements_from_consumer_to_producer", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Optimize CTE producer plan on requirements enforced on top of CTE consumer in the optimizer."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_push_requirements_from_consumer_to_producer,
true,
NULL, NULL, NULL
},
{
{"optimizer_enable_hashjoin_redistribute_broadcast_children", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enable hash join plans with, Redistribute outer child and Broadcast inner child, in the optimizer."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_enable_hashjoin_redistribute_broadcast_children,
false,
NULL, NULL, NULL
},
{
{"optimizer_enable_broadcast_nestloop_outer_child", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enable nested loops join plans with replicated outer child in the optimizer."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_enable_broadcast_nestloop_outer_child,
true,
NULL, NULL, NULL
},
{
{"optimizer_expand_fulljoin", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enables the optimizer's support of expanding full outer joins using union all."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_expand_fulljoin,
false,
NULL, NULL, NULL
},
{
{"optimizer_enable_mergejoin", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enables the optimizer's support of merge joins."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_enable_mergejoin,
true,
NULL, NULL, NULL
},
{
{"optimizer_enable_streaming_material", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enable plans with a streaming material node in the optimizer."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_enable_streaming_material,
true,
NULL, NULL, NULL
},
{
{"optimizer_enable_gather_on_segment_for_dml", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enable DML optimization by enforcing a non-master gather in the optimizer."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_enable_gather_on_segment_for_dml,
true,
NULL, NULL, NULL
},
{
{"optimizer_enforce_subplans", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Enforce correlated execution in the optimizer"),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_enforce_subplans,
false,
NULL, NULL, NULL
},
{
{"optimizer_enable_assert_maxonerow", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enable Assert MaxOneRow plans to check number of rows at runtime."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_enable_assert_maxonerow,
true,
NULL, NULL, NULL
},
{
{"optimizer_enumerate_plans", PGC_USERSET, LOGGING_WHAT,
gettext_noop("Enable plan enumeration"),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_enumerate_plans,
false,
NULL, NULL, NULL
},
{
{"optimizer_sample_plans", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Enable plan sampling"),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_sample_plans,
false,
NULL, NULL, NULL
},
{
{"optimizer_cte_inlining", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Enable CTE inlining"),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_cte_inlining,
false,
NULL, NULL, NULL
},
{
{"optimizer_analyze_root_partition", PGC_USERSET, STATS_ANALYZE,
gettext_noop("Enable statistics collection on root partitions during ANALYZE"),
NULL
},
&optimizer_analyze_root_partition,
true,
NULL, NULL, NULL
},
{
{"optimizer_analyze_midlevel_partition", PGC_USERSET, STATS_ANALYZE,
gettext_noop("Enable statistics collection on intermediate partitions during ANALYZE"),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_analyze_midlevel_partition,
false,
NULL, NULL, NULL
},
{
{"optimizer_enable_constant_expression_evaluation", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enable constant expression evaluation in the optimizer"),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_enable_constant_expression_evaluation,
true,
NULL, NULL, NULL
},
{
{"optimizer_use_external_constant_expression_evaluation_for_ints", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Use external constant expression evaluation in the optimizer for all integer types"),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_use_external_constant_expression_evaluation_for_ints,
false,
NULL, NULL, NULL
},
{
{"optimizer_enable_bitmapscan", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enable bitmap plans in the optimizer"),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_enable_bitmapscan,
true,
NULL, NULL, NULL
},
{
{"optimizer_enable_outerjoin_to_unionall_rewrite", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enable rewriting Left Outer Join to UnionAll"),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_enable_outerjoin_to_unionall_rewrite,
false,
NULL, NULL, NULL
},
{
{"optimizer_apply_left_outer_to_union_all_disregarding_stats", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Always apply Left Outer Join to Inner Join UnionAll Left Anti Semi Join without looking at stats."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_apply_left_outer_to_union_all_disregarding_stats,
false,
NULL, NULL, NULL
},
{
{"optimizer_enable_ctas", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enable CTAS plans in the optimizer"),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_enable_ctas,
true,
NULL, NULL, NULL
},
{
{"optimizer_remove_order_below_dml", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Remove OrderBy below a DML operation"),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_remove_order_below_dml,
false,
NULL, NULL, NULL
},
{
{"optimizer_enable_partial_index", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enable heterogeneous index plans."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_enable_partial_index,
true,
NULL, NULL, NULL
},
{
{"optimizer_enable_dml", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enable DML plans in Pivotal Optimizer (GPORCA)."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_enable_dml,
true,
NULL, NULL, NULL
},
{
{"optimizer_enable_dml_constraints", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Support DML with CHECK constraints and NOT NULL constraints."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_enable_dml_constraints,
true,
NULL, NULL, NULL
},
{
{"gp_log_optimization_time", PGC_USERSET, LOGGING_WHAT,
gettext_noop("Writes time spent producing a plan to the server log"),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_log_optimization_time,
false,
NULL, NULL, NULL
},
{
{"gp_reject_internal_tcp_connection", PGC_POSTMASTER,
DEVELOPER_OPTIONS,
gettext_noop("Permit internal TCP connections to the master."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_reject_internal_tcp_conn,
true,
NULL, NULL, NULL
},
{
{"optimizer_force_three_stage_scalar_dqa", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Force optimizer to always pick 3 stage aggregate plan for scalar distinct qualified aggregate."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_force_three_stage_scalar_dqa,
true,
NULL, NULL, NULL
},
{
{"optimizer_parallel_union", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Enable parallel execution for UNION/UNION ALL queries."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_parallel_union,
false,
NULL, NULL, NULL
},
{
{"optimizer_array_constraints", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Allows the optimizer's constraint framework to derive array constraints."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_array_constraints,
true,
NULL, NULL, NULL
},
{
{"optimizer_use_gpdb_allocators", PGC_POSTMASTER, RESOURCES_MEM,
gettext_noop("Enable ORCA to use GPDB Memory Contexts"),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_use_gpdb_allocators,
true,
NULL, NULL, NULL
},
{
{"vmem_process_interrupt", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Checks for interrupts before reserving VMEM"),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&vmem_process_interrupt,
false,
NULL, NULL, NULL
},
{
{"execute_pruned_plan", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Prune plan to discard unwanted plan nodes for each slice before execution"),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&execute_pruned_plan,
true,
NULL, NULL, NULL
},
{
{"pljava_classpath_insecure", PGC_POSTMASTER, CUSTOM_OPTIONS,
gettext_noop("Allow pljava_classpath to be set by user per session"),
NULL,
GUC_SUPERUSER_ONLY | GUC_NOT_IN_SAMPLE
},
&pljava_classpath_insecure,
false,
check_pljava_classpath_insecure, assign_pljava_classpath_insecure, NULL
},
{
{"gp_enable_segment_copy_checking", PGC_USERSET, CUSTOM_OPTIONS,
gettext_noop("Enable check the distribution key restriction on segment for command \"COPY FROM ON SEGMENT\"."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_enable_segment_copy_checking,
true,
NULL, NULL, NULL
},
{
{"gp_ignore_error_table", PGC_USERSET, COMPAT_OPTIONS_PREVIOUS,
gettext_noop("Ignore INTO error-table in external table and COPY (Deprecated)."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_ignore_error_table,
false,
NULL, NULL, NULL
},
{
{"optimizer_enable_associativity", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Enables Join Associativity in optimizer"),
NULL
},
&optimizer_enable_associativity,
false, NULL, NULL
},
{
{"optimizer_replicated_table_insert", PGC_USERSET, STATS_ANALYZE,
gettext_noop("Omit broadcast motion when inserting into replicated table"),
gettext_noop("Only when source is SegmentGeneral or General locus"),
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_replicated_table_insert,
true, NULL, NULL
},
{
{"verify_gpfdists_cert", PGC_USERSET, EXTERNAL_TABLES,
gettext_noop("Verifies the authenticity of the gpfdist's certificate"),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&verify_gpfdists_cert,
true, check_verify_gpfdists_cert, NULL
},
{
{"gp_external_enable_filter_pushdown", PGC_USERSET, EXTERNAL_TABLES,
gettext_noop("Enable passing of query constraints to external table providers"),
NULL
},
&gp_external_enable_filter_pushdown,
true, NULL, NULL
},
{
{"gp_resource_group_bypass", PGC_USERSET, RESOURCES,
gettext_noop("If the value is true, the query in this session will not be limited by resource group."),
NULL
},
&gp_resource_group_bypass,
false,
check_gp_resource_group_bypass, NULL, NULL
},
{
{"gp_resource_group_cpu_ceiling_enforcement", PGC_POSTMASTER, RESOURCES,
gettext_noop("If the value is true, ceiling enforcement of CPU usage will be enabled"),
NULL
},
&gp_resource_group_cpu_ceiling_enforcement,
false, NULL, NULL
},
{
{"gp_resource_group_enable_recalculate_query_mem", PGC_USERSET, RESOURCES,
gettext_noop("Enable resource group re-calculate the query_mem on QE"),
NULL
},
&gp_resource_group_enable_recalculate_query_mem,
true,
NULL, NULL, NULL
},
{
{"stats_queue_level", PGC_SUSET, STATS_COLLECTOR,
gettext_noop("Collects resource queue-level statistics on database activity."),
NULL
},
&pgstat_collect_queuelevel,
false, NULL, NULL
},
{
{"create_restartpoint_on_ckpt_record_replay", PGC_SIGHUP, DEVELOPER_OPTIONS,
gettext_noop("Creates a restartpoint only on mirror immediately after replaying a checkpoint record."),
NULL
},
&create_restartpoint_on_ckpt_record_replay,
false, NULL, NULL
},
{
{"gp_enable_global_deadlock_detector", PGC_POSTMASTER, CUSTOM_OPTIONS,
gettext_noop("Enables the Global Deadlock Detector."),
NULL
},
&gp_enable_global_deadlock_detector,
false, NULL, NULL
},
{
{"gp_log_endpoints", PGC_SUSET, LOGGING_WHAT,
gettext_noop("Prints endpoints information to server log."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_log_endpoints,
false,
NULL, NULL, NULL
},
{
{"gp_allow_date_field_width_5digits", PGC_USERSET, COMPAT_OPTIONS_PREVIOUS,
gettext_noop("Allow parsing input date field with exactly continous 5 digits in non-standard YYYMMDD timeformat (follow pg12+ behave)"),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_allow_date_field_width_5digits,
false,
NULL, NULL, NULL
},
{
{"optimizer_enable_eageragg", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Enable Eager Agg transform for pushing aggregate below an innerjoin."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_enable_eageragg,
false,
NULL, NULL, NULL
},
{
{"optimizer_prune_unused_columns", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Prune unused table columns during query optimization."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_prune_unused_columns,
true,
NULL, NULL, NULL
},
{
{"optimizer_enable_range_predicate_dpe", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Enable range predicates for dynamic partition elimination."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_enable_range_predicate_dpe,
false,
NULL, NULL, NULL
},
{
{"gp_pause_on_restore_point_replay", PGC_SIGHUP, DEVELOPER_OPTIONS,
gettext_noop("Pause recovery when a restore point is replayed."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_pause_on_restore_point_replay,
false,
NULL, NULL, NULL
},
{
{"gp_autostats_allow_nonowner", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Allow automatic stats collection on tables even for users who are not the owner of the relation."),
gettext_noop("If disabled, table statistics will be updated only when tables are modified by the owners of the relations.")
},
&gp_autostats_allow_nonowner,
false,
NULL, NULL, NULL
},
{
{"optimizer_enable_redistribute_nestloop_loj_inner_child", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Enable nested loops left join plans with redistributed inner child in the optimizer."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_enable_redistribute_nestloop_loj_inner_child,
true,
NULL, NULL, NULL
},
{
{"optimizer_force_comprehensive_join_implementation", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Explore a nested loop join even if a hash join is possible"),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_force_comprehensive_join_implementation,
false,
NULL, NULL, NULL
},
{
{"optimizer_enable_replicated_table", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Enable replicated tables."),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_enable_replicated_table,
true,
NULL, NULL, NULL
},
/* End-of-list marker */
{
{NULL, 0, 0, NULL, NULL}, NULL, false, NULL, NULL
}
};
struct config_int ConfigureNamesInt_gp[] =
{
{
{"readable_external_table_timeout", PGC_USERSET, EXTERNAL_TABLES,
gettext_noop("Cancel the query if no data read within N seconds."),
gettext_noop("A value of 0 turns off the timeout."),
GUC_UNIT_S | GUC_NOT_IN_SAMPLE
},
&readable_external_table_timeout,
0, 0, INT_MAX,
NULL, NULL, NULL
},
{
{"gpfdist_retry_timeout", PGC_USERSET, EXTERNAL_TABLES,
gettext_noop("Timeout (in seconds) for writing data to gpfdist server."),
gettext_noop("Default value is 300."),
GUC_UNIT_S | GUC_NOT_IN_SAMPLE
},
&gpfdist_retry_timeout,
300, 1, 7200,
NULL, NULL, NULL
},
{
{"writable_external_table_bufsize", PGC_USERSET, EXTERNAL_TABLES,
gettext_noop("Buffer size in kilobytes for writable external table before writing data to gpfdist."),
gettext_noop("Valid value is between 32K and 128M: [32, 131072]."),
GUC_UNIT_KB | GUC_NOT_IN_SAMPLE
},
&writable_external_table_bufsize,
64, 32, 131072,
NULL, NULL, NULL
},
{
{"gp_max_local_distributed_cache", PGC_POSTMASTER, RESOURCES_MEM,
gettext_noop("Sets the number of local-distributed transactions to cache for optimizing visibility processing by backends."),
NULL
},
&gp_max_local_distributed_cache,
1024, 0, INT_MAX,
NULL, NULL, NULL
},
{
{"debug_dtm_action_segment", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Sets the debug DTM action segment."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&Debug_dtm_action_segment,
DEBUG_DTM_ACTION_SEGMENT_DEFAULT, -2, 1000,
NULL, NULL, NULL
},
{
{"debug_dtm_action_nestinglevel", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Sets the debug DTM action transaction nesting level."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&Debug_dtm_action_nestinglevel,
DEBUG_DTM_ACTION_NESTINGLEVEL_DEFAULT, 0, 1000,
NULL, NULL, NULL
},
{
{"gp_safefswritesize", PGC_BACKEND, RESOURCES,
gettext_noop("Minimum FS safe write size."),
NULL
},
&gp_safefswritesize,
DEFAULT_FS_SAFE_WRITE_SIZE, 0, INT_MAX,
NULL, NULL, NULL
},
{
{"planner_work_mem", PGC_USERSET, RESOURCES_MEM,
gettext_noop("Sets the maximum memory to be used for query workspaces, "
"used in the planner only."),
gettext_noop("The planner considers this much memory may be used by each internal "
"sort operation and hash table before switching to "
"temporary disk files."),
GUC_UNIT_KB | GUC_NOT_IN_SAMPLE | GUC_NO_SHOW_ALL
},
&planner_work_mem,
32768, 2 * BLCKSZ / 1024, MAX_KILOBYTES,
NULL, NULL, NULL
},
{
{"statement_mem", PGC_USERSET, RESOURCES_MEM,
gettext_noop("Sets the memory to be reserved for a statement."),
NULL,
GUC_UNIT_KB
},
&statement_mem,
#ifdef USE_ASSERT_CHECKING
/** Allow lower values for testing */
128000, 50, INT_MAX,
#else
128000, 1000, INT_MAX,
#endif
gpvars_check_statement_mem, NULL, NULL
},
{
{"memory_spill_ratio", PGC_USERSET, RESOURCES_MEM,
gettext_noop("Sets the memory_spill_ratio for resource group."),
NULL
},
&memory_spill_ratio,
20, 0, 100,
NULL, NULL, NULL
},
{
{"gp_resource_group_cpu_priority", PGC_POSTMASTER, RESOURCES,
gettext_noop("Sets the cpu priority for postgres processes when resource group is enabled."),
NULL
},
&gp_resource_group_cpu_priority,
10, 1, 256,
NULL, NULL, NULL
},
{
{"max_statement_mem", PGC_SUSET, RESOURCES_MEM,
gettext_noop("Sets the maximum value for statement_mem setting."),
NULL,
GUC_UNIT_KB
},
&max_statement_mem,
2048000, 32768, INT_MAX,
NULL, NULL, NULL
},
{
{"gp_vmem_limit_per_query", PGC_POSTMASTER, RESOURCES_MEM,
gettext_noop("Sets the maximum allowed memory per-statement on each segment."),
NULL,
GUC_UNIT_KB | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_vmem_limit_per_query,
0, 0, INT_MAX / 2,
NULL, NULL, NULL
},
{
{"gp_max_plan_size", PGC_SUSET, RESOURCES_MEM,
gettext_noop("Sets the maximum size of a plan to be dispatched."),
NULL,
GUC_UNIT_KB
},
&gp_max_plan_size,
0, 0, MAX_KILOBYTES,
NULL, NULL, NULL
},
{
{"gp_appendonly_compaction_threshold", PGC_USERSET, APPENDONLY_TABLES,
gettext_noop("Threshold of the ratio of dirty data in a segment file over which the file"
" will be compacted during lazy vacuum."),
NULL
},
&gp_appendonly_compaction_threshold,
10, 0, 100,
NULL, NULL, NULL
},
{
{"gp_workfile_max_entries", PGC_POSTMASTER, RESOURCES,
gettext_noop("Sets the maximum number of entries that can be stored in the workfile directory"),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_workfile_max_entries,
8192, 32, INT_MAX,
NULL, NULL, NULL
},
{
{"gp_workfile_limit_files_per_query", PGC_USERSET, RESOURCES,
gettext_noop("Maximum number of workfiles allowed per query per segment."),
gettext_noop("0 for no limit. Current query is terminated when limit is exceeded.")
},
&gp_workfile_limit_files_per_query,
100000, 0, INT_MAX,
NULL, NULL, NULL
},
{
{"gp_workfile_limit_per_segment", PGC_POSTMASTER, RESOURCES,
gettext_noop("Maximum disk space (in KB) used for workfiles per segment."),
gettext_noop("0 for no limit. Current query is terminated when limit is exceeded."),
GUC_UNIT_KB
},
&gp_workfile_limit_per_segment,
0, 0, INT_MAX,
NULL, NULL, NULL
},
{
{"gp_workfile_limit_per_query", PGC_USERSET, RESOURCES,
gettext_noop("Maximum disk space (in KB) used for workfiles per query per segment."),
gettext_noop("0 for no limit. Current query is terminated when limit is exceeded."),
GUC_UNIT_KB
},
&gp_workfile_limit_per_query,
0, 0, INT_MAX,
NULL, NULL, NULL
},
{
{"gp_vmem_idle_resource_timeout", PGC_USERSET, CLIENT_CONN_OTHER,
gettext_noop("Sets the time a session can be idle (in milliseconds) before we release gangs on the segment DBs to free resources."),
gettext_noop("A value of 0 turns off the timeout."),
GUC_UNIT_MS
},
&IdleSessionGangTimeout,
#ifdef USE_ASSERT_CHECKING
600000, 0, INT_MAX, /* 10 minutes by default on debug
* builds. */
#else
18000, 0, INT_MAX,
#endif
NULL, NULL, NULL
},
{
{"xid_stop_limit", PGC_POSTMASTER, WAL,
gettext_noop("Sets the number of XIDs before XID wraparound at which we will no longer allow the system to be started."),
NULL,
GUC_NOT_IN_SAMPLE | GUC_NO_SHOW_ALL
},
&xid_stop_limit,
100000000, 10000000, INT_MAX,
NULL, NULL, NULL
},
{
{"xid_warn_limit", PGC_POSTMASTER, WAL,
gettext_noop("Sets the number of XIDs before xid_stop_limit at which we will begin emitting warnings regarding XID wraparound."),
NULL,
GUC_NOT_IN_SAMPLE | GUC_NO_SHOW_ALL
},
&xid_warn_limit,
500000000, 10000000, INT_MAX,
NULL, NULL, NULL
},
{
{"gp_gxid_prefetch_num", PGC_POSTMASTER, WAL,
gettext_noop("how many gxid is prefetched in each bumping batch."),
NULL,
GUC_NOT_IN_SAMPLE | GUC_NO_SHOW_ALL
},
&gp_gxid_prefetch_num,
8192, 512, INT_MAX,
NULL, NULL, NULL
},
{
{"gp_dbid", PGC_POSTMASTER, PRESET_OPTIONS,
gettext_noop("The dbid used by this server."),
NULL,
GUC_NOT_IN_SAMPLE | GUC_DISALLOW_IN_FILE
},
&GpIdentity.dbid,
UNINITIALIZED_GP_IDENTITY_VALUE, INT_MIN, INT_MAX,
NULL, NULL, NULL
},
{
{"gp_contentid", PGC_POSTMASTER, PRESET_OPTIONS,
gettext_noop("The contentid used by this server."),
NULL,
GUC_NOT_IN_SAMPLE | GUC_DISALLOW_IN_FILE
},
&GpIdentity.segindex,
UNINITIALIZED_GP_IDENTITY_VALUE, INT_MIN, INT_MAX,
NULL, NULL, NULL
},
/*
* Solaris doesn't support setting SO_SNDTIMEO, so setting this won't work
* on Solaris (MPP-22526)
*/
{
{"gp_connection_send_timeout", PGC_SIGHUP, CLIENT_CONN_OTHER,
gettext_noop("Timeout for sending data to unresponsive clients (seconds)"),
gettext_noop("A value of 0 uses the system default."),
},
&gp_connection_send_timeout,
3600, 0, INT_MAX,
NULL, NULL, NULL
},
{
{"max_resource_queues", PGC_POSTMASTER, RESOURCES_MGM,
gettext_noop("Maximum number of resource queues."),
NULL
},
&MaxResourceQueues,
9, 0, INT_MAX,
NULL, NULL, NULL
},
{
{"max_resource_portals_per_transaction", PGC_POSTMASTER, RESOURCES_MGM,
gettext_noop("Maximum number of resource queues."),
NULL
},
&MaxResourcePortalsPerXact,
64, 0, INT_MAX,
NULL, NULL, NULL
},
{
{"gp_external_max_segs", PGC_USERSET, EXTERNAL_TABLES,
gettext_noop("Maximum number of segments that connect to a single gpfdist URL."),
NULL
},
&gp_external_max_segs,
64, 1, INT_MAX,
NULL, NULL, NULL
},
{
{"gp_max_packet_size", PGC_BACKEND, GP_ARRAY_TUNING,
gettext_noop("Sets the max packet size for the Interconnect."),
NULL
},
&Gp_max_packet_size,
DEFAULT_PACKET_SIZE, MIN_PACKET_SIZE, MAX_PACKET_SIZE,
NULL, NULL, NULL
},
{
{"gp_interconnect_queue_depth", PGC_USERSET, GP_ARRAY_TUNING,
gettext_noop("Sets the maximum size of the receive queue for each connection in the UDP interconnect"),
NULL
},
&Gp_interconnect_queue_depth,
4, 1, 4096,
NULL, NULL, NULL
},
{
{"gp_interconnect_snd_queue_depth", PGC_USERSET, GP_ARRAY_TUNING,
gettext_noop("Sets the maximum size of the send queue for each connection in the UDP interconnect"),
NULL
},
&Gp_interconnect_snd_queue_depth,
2, 1, 4096,
NULL, NULL, NULL
},
{
{"gp_interconnect_timer_period", PGC_USERSET, GP_ARRAY_TUNING,
gettext_noop("Sets the timer period (in ms) for UDP interconnect"),
NULL,
GUC_UNIT_MS
},
&Gp_interconnect_timer_period,
5, 1, 100,
NULL, NULL, NULL
},
{
{"gp_interconnect_timer_checking_period", PGC_USERSET, GP_ARRAY_TUNING,
gettext_noop("Sets the timer checking period (in ms) for UDP interconnect"),
NULL,
GUC_UNIT_MS
},
&Gp_interconnect_timer_checking_period,
20, 1, 100,
NULL, NULL, NULL
},
{
{"gp_interconnect_default_rtt", PGC_USERSET, GP_ARRAY_TUNING,
gettext_noop("Sets the default rtt (in ms) for UDP interconnect"),
NULL,
GUC_UNIT_MS
},
&Gp_interconnect_default_rtt,
20, 1, 1000,
NULL, NULL, NULL
},
{
{"gp_interconnect_min_rto", PGC_USERSET, GP_ARRAY_TUNING,
gettext_noop("Sets the min rto (in ms) for UDP interconnect"),
NULL,
GUC_UNIT_MS
},
&Gp_interconnect_min_rto,
20, 1, 1000,
NULL, NULL, NULL
},
{
{"gp_interconnect_transmit_timeout", PGC_USERSET, GP_ARRAY_TUNING,
gettext_noop("Timeout (in seconds) on interconnect to transmit a packet"),
gettext_noop("Used by Interconnect to timeout packet transmission."),
GUC_UNIT_S
},
&Gp_interconnect_transmit_timeout,
3600, 1, 7200,
NULL, NULL, NULL
},
{
{"gp_interconnect_min_retries_before_timeout", PGC_USERSET, GP_ARRAY_TUNING,
gettext_noop("Sets the min retries before reporting a transmit timeout in the interconnect."),
NULL
},
&Gp_interconnect_min_retries_before_timeout,
100, 1, 4096,
NULL, NULL, NULL
},
{
{"gp_interconnect_debug_retry_interval", PGC_USERSET, GP_ARRAY_TUNING,
gettext_noop("Sets the interval by retry times to record a debug message for retry."),
NULL
},
&Gp_interconnect_debug_retry_interval,
10, 1, 4096,
NULL, NULL, NULL
},
{
{"gp_udp_bufsize_k", PGC_BACKEND, GP_ARRAY_TUNING,
gettext_noop("Sets recv buf size of UDP interconnect, for testing."),
NULL
},
&Gp_udp_bufsize_k,
0, 0, 32768,
NULL, NULL, NULL
},
#ifdef USE_ASSERT_CHECKING
{
{"gp_udpic_dropseg", PGC_USERSET, GP_ARRAY_TUNING,
gettext_noop("Specifies a segment to which the dropacks, and dropxmit settings will be applied, for testing. (The default is to apply the dropacks and dropxmit settings to all segments)"),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_udpic_dropseg,
UNDEF_SEGMENT, UNDEF_SEGMENT, INT_MAX,
NULL, NULL, NULL
},
{
{"gp_udpic_dropacks_percent", PGC_USERSET, GP_ARRAY_TUNING,
gettext_noop("Sets the percentage of correctly-received acknowledgment packets to synthetically drop, for testing. (affected by gp_udpic_dropseg)"),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_udpic_dropacks_percent,
0, 0, 100,
NULL, NULL, NULL
},
{
{"gp_udpic_dropxmit_percent", PGC_USERSET, GP_ARRAY_TUNING,
gettext_noop("Sets the percentage of correctly-received data packets to synthetically drop, for testing. (affected by gp_udpic_dropseg)"),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_udpic_dropxmit_percent,
0, 0, 100,
NULL, NULL, NULL
},
{
{"gp_udpic_fault_inject_percent", PGC_USERSET, GP_ARRAY_TUNING,
gettext_noop("Sets the percentage of fault injected into system calls, for testing. (affected by gp_udpic_dropseg)"),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_udpic_fault_inject_percent,
0, 0, 100,
NULL, NULL, NULL
},
{
{"gp_udpic_fault_inject_bitmap", PGC_USERSET, GP_ARRAY_TUNING,
gettext_noop("Sets the bitmap for faults injection, for testing. (affected by gp_udpic_dropseg)"),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_udpic_fault_inject_bitmap,
0, 0, INT_MAX,
NULL, NULL, NULL
},
{
{"gp_udpic_network_disable_ipv6", PGC_USERSET, GP_ARRAY_TUNING,
gettext_noop("Sets the address info hint to disable the ipv6, for testing. (affected by gp_udpic_dropseg)"),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_udpic_network_disable_ipv6,
0, 0, 1,
NULL, NULL, NULL
},
#endif
{
{"gp_command_count", PGC_INTERNAL, CLIENT_CONN_OTHER,
gettext_noop("Shows the number of commands received from the client in this session."),
NULL,
GUC_NOT_IN_SAMPLE | GUC_DISALLOW_IN_FILE
},
&gp_command_count,
0, 0, INT_MAX, NULL, NULL
},
{
{"gp_subtrans_warn_limit", PGC_POSTMASTER, RESOURCES,
gettext_noop("Sets the warning limit on number of subtransactions in a transaction."),
NULL,
GUC_NOT_IN_SAMPLE
},
&gp_subtrans_warn_limit,
16777216, 0, INT_MAX,
NULL, NULL, NULL
},
{
{"gp_cached_segworkers_threshold", PGC_USERSET, GP_ARRAY_TUNING,
gettext_noop("Sets the maximum number of segment workers to cache between statements."),
NULL,
GUC_NOT_IN_SAMPLE
},
&gp_cached_gang_threshold,
5, 1, INT_MAX,
NULL, NULL, NULL
},
{
{"gp_debug_linger", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Number of seconds for QD/QE process to linger upon fatal internal error."),
gettext_noop("Allows an opportunity to debug the backend process before it terminates."),
GUC_NOT_IN_SAMPLE | GUC_NO_RESET_ALL | GUC_UNIT_S
},
&gp_debug_linger,
0, 0, 3600,
NULL, NULL, NULL
},
{
{"gp_qd_port", PGC_BACKEND, GP_WORKER_IDENTITY,
gettext_noop("Shows the Master Postmaster port."),
gettext_noop("0 for a session's entry process (qDisp)"),
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE | GUC_DISALLOW_IN_FILE
},
&qdPostmasterPort,
0, INT_MIN, INT_MAX,
NULL, NULL, NULL
},
{
{"gp_interconnect_setup_timeout", PGC_USERSET, GP_ARRAY_TUNING,
gettext_noop("Timeout (in seconds) on interconnect setup that occurs at query start"),
gettext_noop("Used by Interconnect to timeout the setup of the communication fabric."),
GUC_UNIT_S
},
&interconnect_setup_timeout,
7200, 0, 7200,
NULL, NULL, NULL
},
{
{"gp_interconnect_tcp_listener_backlog", PGC_USERSET, GP_ARRAY_TUNING,
gettext_noop("Size of the listening queue for each TCP interconnect socket"),
gettext_noop("Cooperate with kernel parameter net.core.somaxconn and net.ipv4.tcp_max_syn_backlog to tune network performance."),
GUC_NOT_IN_SAMPLE
},
&listenerBacklog,
/*
* GPDB_12_MERGE_FIXME: in order to make case DML_over_joins
* pass under tcp interconnect mode, enlarge this GUC's default
* value to 256 as a work-around. Without this change, the case
* will throw warnings like:
* +HINT: Try enlarging the gp_interconnect_tcp_listener_backlog GUC value and OS net.core.somaxconn parameter
* +WARNING: SetupTCPInterconnect: too many expected incoming connections(144), Interconnect setup might possibly fail
* This is because the plan fallback from orca to planner, and planner
* removes the motion under modifytable plannode by the PR: https://github.com/greenplum-db/gpdb/pull/9183
* We should consider to remove the locus check in the PR 9183 and that would fix the case.
* Also we should find out why orca fallback to planner for this simple case.
*/
256, 0, 65535,
NULL, NULL, NULL
},
{
{"gp_snapshotadd_timeout", PGC_USERSET, GP_ARRAY_TUNING,
gettext_noop("Timeout (in seconds) on setup of new connection snapshot"),
gettext_noop("Used by the transaction manager."),
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE | GUC_UNIT_S
},
&gp_snapshotadd_timeout,
30, 0, INT_MAX,
NULL, NULL, NULL
},
{
{"gp_segment_connect_timeout", PGC_USERSET, GP_ARRAY_TUNING,
gettext_noop("Maximum time (in seconds) allowed for a new worker process to start or a mirror to respond."),
gettext_noop("0 indicates 'wait forever'."),
GUC_UNIT_S
},
&gp_segment_connect_timeout,
180, 0, INT_MAX,
NULL, NULL, NULL
},
{
{"gp_fts_probe_retries", PGC_SIGHUP, GP_ARRAY_TUNING,
gettext_noop("Number of retries for FTS to complete probing a segment."),
gettext_noop("Used by the fts-probe process."),
},
&gp_fts_probe_retries,
5, 0, 100,
NULL, NULL, NULL
},
{
{"gp_fts_probe_timeout", PGC_SIGHUP, GP_ARRAY_TUNING,
gettext_noop("Maximum time (in seconds) allowed for FTS to complete probing a segment."),
gettext_noop("Used by the fts-probe process."),
GUC_UNIT_S
},
&gp_fts_probe_timeout,
20, 0, 3600,
NULL, NULL, NULL
},
{
{"gp_fts_probe_interval", PGC_SIGHUP, GP_ARRAY_TUNING,
gettext_noop("A complete probe of all segments starts each time a timer with this period expires."),
gettext_noop("Used by the fts-probe process. "),
GUC_UNIT_S
},
&gp_fts_probe_interval,
60, 10, 3600,
NULL, NULL, NULL
},
{
{"gp_fts_mark_mirror_down_grace_period", PGC_SIGHUP, GP_ARRAY_TUNING,
gettext_noop("Time (in seconds) allowed to mirror after disconnection, to reconnect before being marked as down in configuration by FTS."),
gettext_noop("Used by the fts-probe process."),
GUC_UNIT_S
},
&gp_fts_mark_mirror_down_grace_period,
30, 0, 3600,
NULL, NULL, NULL
},
{
{"gp_fts_replication_attempt_count", PGC_SIGHUP, GP_ARRAY_TUNING,
gettext_noop("Primary-mirror replication connection max continuously attempt count for FTS"),
gettext_noop("Used by the fts-probe process.")
},
&gp_fts_replication_attempt_count,
10, 0, 100,
NULL, NULL, NULL
},
{
{"gp_dtx_recovery_interval", PGC_SIGHUP, GP_ARRAY_TUNING,
gettext_noop("A complete checking in dtx recovery process starts each time a timer with this period expires."),
gettext_noop("Used by the dtx recovery process. "),
GUC_UNIT_S
},
&gp_dtx_recovery_interval,
60, 5, 3600,
NULL, NULL, NULL
},
{
{"gp_dtx_recovery_prepared_period", PGC_SIGHUP, GP_ARRAY_TUNING,
gettext_noop("Gather prepared transactions before the time (in seconds) to find potential orphaned ones."),
gettext_noop("Used by the dtx recovery process. "),
GUC_UNIT_S
},
&gp_dtx_recovery_prepared_period,
120, 0, 3600,
NULL, NULL, NULL
},
{
{"gp_gang_creation_retry_count", PGC_USERSET, GP_ARRAY_TUNING,
gettext_noop("After a gang-creation fails, retry the number of times if failure is retryable."),
gettext_noop("A value of zero disables retries."),
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_gang_creation_retry_count,
5, 0, 128,
NULL, NULL, NULL
},
{
{"gp_gang_creation_retry_timer", PGC_USERSET, GP_ARRAY_TUNING,
gettext_noop("Wait this many milliseconds between gang-creation-retries."),
NULL,
GUC_UNIT_MS | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_gang_creation_retry_timer,
2000, 100, 120000,
NULL, NULL, NULL
},
{
{"gp_session_id", PGC_BACKEND, CLIENT_CONN_OTHER,
gettext_noop("Global ID used to uniquely identify a particular session in an Greenplum Database array"),
NULL,
GUC_NOT_IN_SAMPLE | GUC_DISALLOW_IN_FILE
},
&gp_session_id,
-1, INT_MIN, INT_MAX,
NULL, NULL, NULL
},
{
{"gp_segments_for_planner", PGC_USERSET, QUERY_TUNING_COST,
gettext_noop("If >0, number of segment dbs for the planner to assume in its cost and size estimates."),
gettext_noop("If 0, estimates are based on the actual number of segment dbs.")
},
&gp_segments_for_planner,
0, 0, INT_MAX,
NULL, NULL, NULL
},
{
{"gp_hashjoin_tuples_per_bucket", PGC_USERSET, GP_ARRAY_TUNING,
gettext_noop("Target density of hashtable used by Hashjoin during execution"),
gettext_noop("A smaller value will tend to produce larger hashtables, which increases join performance"),
GUC_NOT_IN_SAMPLE
},
&gp_hashjoin_tuples_per_bucket,
5, 1, 25,
NULL, NULL, NULL
},
{
{"gp_hashagg_groups_per_bucket", PGC_USERSET, GP_ARRAY_TUNING,
gettext_noop("Target density of hashtable used by Hashagg during execution"),
gettext_noop("A smaller value will tend to produce larger hashtables, which increases agg performance"),
GUC_NOT_IN_SAMPLE | GUC_NO_SHOW_ALL
},
&gp_hashagg_groups_per_bucket,
5, 1, 25,
NULL, NULL, NULL
},
{
{"gp_hashagg_default_nbatches", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Default number of batches for hashagg's (re-)spilling phases."),
gettext_noop("Must be a power of two."),
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_hashagg_default_nbatches,
32, 4, 1048576,
check_gp_hashagg_default_nbatches, NULL, NULL
},
{
{"gp_motion_slice_noop", PGC_USERSET, GP_ARRAY_TUNING,
gettext_noop("Make motion nodes in certain slices noop"),
gettext_noop("Make motion nodes noop, to help analyze performance"),
GUC_NOT_IN_SAMPLE | GUC_NO_SHOW_ALL
},
&gp_motion_slice_noop,
0, 0, INT_MAX,
NULL, NULL, NULL
},
{
{"gp_reject_percent_threshold", PGC_USERSET, GP_ERROR_HANDLING,
gettext_noop("Reject limit in percent starts calculating after this number of rows processed"),
NULL
},
&gp_reject_percent_threshold,
300, 0, INT_MAX,
NULL, NULL, NULL
},
{
{"gp_instrument_shmem_size", PGC_POSTMASTER, UNGROUPED,
gettext_noop("Sets the size of shmem allocated for instrumentation."),
NULL,
GUC_UNIT_KB
},
&gp_instrument_shmem_size,
5120, 0, 131072,
NULL, NULL, NULL
},
{
{"gp_vmem_protect_limit", PGC_POSTMASTER, RESOURCES_MEM,
gettext_noop("Virtual memory limit (in MB) of Greenplum memory protection."),
NULL,
},
&gp_vmem_protect_limit,
8192, 0, INT_MAX / 2,
NULL, NULL, NULL
},
{
{"runaway_detector_activation_percent", PGC_POSTMASTER, RESOURCES_MEM,
gettext_noop("The runaway detector activates if the used vmem exceeds this percentage of the vmem quota. Set to 0 or 100 to disable runaway detection."),
NULL,
},
&runaway_detector_activation_percent,
90, 0, 100,
NULL, NULL, NULL
},
{
{"gp_vmem_protect_segworker_cache_limit", PGC_POSTMASTER, RESOURCES_MEM,
gettext_noop("Max virtual memory limit (in MB) for a segworker to be cachable."),
NULL,
},
&gp_vmem_protect_gang_cache_limit,
500, 1, INT_MAX / 2,
NULL, NULL, NULL
},
{
{"gp_autostats_on_change_threshold", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Threshold for number of tuples added to table by CTAS or Insert-to to trigger autostats in on_change mode. See gp_autostats_mode."),
NULL
},
&gp_autostats_on_change_threshold,
INT_MAX, 0, INT_MAX,
NULL, NULL, NULL
},
{
{"gp_resqueue_priority_local_interval", PGC_POSTMASTER, RESOURCES_MGM,
gettext_noop("A measure of how often a backend process must consider backing off."),
NULL,
GUC_NO_SHOW_ALL
},
&gp_resqueue_priority_local_interval,
100000, 500, INT_MAX,
NULL, NULL, NULL
},
{
{"gp_resqueue_priority_sweeper_interval", PGC_POSTMASTER, RESOURCES_MGM,
gettext_noop("Frequency (in ms) at which sweeper process re-evaluates CPU shares."),
NULL
},
&gp_resqueue_priority_sweeper_interval,
1000, 500, 15000,
NULL, NULL, NULL
},
{
{"gp_resqueue_priority_inactivity_timeout", PGC_POSTMASTER, RESOURCES_MGM,
gettext_noop("If a backend does not report progress in this time (in ms), it is deemed inactive."),
NULL,
GUC_NO_SHOW_ALL
},
&gp_resqueue_priority_inactivity_timeout,
2000, 500, INT_MAX,
NULL, NULL, NULL
},
{
{"gp_resqueue_priority_grouping_timeout", PGC_POSTMASTER, RESOURCES_MGM,
gettext_noop("A backend gives up on finding a better group leader after this timeout (in ms)."),
NULL,
GUC_NO_SHOW_ALL
},
&gp_resqueue_priority_grouping_timeout,
1000, 1000, INT_MAX,
NULL, NULL, NULL
},
{
{"gp_resource_group_queuing_timeout", PGC_USERSET, RESOURCES_MGM,
gettext_noop("A transaction gives up on queuing on a resource group after this timeout (in ms)."),
NULL,
GUC_UNIT_MS
},
&gp_resource_group_queuing_timeout,
0, 0, INT_MAX,
NULL, NULL, NULL
},
{
{"gp_blockdirectory_entry_min_range", PGC_USERSET, GP_ARRAY_TUNING,
gettext_noop("Minimal range in bytes one block directory entry covers."),
gettext_noop("Used to reduce the size of a block directory."),
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_blockdirectory_entry_min_range,
0, 0, INT_MAX,
NULL, NULL, NULL
},
{
{"gp_blockdirectory_minipage_size", PGC_USERSET, GP_ARRAY_TUNING,
gettext_noop("Number of entries one row in a block directory table contains."),
gettext_noop("Use smaller value in non-bulk load cases."),
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_blockdirectory_minipage_size,
NUM_MINIPAGE_ENTRIES, 1, NUM_MINIPAGE_ENTRIES,
NULL, NULL, NULL
},
{
{"gp_segworker_relative_priority", PGC_POSTMASTER, RESOURCES_MGM,
gettext_noop("Priority for the segworkers relative to the postmaster's priority."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_segworker_relative_priority,
PRIO_MAX, 0, PRIO_MAX,
NULL, NULL, NULL
},
/* for pljava */
{
{"pljava_statement_cache_size", PGC_SUSET, CUSTOM_OPTIONS,
gettext_noop("Size of the prepared statement MRU cache"),
NULL,
GUC_NOT_IN_SAMPLE | GUC_SUPERUSER_ONLY
},
&pljava_statement_cache_size,
0, 0, 512,
NULL, NULL, NULL
},
{
{"gp_resqueue_memory_policy_auto_fixed_mem", PGC_USERSET, RESOURCES_MEM,
gettext_noop("Sets the fixed amount of memory reserved for non-memory intensive operators in the AUTO policy."),
NULL,
GUC_UNIT_KB | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_resqueue_memory_policy_auto_fixed_mem,
100, 50, INT_MAX,
NULL, NULL, NULL
},
{
{"gp_resgroup_memory_policy_auto_fixed_mem", PGC_USERSET, RESOURCES_MEM,
gettext_noop("Sets the fixed amount of memory reserved for non-memory intensive operators in the AUTO policy."),
NULL,
GUC_UNIT_KB | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_resgroup_memory_policy_auto_fixed_mem,
100, 50, INT_MAX,
NULL, NULL, NULL
},
{
{"gp_global_deadlock_detector_period", PGC_SIGHUP, LOCK_MANAGEMENT,
gettext_noop("Sets the executing period of global deadlock detector backend."),
NULL,
GUC_UNIT_S
},
&gp_global_deadlock_detector_period,
120, 5, INT_MAX, NULL, NULL
},
{
{"optimizer_plan_id", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Choose a plan alternative"),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_plan_id,
0, 0, INT_MAX,
NULL, NULL, NULL
},
{
{"optimizer_samples_number", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Set the number of plan samples"),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_samples_number,
1000, 1, INT_MAX,
NULL, NULL, NULL
},
{
{"optimizer_cte_inlining_bound", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Set the CTE inlining cutoff"),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_cte_inlining_bound,
0, 0, INT_MAX,
NULL, NULL, NULL
},
{
{"optimizer_segments", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Number of segments to be considered by the optimizer during costing, or 0 to take the actual number of segments."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_segments,
0, 0, INT_MAX,
NULL, NULL, NULL
},
{
{"optimizer_array_expansion_threshold", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Item limit for expansion of arrays in WHERE clause for constraint derivation."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_array_expansion_threshold,
100, 0, INT_MAX,
NULL, NULL, NULL
},
{
{"optimizer_push_group_by_below_setop_threshold", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Maximum number of children setops have to consider pushing group bys below it"),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_push_group_by_below_setop_threshold,
10, 0, INT_MAX,
NULL, NULL, NULL
},
{
{"optimizer_xform_bind_threshold", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Maximum number bindings per xform per group expression"),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_xform_bind_threshold,
0, 0, INT_MAX,
NULL, NULL, NULL
},
{
{"optimizer_join_order_threshold", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Maximum number of join children to use dynamic programming based join ordering algorithm."),
NULL
},
&optimizer_join_order_threshold,
10, 0, 12,
NULL, NULL, NULL
},
{
{"optimizer_join_arity_for_associativity_commutativity", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Maximum number of children n-ary-join have without disabling commutativity and associativity transform"),
NULL,
GUC_NOT_IN_SAMPLE
},
&optimizer_join_arity_for_associativity_commutativity,
18, 0, INT_MAX,
NULL, NULL, NULL
},
{
{"optimizer_penalize_broadcast_threshold", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Maximum number of rows of a relation that can be broadcasted without penalty."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_penalize_broadcast_threshold,
100000, 0, INT_MAX,
NULL, NULL, NULL
},
{
{"optimizer_mdcache_size", PGC_USERSET, RESOURCES_MEM,
gettext_noop("Sets the size of MDCache."),
NULL,
GUC_UNIT_KB
},
&optimizer_mdcache_size,
16384, 0, INT_MAX,
NULL, NULL, NULL
},
{
{"memory_profiler_dataset_size", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Set the size in GB"),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&memory_profiler_dataset_size,
0, 0, INT_MAX,
NULL, NULL, NULL
},
{
{"repl_catchup_within_range", PGC_SUSET, REPLICATION_STANDBY,
gettext_noop("Sets the maximum number of xlog segments allowed to lag"
" when the backends can start blocking despite the WAL"
" sender being in catchup phase. (Master Mirroring)"),
NULL,
GUC_SUPERUSER_ONLY
},
&repl_catchup_within_range,
1, 0, INT_MAX / WalSegMaxSize,
NULL, NULL, NULL
},
{
{"wait_for_replication_threshold", PGC_SIGHUP, REPLICATION_MASTER,
gettext_noop("Maximum amount of WAL written by a transaction prior to waiting for replication."),
gettext_noop("This is used just to prevent primary from racing too ahead "
"and avoid huge replication lag. A value of 0 disables "
"the behavior"),
GUC_UNIT_KB
},
&rep_lag_avoidance_threshold,
1024, 0, MAX_KILOBYTES,
NULL, NULL, NULL
},
{
{"gp_initial_bad_row_limit", PGC_USERSET, EXTERNAL_TABLES,
gettext_noop("Stops processing when number of the first bad rows exceeding this value"),
NULL
},
&gp_initial_bad_row_limit,
1000, 0, INT_MAX,
NULL, NULL, NULL
},
{
{"gp_indexcheck_insert", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Validate that a unique index does not already have the new tid during insert."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
(int *) &gp_indexcheck_insert,
INDEX_CHECK_NONE, 0, INDEX_CHECK_ALL,
NULL, NULL, NULL
},
{
{"dtx_phase2_retry_second", PGC_SUSET, GP_ARRAY_TUNING,
gettext_noop("Maximum time for which coordinator tries to finish a prepared transaction"),
gettext_noop("The timer starts if finising a prepared transaction fails."
" Coordinator keeps retrying the finish-prepared operation"
" until this timeout (seconds)."),
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE | GUC_UNIT_S
},
&dtx_phase2_retry_second,
60, 0, INT_MAX,
NULL, NULL, NULL
},
{
/* Can't be set in postgresql.conf */
{"gp_server_version_num", PGC_INTERNAL, PRESET_OPTIONS,
gettext_noop("Shows the Greenplum server version as an integer."),
NULL,
GUC_NOT_IN_SAMPLE | GUC_DISALLOW_IN_FILE
},
&gp_server_version_num,
GP_VERSION_NUM, GP_VERSION_NUM, GP_VERSION_NUM,
NULL, NULL, NULL
},
{
{"gp_max_slices", PGC_USERSET, PRESET_OPTIONS,
gettext_noop("Maximum slices for a single query"),
NULL,
GUC_NOT_IN_SAMPLE
},
&gp_max_slices,
0, 0, INT_MAX, NULL, NULL
},
{
{"gp_dispatch_keepalives_idle", PGC_POSTMASTER, GP_ARRAY_TUNING,
gettext_noop("Time between issuing TCP keepalives from GPDB QD to its QEs."),
gettext_noop("A value of 0 uses the system default."),
GUC_UNIT_S | GUC_NOT_IN_SAMPLE
},
&gp_dispatch_keepalives_idle,
0, 0, MAX_GP_DISPATCH_KEEPALIVES_IDLE,
NULL, NULL, NULL
},
{
{"gp_dispatch_keepalives_interval", PGC_POSTMASTER, GP_ARRAY_TUNING,
gettext_noop("Time between TCP keepalive retransmits from GPDB QD to its QEs."),
gettext_noop("A value of 0 uses the system default."),
GUC_UNIT_S | GUC_NOT_IN_SAMPLE
},
&gp_dispatch_keepalives_interval,
0, 0, MAX_GP_DISPATCH_KEEPALIVES_INTERVAL,
NULL, NULL, NULL
},
{
{"gp_dispatch_keepalives_count", PGC_POSTMASTER, GP_ARRAY_TUNING,
gettext_noop("Maximum number of TCP keepalive retransmits from GPDB QD to its QEs."),
gettext_noop("This controls the number of consecutive keepalive retransmits that can be "
"lost before a QD/QE connection is considered dead. A value of 0 uses the "
"system default."),
GUC_NOT_IN_SAMPLE
},
&gp_dispatch_keepalives_count,
0, 0, MAX_GP_DISPATCH_KEEPALIVES_COUNT,
NULL, NULL, NULL
},
/* End-of-list marker */
{
{NULL, 0, 0, NULL, NULL}, NULL, 0, 0, 0, NULL, NULL
}
};
struct config_real ConfigureNamesReal_gp[] =
{
{
{"disable_cost", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Sets the planner's cost of a disabled path."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&disable_cost,
1.0e10, 1.0e10, 1.0e30,
NULL, NULL, NULL
},
{
{"gp_motion_cost_per_row", PGC_USERSET, QUERY_TUNING_COST,
gettext_noop("Sets the planner's estimate of the cost of "
"moving a row between worker processes."),
gettext_noop("If >0, the planner uses this value -- instead of double the "
"cpu_tuple_cost -- for Motion operator cost estimation.")
},
&gp_motion_cost_per_row,
0, 0, DBL_MAX,
NULL, NULL, NULL
},
{
{"gp_selectivity_damping_factor", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Factor used in selectivity damping."),
gettext_noop("Values 1..N, 1 = basic damping, greater values emphasize damping"),
GUC_NOT_IN_SAMPLE | GUC_NO_SHOW_ALL
},
&gp_selectivity_damping_factor,
1.0, 1.0, DBL_MAX,
NULL, NULL, NULL
},
{
{"gp_resqueue_priority_cpucores_per_segment", PGC_POSTMASTER, RESOURCES_MGM,
gettext_noop("Number of processing units associated with a segment."),
NULL
},
&gp_resqueue_priority_cpucores_per_segment,
4.0, 0.1, 512.0,
NULL, NULL, NULL
},
{
{"gp_resource_group_cpu_limit", PGC_POSTMASTER, RESOURCES,
gettext_noop("Maximum percentage of CPU resources assigned to a cluster."),
NULL
},
&gp_resource_group_cpu_limit,
0.9, 0.1, 1.0,
NULL, NULL, NULL
},
{
{"gp_resource_group_memory_limit", PGC_POSTMASTER, RESOURCES,
gettext_noop("Maximum percentage of memory resources assigned to a cluster."),
NULL
},
&gp_resource_group_memory_limit,
0.7, 0.0001, 1.0,
NULL, NULL, NULL
},
{
{"optimizer_damping_factor_filter", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("select predicate damping factor in optimizer, 1.0 means no damping"),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_damping_factor_filter,
0.75, 0.0, 1.0,
NULL, NULL, NULL
},
{
{"optimizer_damping_factor_join", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("join predicate damping factor in optimizer, 1.0 means no damping, 0.0 means square root method"),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_damping_factor_join,
0.0, 0.0, 1.0,
NULL, NULL, NULL
},
{
{"optimizer_damping_factor_groupby", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("groupby operator damping factor in optimizer, 1.0 means no damping"),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_damping_factor_groupby,
0.75, 0.0, 1.0,
NULL, NULL, NULL
},
{
{"optimizer_cost_threshold", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Set the threshold for plan sampling relative to the cost of best plan, 0.0 means unbounded"),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_cost_threshold,
0.0, 0.0, INT_MAX,
NULL, NULL, NULL
},
{
{"optimizer_nestloop_factor", PGC_USERSET, QUERY_TUNING_OTHER,
gettext_noop("Set the nestloop join cost factor in the optimizer"),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_nestloop_factor,
1024.0, 1.0, DBL_MAX,
NULL, NULL, NULL
},
{
{"optimizer_sort_factor",PGC_USERSET, QUERY_TUNING_OTHER,
gettext_noop("Set the sort cost factor in the optimizer, 1.0 means same as default, > 1.0 means more costly than default, < 1.0 means means less costly than default"),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_sort_factor,
1.0, 0.0, DBL_MAX,
NULL, NULL, NULL
},
/* End-of-list marker */
{
{NULL, 0, 0, NULL, NULL}, NULL, 0.0, 0.0, 0.0, NULL, NULL
}
};
struct config_string ConfigureNamesString_gp[] =
{
{
{"memory_profiler_run_id", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Set the unique run ID for memory profiling"),
gettext_noop("Any string is acceptable"),
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&memory_profiler_run_id,
"none",
NULL, NULL, NULL
},
{
{"memory_profiler_dataset_id", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Set the dataset ID for memory profiling"),
gettext_noop("Any string is acceptable"),
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&memory_profiler_dataset_id,
"none",
NULL, NULL, NULL
},
{
{"memory_profiler_query_id", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Set the query ID for memory profiling"),
gettext_noop("Any string is acceptable"),
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&memory_profiler_query_id,
"none",
NULL, NULL, NULL
},
{
{"gp_role", PGC_BACKEND, GP_WORKER_IDENTITY,
gettext_noop("Sets the role for the session."),
gettext_noop("Valid values are DISPATCH, EXECUTE, and UTILITY."),
GUC_NOT_IN_SAMPLE | GUC_DISALLOW_IN_FILE
},
&gp_role_string,
"undefined",
check_gp_role, assign_gp_role, show_gp_role
},
{
{"gp_qd_hostname", PGC_BACKEND, GP_WORKER_IDENTITY,
gettext_noop("Shows the QD Hostname. Blank when run on the QD"),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE | GUC_DISALLOW_IN_FILE
},
&qdHostname,
"",
NULL, NULL, NULL
},
{
{"debug_dtm_action_sql_command_tag", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Sets the debug DTM action sql command tag."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&Debug_dtm_action_sql_command_tag,
"",
NULL, NULL, NULL
},
{
{"gp_resqueue_priority_default_value", PGC_POSTMASTER, RESOURCES_MGM,
gettext_noop("Default weight when one cannot be associated with a statement."),
NULL,
GUC_NO_SHOW_ALL
},
&gp_resqueue_priority_default_value,
"MEDIUM",
gpvars_check_gp_resqueue_priority_default_value, NULL, NULL
},
{
{"gp_resource_manager", PGC_POSTMASTER, RESOURCES,
gettext_noop("Sets the type of resource manager."),
gettext_noop("Only support \"queue\" and \"group\" for now.")
},
&gp_resource_manager_str,
"queue",
gpvars_check_gp_resource_manager_policy,
gpvars_assign_gp_resource_manager_policy,
gpvars_show_gp_resource_manager_policy,
},
/* for pljava */
{
{"pljava_vmoptions", PGC_SUSET, CUSTOM_OPTIONS,
gettext_noop("Options sent to the JVM when it is created"),
NULL,
GUC_NOT_IN_SAMPLE | GUC_SUPERUSER_ONLY
},
&pljava_vmoptions,
"",
NULL, NULL, NULL
},
{
{"pljava_classpath", PGC_SUSET, CUSTOM_OPTIONS,
gettext_noop("classpath used by the JVM"),
NULL,
GUC_NOT_IN_SAMPLE
},
&pljava_classpath,
"",
NULL, NULL, NULL
},
{
{"gp_auth_time_override", PGC_SIGHUP, DEVELOPER_OPTIONS,
gettext_noop("The timestamp used for enforcing time constraints."),
gettext_noop("For testing purposes only."),
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_auth_time_override_str,
"",
NULL, NULL, NULL
},
{
{"optimizer_search_strategy_path", PGC_USERSET, QUERY_TUNING_METHOD,
gettext_noop("Sets the search strategy used by gp optimizer."),
NULL,
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_search_strategy_path,
"default",
NULL, NULL, NULL
},
{
{"gp_default_storage_options", PGC_USERSET, APPENDONLY_TABLES,
gettext_noop("Sets the default options for appendonly storage."),
NULL,
GUC_NOT_IN_SAMPLE
},
&gp_default_storage_options, "",
check_gp_default_storage_options, assign_gp_default_storage_options, NULL
},
{
/* Can't be set in postgresql.conf */
{"gp_server_version", PGC_INTERNAL, PRESET_OPTIONS,
gettext_noop("Shows the Greenplum server version."),
NULL,
GUC_REPORT | GUC_NOT_IN_SAMPLE | GUC_DISALLOW_IN_FILE
},
&gp_server_version_string,
GP_VERSION,
NULL, NULL, NULL
},
#ifdef ENABLE_IC_PROXY
{
{"gp_interconnect_proxy_addresses", PGC_SIGHUP, GP_ARRAY_CONFIGURATION,
gettext_noop("Sets the ic-proxy addresses as \"content:ip:port ...\", must be ordered by content, the port is ignored at the moment."),
gettext_noop("e.g. \"-1:10.0.0.1:2000 0:10.0.0.2:2000 1:10.0.0.2:2001\""),
GUC_NO_SHOW_ALL | GUC_GPDB_NO_SYNC
},
&gp_interconnect_proxy_addresses,
"",
NULL, NULL, NULL
},
#endif /* ENABLE_IC_PROXY */
/* End-of-list marker */
{
{NULL, 0, 0, NULL, NULL}, NULL, NULL, NULL, NULL
}
};
struct config_enum ConfigureNamesEnum_gp[] =
{
{
{"gp_workfile_caching_loglevel", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Sets the logging level for workfile caching debugging messages"),
gettext_noop("Valid values are DEBUG5, DEBUG4, DEBUG3, DEBUG2, "
"DEBUG1, LOG, NOTICE, WARNING, and ERROR. Each level includes all the "
"levels that follow it. The later the level, the fewer messages are "
"sent."),
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_workfile_caching_loglevel,
DEBUG1, server_message_level_options,
NULL, NULL, NULL
},
{
{"gp_sessionstate_loglevel", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Sets the logging level for session state debugging messages"),
gettext_noop("Valid values are DEBUG5, DEBUG4, DEBUG3, DEBUG2, "
"DEBUG1, LOG, NOTICE, WARNING, and ERROR. Each level includes all the "
"levels that follow it. The later the level, the fewer messages are "
"sent."),
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_sessionstate_loglevel,
DEBUG1, server_message_level_options,
NULL, NULL, NULL
},
{
{"gp_log_format", PGC_POSTMASTER, LOGGING_WHERE,
gettext_noop("Sets the format for log files."),
gettext_noop("Valid values are TEXT, CSV.")
},
&gp_log_format,
1, gp_log_format_options,
NULL, NULL, NULL
},
{
{"debug_dtm_action_protocol", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Sets the debug DTM action protocol."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&Debug_dtm_action_protocol,
DTX_PROTOCOL_COMMAND_NONE, debug_dtm_action_protocol_options,
NULL, NULL, NULL
},
{
{"optimizer_log_failure", PGC_USERSET, LOGGING_WHEN,
gettext_noop("Sets which optimizer failures are logged."),
gettext_noop("Valid values are unexpected, expected, all"),
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_log_failure,
OPTIMIZER_UNEXPECTED_FAIL, optimizer_log_failure_options,
NULL, NULL, NULL
},
{
{"optimizer_minidump", PGC_USERSET, LOGGING_WHEN,
gettext_noop("Generate optimizer minidump."),
gettext_noop("Valid values are onerror, always"),
},
&optimizer_minidump,
OPTIMIZER_MINIDUMP_FAIL, optimizer_minidump_options,
NULL, NULL, NULL
},
{
{"optimizer_cost_model", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Set optimizer cost model."),
gettext_noop("Valid values are legacy, calibrated, experimental"),
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&optimizer_cost_model,
OPTIMIZER_GPDB_CALIBRATED, optimizer_cost_model_options,
NULL, NULL, NULL
},
{
{"explain_memory_verbosity", PGC_USERSET, RESOURCES_MEM,
gettext_noop("Experimental feature: show memory account usage in EXPLAIN ANALYZE."),
gettext_noop("Valid values are SUPPRESS, SUMMARY, DETAIL, and DEBUG.")
},
&explain_memory_verbosity,
EXPLAIN_MEMORY_VERBOSITY_SUPPRESS, explain_memory_verbosity_options,
NULL, NULL, NULL
},
{
{"debug_dtm_action", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Sets the debug DTM action."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&Debug_dtm_action,
DEBUG_DTM_ACTION_NONE, debug_dtm_action_options,
NULL, NULL, NULL
},
{
{"debug_dtm_action_target", PGC_SUSET, DEVELOPER_OPTIONS,
gettext_noop("Sets the debug DTM action target."),
NULL,
GUC_SUPERUSER_ONLY | GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&Debug_dtm_action_target,
DEBUG_DTM_ACTION_TARGET_NONE, debug_dtm_action_target_options,
NULL, NULL, NULL
},
{
{"gp_autostats_mode", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Sets the autostats mode."),
gettext_noop("Valid values are NONE, ON_CHANGE, ON_NO_STATS. ON_CHANGE requires setting gp_autostats_on_change_threshold.")
},
&gp_autostats_mode,
GP_AUTOSTATS_NONE, gp_autostats_modes,
NULL, NULL, NULL
},
{
{"gp_autostats_mode_in_functions", PGC_USERSET, DEVELOPER_OPTIONS,
gettext_noop("Sets the autostats mode for statements in procedural language functions."),
gettext_noop("Valid values are NONE, ON_CHANGE, ON_NO_STATS. ON_CHANGE requires setting gp_autostats_on_change_threshold.")
},
&gp_autostats_mode_in_functions,
GP_AUTOSTATS_NONE, gp_autostats_modes,
NULL, NULL, NULL
},
{
{"gp_interconnect_fc_method", PGC_USERSET, GP_ARRAY_TUNING,
gettext_noop("Sets the flow control method used for UDP interconnect."),
gettext_noop("Valid values are \"capacity\" and \"loss\".")
},
&Gp_interconnect_fc_method,
INTERCONNECT_FC_METHOD_LOSS, gp_interconnect_fc_methods,
NULL, NULL, NULL
},
{
{"gp_interconnect_type", PGC_BACKEND, GP_ARRAY_TUNING,
gettext_noop("Sets the protocol used for inter-node communication."),
gettext_noop("Valid values are \"tcp\", \"udpifc\""
#ifdef ENABLE_IC_PROXY
" and \"proxy\""
#endif /* ENABLE_IC_PROXY */
".")
},
&Gp_interconnect_type,
INTERCONNECT_TYPE_UDPIFC, gp_interconnect_types,
NULL, NULL, NULL
},
{
{"gp_interconnect_address_type", PGC_BACKEND, GP_ARRAY_TUNING,
gettext_noop("Sets the interconnect address type used for inter-node communication."),
gettext_noop("Valid values are \"unicast\" and \"wildcard\"")
},
&Gp_interconnect_address_type,
INTERCONNECT_ADDRESS_TYPE_UNICAST, gp_interconnect_address_types,
NULL, NULL, NULL
},
{
{"gp_log_fts", PGC_SIGHUP, LOGGING_WHAT,
gettext_noop("Sets the verbosity of logged messages pertaining to fault probing."),
gettext_noop("Valid values are \"off\", \"terse\", \"verbose\" and \"debug\"."),
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_log_fts,
GPVARS_VERBOSITY_TERSE, gp_log_verbosity,
NULL, NULL, NULL
},
{
{"gp_log_gang", PGC_USERSET, LOGGING_WHAT,
gettext_noop("Sets the verbosity of logged messages pertaining to worker process creation and management."),
gettext_noop("Valid values are \"off\", \"terse\", \"verbose\" and \"debug\"."),
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_log_gang,
GPVARS_VERBOSITY_OFF, gp_log_verbosity,
NULL, NULL, NULL
},
{
{"gp_log_interconnect", PGC_USERSET, LOGGING_WHAT,
gettext_noop("Sets the verbosity of logged messages pertaining to connections between worker processes."),
gettext_noop("Valid values are \"off\", \"terse\", \"verbose\" and \"debug\"."),
GUC_NO_SHOW_ALL | GUC_NOT_IN_SAMPLE
},
&gp_log_interconnect,
GPVARS_VERBOSITY_TERSE, gp_log_verbosity,
NULL, NULL, NULL
},
{
{"gp_resqueue_memory_policy", PGC_SUSET, RESOURCES_MGM,
gettext_noop("Sets the policy for memory allocation of queries."),
gettext_noop("Valid values are NONE, AUTO, EAGER_FREE.")
},
&gp_resqueue_memory_policy,
RESMANAGER_MEMORY_POLICY_NONE, gp_resqueue_memory_policies,
NULL, NULL, NULL
},
{
{"gp_resgroup_memory_policy", PGC_SUSET, RESOURCES_MGM,
gettext_noop("Sets the policy for memory allocation of queries."),
gettext_noop("Valid values are AUTO, EAGER_FREE.")
},
&gp_resgroup_memory_policy,
RESMANAGER_MEMORY_POLICY_EAGER_FREE, gp_resqueue_memory_policies, NULL, NULL
},
{
{"optimizer_join_order", PGC_USERSET, QUERY_TUNING_OTHER,
gettext_noop("Set optimizer join heuristic model."),
gettext_noop("Valid values are query, greedy, exhaustive and exhaustive2"),
GUC_NOT_IN_SAMPLE
},
&optimizer_join_order,
JOIN_ORDER_EXHAUSTIVE2_SEARCH, optimizer_join_order_options,
NULL, NULL, NULL
},
/* End-of-list marker */
{
{NULL, 0, 0, NULL, NULL}, NULL, 0, NULL, NULL, NULL
}
};
/*
* For system defined GUC must assign a tag either GUC_GPDB_NEED_SYNC
* or GUC_GPDB_NO_SYNC. We deprecated direct define in guc.c, instead,
* add into sync_guc_names_array or unsync_guc_names_array.
*/
static const char *sync_guc_names_array[] =
{
#include "utils/sync_guc_name.h"
};
static const char *unsync_guc_names_array[] =
{
#include "utils/unsync_guc_name.h"
};
int sync_guc_num = 0;
int unsync_guc_num = 0;
static int guc_array_compare(const void *a, const void *b)
{
const char *namea = *(const char **)a;
const char *nameb = *(const char **)b;
return guc_name_compare(namea, nameb);
}
void gpdb_assign_sync_flag(struct config_generic **guc_variables, int size, bool predefine)
{
static bool init = false;
/* ordering guc_name_array alphabets */
if (!init) {
sync_guc_num = sizeof(sync_guc_names_array) / sizeof(char *);
qsort((void *) sync_guc_names_array, sync_guc_num,
sizeof(char *), guc_array_compare);
unsync_guc_num = sizeof(unsync_guc_names_array) / sizeof(char *);
qsort((void *) unsync_guc_names_array, unsync_guc_num,
sizeof(char *), guc_array_compare);
init = true;
}
for (int i = 0; i < size; i ++)
{
struct config_generic *var = guc_variables[i];
/* if the sync flags is defined in guc variable, skip it */
if (var->flags & (GUC_GPDB_NEED_SYNC | GUC_GPDB_NO_SYNC))
continue;
char *res = (char *) bsearch((void *) &var->name,
(void *) sync_guc_names_array,
sync_guc_num,
sizeof(char *),
guc_array_compare);
if (!res)
{
char *res = (char *) bsearch((void *) &var->name,
(void *) unsync_guc_names_array,
unsync_guc_num,
sizeof(char *),
guc_array_compare);
/* for predefined guc, we force its name in one array.
* for the third-part libraries gucs introduced by customer
* we assign unsync flags as default.
*/
if (!res && predefine)
{
ereport(ERROR,
(errcode(ERRCODE_INTERNAL_ERROR),
errmsg("Neither sync_guc_names_array nor "
"unsync_guc_names_array contains predefined "
"guc name: %s", var->name)));
}
var->flags |= GUC_GPDB_NO_SYNC;
}
else
{
var->flags |= GUC_GPDB_NEED_SYNC;
}
}
}
static bool
check_pljava_classpath_insecure(bool *newval, void **extra, GucSource source)
{
if ( *newval == true )
{
struct config_generic *pljava_cp = find_option("pljava_classpath", false, ERROR);
if (pljava_cp != NULL)
{
pljava_cp->context = PGC_USERSET;
}
else
{
GUC_check_errdetail("Failed to set insecure PLJAVA classpath");
return false;
}
}
return true;
}
static void
assign_pljava_classpath_insecure(bool newval, void *extra)
{
if ( newval == true )
{
struct config_generic *pljava_cp = find_option("pljava_classpath", false, ERROR);
if (pljava_cp != NULL)
{
pljava_cp->context = PGC_USERSET;
}
}
}
static bool
check_gp_resource_group_bypass(bool *newval, void **extra, GucSource source)
{
if (!ResGroupIsAssigned())
return true;
GUC_check_errmsg("SET gp_resource_group_bypass cannot run inside a transaction block");
return false;
}
static bool
check_optimizer(bool *newval, void **extra, GucSource source)
{
#ifndef USE_ORCA
if (*newval)
{
GUC_check_errmsg("ORCA is not supported by this build");
return false;
}
#endif
if (!optimizer_control)
{
if (source >= PGC_S_INTERACTIVE)
{
GUC_check_errmsg("cannot change the value of \"optimizer\"");
return false;
}
}
return true;
}
static bool
check_verify_gpfdists_cert(bool *newval, void **extra, GucSource source)
{
if (!*newval && Gp_role == GP_ROLE_DISPATCH)
elog(WARNING, "verify_gpfdists_cert=off. Greenplum Database will stop validating "
"the gpfdists SSL certificate for connections between segments and gpfdists");
return true;
}
static bool
check_dispatch_log_stats(bool *newval, void **extra, GucSource source)
{
if (*newval &&
(log_parser_stats || log_planner_stats || log_executor_stats || log_statement_stats))
{
if (source >= PGC_S_INTERACTIVE)
ereport(ERROR,
(errcode(ERRCODE_INVALID_PARAMETER_VALUE),
errmsg("cannot enable \"log_dispatch_stats\" when "
"\"log_statement_stats\", "
"\"log_parser_stats\", \"log_planner_stats\", "
"or \"log_executor_stats\" is true")));
/* source == PGC_S_OVERRIDE means do it anyway, eg at xact abort */
else if (source != PGC_S_OVERRIDE)
return false;
}
return true;
}
bool
check_gp_hashagg_default_nbatches(int *newval, void **extra, GucSource source)
{
/* Must be a power of two */
if (0 == (*newval & (*newval - 1)))
{
return true;
}
else
{
GUC_check_errmsg("gp_hashagg_default_nbatches must be a power of two");
return false;
}
}
/*
* Malloc a new string representing current storage_opts.
*/
static char *
storageOptToString(const StdRdOptions *ao_opts)
{
StringInfoData buf;
char *ret;
initStringInfo(&buf);
appendStringInfo(&buf, "%s=%d,", SOPT_BLOCKSIZE,
ao_opts->blocksize);
if (ao_opts->compresstype[0])
{
appendStringInfo(&buf, "%s=%s,", SOPT_COMPTYPE,
ao_opts->compresstype);
}
else
{
appendStringInfo(&buf, "%s=none,", SOPT_COMPTYPE);
}
/*
* MPP-14504: we seem to allow compresslevel > 0 even when compression is
* disabled.
*/
if (ao_opts->compresslevel > 0)
{
appendStringInfo(&buf, "%s=%d,", SOPT_COMPLEVEL,
ao_opts->compresslevel);
}
appendStringInfo(&buf, "%s=%s", SOPT_CHECKSUM,
ao_opts->checksum ? "true" : "false");
ret = strdup(buf.data);
if (ret == NULL)
elog(ERROR, "out of memory");
pfree(buf.data);
return ret;
}
/*
* Parse new value of storage options. Update both, the GUC and
* global ao_storage_opts object.
*/
static bool
check_gp_default_storage_options(char **newval, void **extra, GucSource source)
{
/* Value of "appendonly" option if one is specified. */
StdRdOptions *newopts;
newopts = calloc(sizeof(*newopts), 1);
if (!newopts)
ereport(ERROR,
(errcode(ERRCODE_OUT_OF_MEMORY),
errmsg("out of memory")));
resetAOStorageOpts(newopts);
/*
* Perform identical validations as in case of options specified
* in a WITH() clause.
*/
if ((*newval)[0])
{
Datum newopts_datum;
newopts_datum = parseAOStorageOpts(*newval);
parse_validate_reloptions(newopts, newopts_datum,
/* validate */ true, RELOPT_KIND_APPENDOPTIMIZED);
}
/*
* All validations succeeded, it is safe to update global
* appendonly storage options.
*/
free(*newval);
*newval = storageOptToString(newopts);
*extra = newopts;
return true;
}
static void
assign_gp_default_storage_options(const char *newval, void *extra)
{
StdRdOptions *newopts = (StdRdOptions *) extra;
setDefaultAOStorageOpts(newopts);
}
/*
* Set GUC value in GP_REPLICATION_CONFIG_FILENAME.
*
* If value is NULL, then this GUC is removed from the configuration.
*
* If name exists, its value will be updated.
* otherwise, the new named GUC will be added.
*/
void
set_gp_replication_config(const char *name, const char *value)
{
A_Const aconst = {.type = T_A_Const, .val = {.type = T_String, .val.str = pstrdup(value)}};
List *args = list_make1(&aconst);
VariableSetStmt setstmt = {.type = T_VariableSetStmt, .kind = VAR_SET_VALUE, .name = pstrdup(name), .args = args};
AlterSystemStmt alterSystemStmt = {.type = T_AlterSystemStmt, .setstmt = &setstmt};
AlterSystemSetConfigFile(&alterSystemStmt);
}
/*
* lookup_autostats_mode_by_value
*
* Return the string value name for the specified value. This is essentially a
* specialized version of config_enum_lookup_by_value() for use by autostats.c
* debugging code.
*/
const char *
lookup_autostats_mode_by_value(GpAutoStatsModeValue val)
{
const struct config_enum_entry *entry;
for (entry = gp_autostats_modes; entry && entry->name; entry++)
{
if (entry->val == val)
return entry->name;
}
elog(ERROR, "could not find autostats mode %d", val);
return NULL; /* silence compiler */
}
static bool
check_gp_workfile_compression(bool *newval, void **extra, GucSource source)
{
#ifndef USE_ZSTD
if (*newval)
{
GUC_check_errmsg("workfile compresssion is not supported by this build");
return false;
}
#endif
return true;
}
void
DispatchSyncPGVariable(struct config_generic * gconfig)
{
StringInfoData buffer;
if (Gp_role != GP_ROLE_DISPATCH || IsBootstrapProcessingMode())
return;
initStringInfo( &buffer );
appendStringInfo(&buffer, "SET ");
switch (gconfig->vartype)
{
case PGC_BOOL:
{
struct config_bool *bguc = (struct config_bool *) gconfig;
appendStringInfo(&buffer, "%s TO %s", gconfig->name, *(bguc->variable) ? "true" : "false");
break;
}
case PGC_INT:
{
struct config_int *iguc = (struct config_int *) gconfig;
appendStringInfo(&buffer, "%s TO %d", gconfig->name, *iguc->variable);
break;
}
case PGC_REAL:
{
struct config_real *rguc = (struct config_real *) gconfig;
appendStringInfo(&buffer, " %s TO %f", gconfig->name, *rguc->variable);
break;
}
case PGC_STRING:
{
struct config_string *sguc = (struct config_string *) gconfig;
const char *str = *sguc->variable;
appendStringInfo(&buffer, "%s TO ", gconfig->name);
/*
* If it's a list, we need to split the list into elements and
* quote the elements individually.
* else if it's empty or not a list, we should quote the whole src.
*
* This is the copied from pg_get_functiondef()'s handling of
* proconfig options.
* .
*/
if (sguc->gen.flags & GUC_LIST_QUOTE && str[0] != '\0')
{
List *namelist;
ListCell *lc;
/* Parse string into list of identifiers */
if (!SplitGUCList((char *) pstrdup(str), ',', &namelist))
{
/* this shouldn't fail really */
elog(ERROR, "invalid list syntax in proconfig item");
}
foreach(lc, namelist)
{
char *curname = (char *) lfirst(lc);
appendStringInfoString(&buffer, quote_literal_cstr(curname));
if (lnext(lc))
appendStringInfoString(&buffer, ", ");
}
}
else
appendStringInfoString(&buffer, quote_literal_cstr(str));
break;
}
case PGC_ENUM:
{
struct config_enum *eguc = (struct config_enum *) gconfig;
int value = *eguc->variable;
const char *str = config_enum_lookup_by_value(eguc, value);
int i;
appendStringInfo(&buffer, "%s TO ", gconfig->name);
/*
* All whitespace characters must be escaped. See
* pg_split_opts() in the backend. (Not sure if an enum value
* can have whitespace, but let's be prepared.)
*/
for (i = 0; str[i] != '\0'; i++)
{
if (isspace((unsigned char) str[i]))
appendStringInfoChar(&buffer, '\\');
appendStringInfoChar(&buffer, str[i]);
}
break;
}
}
CdbDispatchSetCommand(buffer.data, false);
}
相关信息
相关文章
greenplumn bitmap_compression 源码
greenplumn faultinjector_warnings 源码
0
赞
热门推荐
-
2、 - 优质文章
-
3、 gate.io
-
8、 golang
-
9、 openharmony
-
10、 Vue中input框自动聚焦