PostgreSQL事务插入大量数据

一、创建存过tzq_transaction_insert_data()

创建存过tzq_transaction_insert_data()

/* !!!!!!!!20230621-1805-PostgreSQL事务插入大量数据 */
CREATE or replace PROCEDURE tzq_transaction_insert_data(fromNumber int8,toNumber int8)
LANGUAGE plpgsql
AS $$
BEGIN
  -- truncate table test_insert_t;
  for i in fromNumber .. toNumber loop
    if i%50000 = 0 then
      RAISE NOTICE 'i=%',i;
      commit;
    ELSE
      insert into test_insert_t select i,'tzq'||i::varchar, i%50000 ;
    end if;
  end loop;
END;
$$;

二、调用存过tzq_transaction_insert_data()

CALL tzq_transaction_insert_data(36000001,38000000);