Reference: parameters (GUC) =========================== oushudb_main_directory ---------------------- oushu main directories ============= ========================= ======================= Value Range Default Set Classifications ============= ========================= ======================= String /data1/oushudb/masterdd master, system, restart ============= ========================= ======================= oushudb_main_temp_directory --------------------------- main temporary directories ============= ======== ======================= Value Range Default Set Classifications ============= ======== ======================= String /tmp master, system, restart ============= ======== ======================= oushudb_segment_temp_directory ------------------------------ segment temporary directories ============= ======== ======================= Value Range Default Set Classifications ============= ======== ======================= String /tmp master, system, restart ============= ======== ======================= oushudb_main_port ------------------------------ oushu main port ============= ======== ======================= Value Range Default Set Classifications ============= ======== ======================= 0-65546 7432 system ============= ======== ======================= oushudb_segment_port ------------------------------ oushu segment port ============= ======== ======================= Value Range Default Set Classifications ============= ======== ======================= 0-65546 40000 system ============= ======== ======================= catalog_url ------------------------------ 配置元数据访问路径, 'catalog_url' 应当在 magma-client.xml 中展开 ============= =============================== ======================= Value Range Default Set Classifications ============= =============================== ======================= String default_nameservice/vsc_catalog system ============= =============================== ======================= gp_vmem_protect_limit ------------------------------ OushuDB 计算节点最大可用内存, 建议配置为节点内存 70-90%（需要为部署的其他系统留出一定内存） ============= =============================== ======================= Value Range Default Set Classifications ============= =============================== ======================= 0-INT_MAX/2 8192 session, reload ============= =============================== ======================= plan_cache_mode ----------------------------- Controls the planner's selection of custom or generic plan ========================================= ================== ===================== Value Range Default Set Classifications ========================================= ================== ===================== auto,force_generic_plan,force_custom_plan force_custom_plan master,system,restart ========================================= ================== ===================== cache_disk_quota_segment ------------------------ 根据DB临时磁盘大小配置每个计算节点缓存大小，默认512GB ============= =============================== ======================= Value Range Default Set Classifications ============= =============================== ======================= 0-INT32_MAX 512GB master,system,restart ============= =============================== ======================= default_numeric_unconstrained_storage ----------------------------------------- 控制建表时 NUMERIC 实际存储类型，默认为有限精度（38位精度，15位小数）。如需无限精度，请配置为 NUMERIC。 ======================== =============== ========================= Value Range Default Set Classifications ======================== =============== ========================= NUMERIC(M, D), NUMERIC NUMERIC(38,15) master, session, reload ======================== =============== =========================