云数据库 GaussDB-PURGE:示例

时间：2025-02-12 15:08:13

云数据库 GaussDB

示例

--创建表reason_t1。gaussdb=# CREATE TABLE reason_t1(    r_reason_sk    integer,    r_reason_id    character(16),    r_reason_desc  character(100)) WITH(STORAGE_TYPE = ustore);--创建表reason_t2。gaussdb=# CREATE TABLE reason_t2(    r_reason_sk    integer,    r_reason_id    character(16),    r_reason_desc  character(100)) WITH(STORAGE_TYPE = ustore);-- 对表reason_t1和reason_t2添加索引。gaussdb=#  CREATE INDEX idx_t1 on reason_t1(r_reason_id); gaussdb=#  CREATE INDEX idx_t2 on reason_t2(r_reason_id); gaussdb=#  DROP TABLE reason_t1;gaussdb=#  DROP TABLE reason_t2;--查看回收站。gaussdb=#  SELECT rcyname,rcyoriginname,rcytablespace FROM GS_RECYCLEBIN;          rcyname           | rcyoriginname | rcytablespace ----------------------------+---------------+--------------- BIN$31C94EB4207$8001$0==$0 | reason_t1     |             0 BIN$31C94EB420D$8001$0==$0 | idx_t1        |             0 BIN$31C94EB420A$8004$0==$0 | reason_t2     |             0 BIN$31C94EB420E$8004$0==$0 | idx_t2        |             0(4 rows)--PURGE清除表。gaussdb=#  PURGE TABLE reason_t1;gaussdb=#  SELECT rcyname,rcyoriginname,rcytablespace FROM GS_RECYCLEBIN;          rcyname           | rcyoriginname | rcytablespace ----------------------------+---------------+--------------- BIN$31C94EB420A$8004$0==$0 | reason_t2     |             0 BIN$31C94EB420E$8004$0==$0 | idx_t2        |             0(2 rows)--PURG清除索引。gaussdb=# PURGE INDEX idx_t2;gaussdb=# SELECT rcyname,rcyoriginname,rcytablespace FROM GS_RECYCLEBIN;          rcyname           | rcyoriginname | rcytablespace ----------------------------+---------------+--------------- BIN$31C94EB420A$8004$0==$0 | reason_t2     |             0(1 row)--PURGE清除回收站所有对象。gaussdb=#  PURGE recyclebin;gaussdb=#  SELECT rcyname,rcyoriginname,rcytablespace FROM GS_RECYCLEBIN;        rcyname        | rcyoriginname | rcytablespace -----------------------+---------------+---------------(0 rows)