作者
digoal
日期
2019-04-05
标签
PostgreSQL , CLUSTER , VACUUM FULL , create index , vacuum , 进度条 , progress , pg_stat_progress , CREATE INDEX CONCURRENTLY
背景
目前PG的 CLUSTER , VACUUM FULL , create index , vacuum 操作均支持进度条动态视图，可以看到当前这些操作的完成度，处于什么阶段。
相关系统视图
pg_stat_progress_create_index
pg_stat_progress_vacuum
pg_stat_progress_cluster
进度、阶段内容解说见
https://www.postgresql.org/docs/devel/progress-reporting.html
```
Add progress reporting for CLUSTER and VACUUM FULL.
This uses the same progress reporting infrastructure added in commit
c16dc1aca5e01e6acaadfcf38f5fc964a381dc62 and extends it to these
additional cases. We lack the ability to track the internal progress
of sorts and index builds so the information reported is
coarse-grained for some parts of the operation, but it still seems
like a significant improvement over having nothing at all.
Tatsuro Yamada, reviewed by Thomas Munro, Masahiko Sawada, Michael
Paquier, Jeff Janes, Alvaro Herrera, Rafia Sabih, and by me. A fair
amount of polishing also by me.
Discussion: http://postgr.es/m/59A77072.3090401@lab.ntt.co.jp
```
参考
https://www.postgresql.org/docs/devel/progress-reporting.html
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=6f97457e0ddd8b421ca5e483439ef0318e6fc89a
PostgreSQL 许愿链接
您的愿望将传达给PG kernel hacker、数据库厂商等, 帮助提高数据库产品质量和功能, 说不定下一个PG版本就有您提出的功能点. 针对非常好的提议，奖励限量版PG文化衫、纪念品、贴纸、PG热门书籍等，奖品丰富，快来许愿。开不开森.
9.9元购买3个月阿里云RDS PostgreSQL实例
PostgreSQL 解决方案集合
德哥 / digoal's github - 公益是一辈子的事.
