PostgreSQL in Action

Name: PostgreSQL in Action
ISBN: 9787111603467

谭峰 / 张文升China Machine Press2018

3.8

Word count: 446K words
Chapters: 21
Series: Database Technology Series
ISBN: 9787111603467

Report an error Find this book

Summary

PostgreSQL in Action is co-authored by Tan Feng and Zhang Wensheng, two engineers long engaged in PostgreSQL development and operations. Written against PostgreSQL 10 and published in China Machine Press's Database Technology Series, the book runs to 18 chapters organized as three progressive parts: Fundamentals, Core, and Advanced. Part One (Chapters 1–4) moves from source compilation and yum installation, client tools, and data types to advanced SQL features such as window functions and WITH queries. Part Two (Chapters 5–9) examines process and memory architecture, parallel query, transactions and concurrency control, partitioned tables, and NoSQL features such as JSON/JSONB. Part Three (Chapters 10–18) covers execution plans and performance tuning, pgbench benchmarking, physical and logical replication, backup and recovery, high-availability architectures, version upgrades, extension modules, a practical path for migrating from Oracle to PostgreSQL, and PostGIS spatial data applications. Built around reproducible commands and configuration examples and enriched with hard-won production operations experience, the book suits developers and DBAs who want to put PostgreSQL to real use in business systems; it also serves as a desk reference for day-to-day troubleshooting.

Editor's review

市面上的 PostgreSQL 图书大致分两类：一类讲内核源码，一类讲入门语法，而真正把“装、调、备、切、迁”串成一条生产链路的并不多，《PostgreSQL实战》补上的正是这一块。作者谭峰是 PostgreSQL 分会特聘专家、多年一线 DBA，张文升长期活跃于开源数据库社区，书里的很多段落读起来像同事在耳边交接班：某个参数为什么这样设、某个备份方案哪里会翻车，都交代得比较实在。这本书结构安排得比较友好：基础篇照顾刚接手 PostgreSQL 的读者，核心篇把体系结构、事务、并行和分区这些“绕不开的坎”讲清楚，进阶篇直接进入复制、高可用、迁移与 PostGIS，几乎覆盖一个中大型业务库会遇到的完整生命周期。书中示例基于 PostgreSQL 10 给出，命令和配置文件可以直接照抄验证；同时它也更像一本需要动手的参考书，性能分析、集群、分片、地理信息等章节适合放在工位边反复翻查。需要提醒的是，数据库版本迭代很快，阅读时建议对照当前版本官方文档核对参数与语法变化。

Who it's for

A good fit for

已会写 SQL、需要接手 PostgreSQL 项目的后端开发工程师
负责数据库日常运维与故障排查的 DBA 及运维人员
正在评估或实施从 Oracle 等商业数据库迁移的技术负责人
需要为业务系统设计高可用与备份方案的中高级工程师

Not a good fit for

完全没有数据库基础、需要从零学习 SQL 的入门读者
只关心 PostgreSQL 内核源码实现原理的研究型读者
希望直接获得最新版本（如 16/17）新特性讲解的读者

Reading tips

先按“基础篇—核心篇—进阶篇”通读一遍建立全局图，再挑与当前工作相关的章节精读。
配套搭建一个 PostgreSQL 实例，把书中的安装、参数、复制与备份命令逐条跑一遍。
阅读时对照所用版本的官方文档核对参数名与语法，遇到差异以官方文档为准。
把性能优化与高可用章节当作手册，遇到慢查询或切换演练时按目录回查。

About the publisher

China Machine Press China · Founded in 1950

