开始读Learning PostgresSQL第二版
已经读了一半多了。这本书的全名为:Learn PostgreSQL: Use, manage, and build secure and scalable databases with PostgreSQL 16, 2nd Edition。
框架还可以,内容全面。不过有两点建议:
- 遵循书的框架,但例子尽量自己造(这样才表示真掌握了),也可参考官网文档。
- 概念的说明尽量参考官网文档(官网比较简洁准确)。
- 一定要构建一个实验环境(用中学)
- 原书的github示例和docker完全可以不用。
以下为章节列表,读书笔记已经发布的会附上URL。
读书笔记 |
---|
1 Introduction to PostgreSQL |
2 Getting to Know Your Cluster |
3 Managing Users and Connections |
4 Basic Statements |
5 Advanced Statements |
6 Window Functions |
7 Server-Side Programming |
8 Triggers and Rules |
9 Partitioning |
10 Users, Roles, and Database Security |
11 Transactions, MVCC, WALs, and Checkpoints |
12 Extending the Database – the Extension Ecosystem |
13 Query Tuning, Indexes, and Performance Optimization |
14 Logging and Auditing |
15 Backup and Restore |
16 Configuration and Monitoring |
17 Physical Replication |
18 Logical Replication |
19 Useful Tools and Extensions |