postgresql数据库 timescaledb 时序库 把大数据量表转换为超表的问题

--我是7天一分区

SELECT create_hypertable( '表名_cs' , 'alarm_time' , chunk_time_interval => INTERVAL '7 day' );

-- 加个索引

CREATE INDEX "表名_cs_create_time_idx" ON "hrmw" . "表名_cs" USING btree (

  "create_time" "code" . "列名" DESC NULLS FIRST

);

INSERT into 表名_cs SELECT * from 表名;

INSERT into 表名_cs SELECT * from 表名 where alarm_time >= '2020-9-1' ;

INSERT into 表名_cs SELECT * from 表名 where alarm_time >= '2020-10-1' and alarm_time < '2020-11-1'   ;

CREATE

     OR REPLACE PROCEDURE "hrmw" . "sp_into_表名_pt" ( ) AS $BODY$ BEGIN

     -- 一般按照表名来建函数

     DECLARE --我声明的变量有点多 按实际的来

         target_text TEXT;

     sqltext TEXT;

     sqltext1 TEXT;

     sqltext2 TEXT;

     rd record;

     nloop INT ;

     isexist TEXT;

     datestr TEXT;

     begindate TEXT;

     n INT ;

     BEGIN

             --查询最早一天的时间

             sqltext := 'select to_char(min(alarm_time),' 'yyyy-mm-dd' ') datestr from tb_hrmw_moni_target' ;   

         EXECUTE sqltext INTO begindate;

         n := date_part( 'day' , now( ) - begindate :: DATE );

--enddate:=(to_char(now(),'yyyy-mm-dd'))::text;

         FOR nloop IN 0..n

         LOOP

         datestr := ( begindate :: DATE + nloop ) :: TEXT;

         sqltext2 := '

         insert into 表名_cs

         select

         列名1,

         code,

         列名2,

         alarm_time,

         列名3,

         列名4

         from 表名

         where alarm_time >= ' '' || datestr || ' 0' '

         and alarm_time <= ' '' || datestr || ' 23:59:59' '

         ' ;

         EXECUTE sqltext2;

         COMMIT ;

     END loop;

RETURN ;

END ;

END $BODY$ LANGUAGE plpgsql