【PostgreSQL 实战系列】PostgreSQL 从入门到精通_postgresql从入门到精通

我的 PostgreSQL 专栏介绍及进度

目前整体进度已完成 80%，

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)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63

目前还有服务端编程、事务处理、调优、监控等章节还在进行中，其他章节均已完成。

如果有需要可以看下星球：