In addition to science and technology and professional publishing, the books in our catalog from China Machine Press also reflect a sustained focus on psychology, computing, management, finance and economics, and social sciences. In psychology, the catalog includes works by C. G. Jung and introductions to analytical psychology, as well as applied topics such as stress and health, and addiction and healing. In computing, it features Structure and Interpretation of Computer Programs (JavaScript Edition). Management and finance titles include Administrative Behavior (4th Edition), The Price of Inequality (Collector's Edition), and This Time Is Different: Eight Centuries of Financial Folly (Commemorative Edition). In the philosophy and history of science, there is The Worldview: The Third Edition. Relevant authors include C. G. Jung, William McGuire, Sonu Shamdasani, and Gabor Maté. Public information is limited; the above summarizes the publisher's profile based solely on the books in our catalog.

Fundamentals
Chapter 1 Installation and Configuration Basics
Chapter 2 Client Tools
Chapter 3 Data Types
Chapter 4 Advanced SQL Features
Core
Chapter 5 Architecture
Chapter 6 Parallel Query
Chapter 7 Transactions and Concurrency Control
Chapter 8 Partitioned Tables
Chapter 9 NoSQL Features of PostgreSQL
Advanced
Chapter 10 Performance Optimization
Chapter 11 Benchmarking and pgbench
Chapter 12 Physical and Logical Replication
Chapter 13 Backup and Recovery
Chapter 14 High Availability
Chapter 15 Version Upgrades
Chapter 16 Extension Modules
Chapter 17 Migrating from Oracle to PostgreSQL
Chapter 18 PostGIS

FAQ

这本书基于哪个 PostgreSQL 版本？现在读还适用吗？

书中内容基于 PostgreSQL 10 编写。安装、事务、复制、备份等核心机制的思路至今仍然适用，但部分参数、分区语法与内置函数在新版本中已有变化，建议边读边对照当前版本的官方文档。

没有数据库基础能直接读这本书吗？

不太建议。书中默认读者具备基本的 SQL 与 Linux 操作能力，基础篇也只是对 PostgreSQL 特性做快速铺垫，零基础读者容易在体系结构与复制章节卡住，最好先补一门 SQL 入门课。

这本书和《PostgreSQL修炼之道》有什么区别？

两者都面向实践，但侧重点不同：《PostgreSQL实战》按安装、核心机制、优化、复制、高可用、迁移的运维链路组织，工程落地感更强；《PostgreSQL修炼之道》更强调从小工到专家的能力成长路径，可互为补充。

书里的 PostGIS 和迁移章节值得单独看吗？

值得。第 17 章梳理了从 Oracle 迁移到 PostgreSQL 的常见改造点，第 18 章介绍 PostGIS 空间数据类型与常用查询，对需要做地理信息或国产化替代的项目很有参考价值。

Comments

Find this book

This site is an index: you start “Search all sources” in your browser, and the entries it lists all point to third-party sites; please judge their availability yourself.

About the author

谭峰 Author

Tan Feng: publicly available information is limited. The only confirmed identity detail is one work published under this name, From Rookie to Professional: A Growth Handbook for Newbie Reporters. Classified under language and writing, the book, judging by its title and category, is aimed at young people entering the news industry or students in related fields, offering introductory guidance on basic aspects such as interviewing, writing, and adjusting to the profession. The author organizes the book around the path from "rookie" to "professional," with an emphasis on practical, actionable advice rather than theoretical exposition, reflecting a writing approach that stays close to beginners' needs and focuses on passing on experience. Since only this one work is held in the collection, Tan Feng's other experiences, professional background, and full body of work cannot be verified, and further inference is inadvisable. This book alone occupies a place among introductory readings for new reporters and may serve readers interested in news writing and language expression.

张文升 Author

Zhang Wensheng — public information about this author is limited. The only known work is Smart + Retail: Business Transformation and Restructuring in the New Retail Era, which is classified under management. Judging from the title and category, the author focuses on the transformation of the retail industry against the backdrop of intelligent and digital technologies, discussing adjustments to business models and structural reorganization in the new retail era, and addressing the integration of technology application with business operations. The book is aimed at readers in retail and corporate management and seeks to sort out key issues in the industry's changes. Because verifiable information about the author's personal experience and background is extremely scarce, his professional identity and credentials cannot be confirmed; apart from this work, no further public record of his writing or industry influence is available, and readers should rely on the book itself for an understanding of his views.