red linux手动回收磁盘空间,amazon-redshift – 在删除表之后由Redshift回收磁盘空间...

drop table释放空间.

如果你正在对表行执行删除操作,那么你应该启动vaccumm delete only命令.

在红移的下落表的情况下,无需打开真空

触发命令以检查表下降之前和之后的DB大小,以查看是否获得空间

select sum(mbytes)/1024 as db_size_in_gb, database from (

select trim(pgdb.datname) as Database,

trim(a.name) as Table, b.mbytes

from stv_tbl_perm a

join pg_database as pgdb on pgdb.oid = a.db_id

join (select tbl, count(*) as mbytes

from stv_blocklist group by tbl) b on a.id=b.tbl

where a.slice=0

order by db_id, name)

group by database;