時間:2024-02-03 17:42作者:下載吧人氣:50
在postgresql中 Drop table會不會釋放磁盤空間,今日以實操來見證
–2019-01-11 09:49:21 drop table 會不會釋放空間
create table tab_todrop(id int,cname varchar(50),remark text);
insert into tab_todrop select generate_series(1,10000000),’wx good boy’,md5(‘wx good boy’);
insert into tab_todrop select generate_series(1,10000000),’wx good boy’,md5(‘wx good boy’);
–查看表大小
qmstst=# select pg_size_pretty(pg_relation_size(‘tab_todrop’));
pg_size_pretty
—————-
2410 MB
(1 row)
qmstst=#
網友評論