删除所有数据
最近更新时间: 2025-02-18 16:02:00
postgres=# insert into tbase select t,random()::text from generate_series(1,100000) as t;
postgres=# \timing
Timing is on.
postgres=# delete from tbase ;
DELETE 100000
Time: 100.808 ms
#使用truncate方法是全表删除更高效的方法
postgres=# insert into tbase select t,random()::text from generate_series(1,100000) as t;
INSERT 0 100000
Time: 13178.429 ms
postgres=# truncate table tbase;
TRUNCATE TABLE
Time: 24.242 ms