PostgreSQL 小课持续更新中
基于 PostgreSQL 16.x 版本。目前的进度如下:
(venv311) ➜ 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 | 1199 | 2783
01-pgenv.md | 499 | 721 | 1220
03-postgresql-glance.md | 3091 | 710 | 3801
04-pg-vs-mysql.md | 1997 | 593 | 2590
05-01-pg-managing-users-and-roles.md | 6963 | 1813 | 8776
05-02-pg-review-roles.md | 4556 | 1589 | 6145
05-03-pg-acls.md | 2353 | 677 | 3030
05-04-pg-grant-and-revoke-permissions.md | 3506 | 1413 | 4919
05-05-pg-rls.md | 2298 | 640 | 2938
05-06-pg-enable-and-verify-ssl.md | 1658 | 850 | 2508
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 | 1801 | 745 | 2546
09-pg-window-functions.md | 446 | 190 | 636
10-pg-server-side-programming.md | 483 | 1159 | 1642
11-pg-triggers-and-rules.md | 6152 | 2867 | 9019
12-pg-partitioning.md | 0 | 0 | 0
13-pg-transactions-mvcc-wals-checkpoints.md | 0 | 0 | 0
14-pg-extension-ecosystem.md | 7655 | 1677 | 9332
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 | 5 | 0 | 5
18-01-pg-configuration-and-monitoring.md | 88 | 211 | 299
18-02-pg-configuration-and-monitoring.md | 31 | 545 | 576
19-pg-physical-replication.md | 4 | 0 | 4
20-pg-logical-replication.md | 4 | 0 | 4
21-pg-usful-tools-and-extensions.md | 8 | 208 | 216
README.md | 14 | 4 | 18
advertisement.md | 563 | 55 | 618
data-samples.md | 18 | 389 | 407
demo.md | 467 | 192 | 659
double-and-single-quote-difference.md | 14 | 909 | 923
pg-docker.md | 23 | 161 | 184
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_tablespace.md | 334 | 54 | 388
pgsql-configuration.md | 1128 | 153 | 1281
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 | 77910 | 33690 | 111600
(55 rows)
有需要可以微信联系:WeParasamgate。之前的 10 张 20 元券已过期,思维导图又更新了,如下: