云数据库 GAUSSDB-DBE_ILM_ADMIN:示例

时间：2024-11-02 18:45:47

云数据库 GAUSSDB

示例

  
       gaussdb=# CALL DBE_ILM_ADMIN.CUSTOMIZE_ILM(1, 15);
 customize_ilm 
---------------

(1 row)
gaussdb=# select * from gs_adm_ilmparameters;
        name        | value 
--------------------+-------
 EXECUTION_INTERVAL |    15
 RETENTION_TIME     |    30
 ENABLED            |     1
 POLICY_TIME        |     0
 ABS_JOBLIMIT       |    10
 JOB_SIZELIMIT      |  1024
 WIND_DURATION      |   240
 BLOCK_LIMITS       |    40
(8 rows)