检测到您已登录华为云国际站账号,为了您更好的体验,建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
默认值:off xc_maintenance_mode 参数说明:设置系统进入维护模式。 该参数属于SUSET类型参数,仅支持表2中的方式三进行设置。 取值范围:布尔型 on表示该功能启用。 off表示该功能被禁用。 谨慎打开这个开关,避免引起集群数据不一致。
Storage | Stats target | Description --------+---------+-----------+----------+--------------+------------- id | integer | | plain
若仅调大此参数,未同比例调整内存参数,业务压力大时,容易出现内存不足,报错提示“memory is temporarily unavailable”。
INFO 'col_type = %', rec.col_type; raise INFO 'col_name = %', rec.col_name; raise INFO 'col_name_len
Storage | Stats target | Description --------+---------+-----------+----------+--------------+------------- id | integer | | plain
id = DBE_TASK.JOB_SUBMIT( gaussdb$# what => 'insert into t1 values (1, 2)', gaussdb$# job_interval => 'sysdate + 1' --daily
id = DBE_TASK.JOB_SUBMIT( openGauss$# what => 'insert into t1 values (1, 2)', openGauss$# job_interval => 'sysdate + 1' --daily
id = DBE_TASK.JOB_SUBMIT( openGauss$# what => 'insert into t1 values (1, 2)', openGauss$# job_interval => 'sysdate + 1' --daily
id = DBE_TASK.JOB_SUBMIT( gaussdb$# what => 'insert into t1 values (1, 2)', gaussdb$# job_interval => 'sysdate + 1' --daily
id = DBE_TASK.JOB_SUBMIT( gaussdb$# what => 'insert into t1 values (1, 2)', gaussdb$# job_interval => 'sysdate + 1' --daily
默认值:off ignore_checksum_failure 参数说明:设置此参数为打开会导致系统忽略失败(但仍然会告警),继续执行可能导致崩溃,传播或隐藏损坏数据,无法从远程节点恢复数据及其他严重问题。不建议用户修改设置。
id = DBE_TASK.JOB_SUBMIT( gaussdb$# what => 'insert into t1 values (1, 2)', gaussdb$# job_interval => 'sysdate + 1' --daily
返回值类型:text 示例: 1 2 3 4 5 openGauss=# SELECT substrb('ABCDEF',2,2); substrb --------- BC (1 row) trim([leading |trailing |both] [characters
INFO 'col_type = %', rec.col_type; raise INFO 'col_name = %', rec.col_name; raise INFO 'col_name_len
------+ | "base64:type252:WzEsICJqc29uIl0=" | "base64:type249:dHJ1ZQ==" | "base64:type250:YWJj" | "base64:type251:eyJqc25pZCI6IDEsICJ0YWciOiAiYWIifQ
byteawithoutorderwithequalcolin、byteawithoutorderwithequalcolout等密态等值函数为数据库内核中数据类型byteawithoutorderwithequalcol指定的in、out、send、recv等读写格式转换函数,具体可参考bytea类型的byteain
例如: 1 2 3 4 5 6 7 gaussdb=# SELECT * FROM pg_xlogfile_name_offset(pg_stop_backup()); NOTICE: pg_stop_backup cleanup done, waiting for required
例如: 1 2 3 4 5 6 7 gaussdb=# SELECT * FROM pg_xlogfile_name_offset(pg_stop_backup()); NOTICE: pg_stop_backup cleanup done, waiting for required
例如: 1 2 3 4 5 6 7 gaussdb=# SELECT * FROM pg_xlogfile_name_offset(pg_stop_backup()); NOTICE: pg_stop_backup cleanup done, waiting for required
例如: 1 2 3 4 5 6 7 gaussdb=# SELECT * FROM pg_xlogfile_name_offset(pg_stop_backup()); NOTICE: pg_stop_backup cleanup done, waiting for required