在知识库中专注阅读，并随时返回相关工具与课程
openGauss 每日一练第 19 天打卡，我来了！又可以学习，真开心~ 今天第 19 课，学习openGauss收集统计信息、打印执行计划、垃圾收集和checkpoint！ sql create schema lucifer; create table lucifer.store id int, name CHAR20 partition by range id
系统学习 Oracle DBA
开通会员 ¥128/月起
查看完整课程openGauss 每日一练第 19 天打卡，我来了！又可以学习，真开心~
本章目标：掌握本章核心知识点 前置要求：完成前序章节学习 预计时长：60 分钟
今天第 19 课，学习openGauss收集统计信息、打印执行计划、垃圾收集和checkpoint！
1create schema lucifer;2create table lucifer.store3(4 id int,5 name CHAR(20)6)7partition by range (id)8(9 partition store_p0 values less than (50),10 partition store_p1 values less than (100),11 partition store_p2 values less than (150),12 partition store_p3 values less than (200),13 partition store_p4 values less than (10001)14);15insert into lucifer.store values(generate_series(10, 10000));
1select relname, relpages, reltuples from pg_class where relname = 'store';2analyze VERBOSE lucifer.store;3select relname, relpages, reltuples from pg_class where relname = 'store';
1SET explain_perf_mode=normal;2EXPLAIN SELECT * FROM lucifer.store;3create index store_idx on lucifer.store(id);4EXPLAIN SELECT * FROM lucifer.store WHERE id<100;
1update lucifer.store set id = id + 1 where id < 100;2VACUUM (VERBOSE, ANALYZE) lucifer.store;
1CHECKPOINT;2drop table lucifer.store;3drop schema lucifer;
今天的作业打卡结束！🎉