amazon-redshift - 删除表后由 Redshift 回收磁盘空间

Question

删除表后，redshift 是否回收可用磁盘空间，或者我们是否需要运行 vaccum。

Answer 1

drop table 释放空间。

如果您正在对表的行进行删除操作，那么您应该触发 vaccumm delete only 命令。

如果在 Redshift 中删除表，则无需触发真空

触发以下命令以检查表删除前后的数据库大小以查看是否获得空间

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;