阅读量:2
我的 PostgreSQL 专栏介绍及进度
20240715：目前整体进度已完成 85%，完成 16 万字，还有近 5 万字就截稿了。
(venv312) ➜ mypostgres git:(dev) sh scripts/word_statistics_pg_style.sh Filename | Chinese | English | Total ----------------------------------------------------+------------+------------+------------ 00-pg-introduction.md | 3254 | 176 | 3430 01-install-pgsql.md | 1584 | 1246 | 2830 01-pgenv.md | 499 | 721 | 1220 03-postgresql-glance.md | 3092 | 710 | 3802 04-pg-vs-mysql.md | 1997 | 593 | 2590 05-01-pg-managing-users-and-roles.md | 6956 | 1814 | 8770 05-02-pg-review-roles.md | 4556 | 1589 | 6145 05-03-pg-acls.md | 2357 | 677 | 3034 05-04-pg-grant-and-revoke-permissions.md | 3506 | 1413 | 4919 05-05-pg-rls.md | 2298 | 641 | 2939 05-06-pg-enable-and-verify-ssl.md | 1658 | 851 | 2509 06-pg-sql-statements-basic.md | 4244 | 1948 | 6192 07-01-pg-sql-statements-advanced.md | 1366 | 1187 | 2553 07-02-pg-sql-statements-advanced-join.md | 1444 | 1553 | 2997 07-03-pg-sql-statements-advanced-aggregate.md | 1112 | 365 | 1477 07-04-pg-sql-statements-advanced-returning.md | 1084 | 627 | 1711 07-05-pg-sql-statements-advanced-ctes.md | 1353 | 531 | 1884 08-pg-psql-cmd-customize.md | 1835 | 799 | 2634 09-pg-window-functions.md | 3794 | 1233 | 5027 10-pg-server-side-programming.md | 492 | 4004 | 4496 11-pg-triggers-and-rules.md | 6152 | 2867 | 9019 12-pg-partitioning.md | 83 | 4545 | 4628 13-pg-transactions-mvcc-wals-checkpoints.md | 33 | 209 | 242 14-pg-extension-ecosystem.md | 7659 | 1677 | 9336 15-pg-sql-tuning-and-idx-perf-optimization.md | 0 | 0 | 0 16-01-pg-logging-and-auditing.md | 6667 | 878 | 7545 16-02-pg-logging-and-auditing.md | 2944 | 581 | 3525 17-pg-backup-and-restore.md | 12000 | 3017 | 15017 18-01-pg-configuration-and-monitoring.md | 394 | 4622 | 5016 18-02-pg-configuration-and-monitoring.md | 503 | 2438 | 2941 19-pg-physical-replication.md | 5007 | 1506 | 6513 20-pg-logical-replication.md | 5178 | 1549 | 6727 21-pg-usful-tools-and-extensions.md | 42 | 2376 | 2418 README.md | 14 | 4 | 18 advertisement.md | 563 | 54 | 617 data-samples.md | 71 | 661 | 732 demo.md | 467 | 210 | 677 double-and-single-quote-difference.md | 14 | 909 | 923 pg-docker.md | 158 | 226 | 384 pg-event-trigger-demo.md | 561 | 752 | 1313 pg-psql-cmd-customize.md | 1728 | 756 | 2484 pg-single-mode.md | 157 | 449 | 606 pg-stream-repl.md | 1086 | 1065 | 2151 pg_backup_and_restore.md | 123 | 309 | 432 pg_control_file.md | 271 | 237 | 508 pg_enable_ssl.md | 0 | 292 | 292 pg_extensions.md | 216 | 178 | 394 pg_pgpool.md | 0 | 0 | 0 pg_slony.md | 324 | 149 | 473 pg_stat_statements.md | 614 | 389 | 1003 pg_tablespace.md | 334 | 54 | 388 pgsql-configuration.md | 1128 | 179 | 1307 pgsql.md | 2689 | 1882 | 4571 postgis-in-action.md | 4 | 83 | 87 postgis_basic.md | 88 | 203 | 291 postgis_install.md | 0 | 429 | 429 postgresql.conf.md | 13 | 88 | 101 ----------------------------------------------------+------------+------------+------------ Total Words | 105766 | 58501 | 164267 (57 rows) 目前还有服务端编程、事务处理、调优、监控等章节还在进行中，其他章节均已完成。
如果有需要可以看下星球：
