PostgreSQL 小课持续更新中-20240603

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 元券已过期，思维导图又更新了，如下：