本书由资深数据库专业开发人员撰写，系统介绍PostgreSQL 10的丰富特性及其在生产实践运维中的技巧，全书分为18章。基础篇包括第1~4章，主要介绍PostgreSQL基础知识，例如安装与配置、客户端工具、数据类型、SQL高级特性等，为读者阅读核心篇和进阶篇做好准备；核心篇包括第5~9章，主要介绍PostgreSQL核心内容，例如体系结构、并行查询、事务与并发控制、分区表等；进阶篇包括第10~18章，主要介绍PostgreSQL高级内容，例如性能优化、物理复制、逻辑复制、备份与恢复、高可用、版本升级、扩展模块、Oracle数据库迁移PostgreSQL实战、PostGIS等。

本书基于PostgreSQL 10编写，重点介绍PostgreSQL的丰富特性以及生产实践运维技巧。全书共18章，分为基础篇、核心篇、进阶篇三部分。基础篇包括第1到4章，主要介绍PostgreSQL基础知识，例如安装、客户端工具、数据类型、SQL高级特性等，为读者阅读核心篇和进阶篇做好准备；核心篇包括第5到9章，主要介绍PostgreSQL核心内容，例如体系结构、并行查询、事务与并发控制、分区表、NoSQL特性等；进阶篇包括第10到18章，主要介绍PostgreSQL进阶内容，例如性能优化、物理复制、逻辑复制、备份与恢复、高可用、版本升级、Oracle数据库迁移PostgreSQL实战、PostGIS等。

本书由资深数据库专业开发人员撰写，系统介绍PostgreSQL 10的丰富特性及其在生产实践运维中的技巧，全书分为18章。基础篇包括第1~4章，主要介绍PostgreSQL基础知识，例如安装与配置、客户端工具、数据类型、SQL高级特性等，为读者阅读核心篇和进阶篇做好准备；核心篇包括第5~9章，主要介绍PostgreSQL核心内容，例如体系结构、并行查询、事务与并发控制、分区表等；进阶篇包括第10~18章，主要介绍PostgreSQL高级内容，例如性能优化、物理复制、逻辑复制、备份与恢复、高可用、版本升级、扩展模块、Oracle数据库迁移PostgreSQL实战、PostGIS等。

If you are a PostgreSQL data architect or an administrator and want to understand how to implement advanced functionalities and master complex administrative tasks with PostgreSQL 10, then this book is perfect for you. Prior experience of administrating a PostgreSQL database and a working knowledge of SQL are required to make the best use of this book.

Thanks to its reliability, robustness, and high performance, PostgreSQL has become the most advanced open source database on the market. This third edition of Mastering PostgreSQL helps you build dynamic database solutions for enterprise applications using the latest release of PostgreSQL, which enables database analysts to design both physical and technical aspects of system architecture with ease.Starting with an introduction to the newly released features in PostgreSQL 12, this book will help you build efficient and fault-tolerant PostgreSQL applications. You’ll thoroughly examine the advanced features of PostgreSQL, including logical replication, database clusters, performance tuning, monitoring, and user management. You’ll also work with the PostgreSQL optimizer, configure PostgreSQL for high speed, and understand how to move from Oracle to PostgreSQL. As you progress through the chapters, you’ll cover transactions, locking, indexes, and how to optimize queries for improved performance. Additionally, you’ll learn how to manage network security and explore backups and replications while understanding useful PostgreSQL extensions to help you in optimizing the performance of large databases.By the end of this PostgreSQL book, you’ll be able to get the most out of your database by implementing advanced administrative tasks effortlessly.

This book is for moderate to advanced PostgreSQL database professionals who wish to extend PostgreSQL, utilizing the most updated features of PostgreSQL 9.4. For a better understanding of this book, familiarity with writing SQL, a basic idea of query tuning, and some coding experience in your preferred language is expected.

If you're interested in learning more about PostgreSQL - one of the most popular relational databases in the world, then this book is for you. Those looking to build solid database or data warehousing applications with PostgreSQL 10 will also find this book a useful resource. No prior knowledge of database programming or administration is required to get started with this book.

If you are a database administrator who needs to get to grips with PostgreSQL quickly and efficiently, then this book is for you. This book will also be highly beneficial if you are a project leader or a developer who is interested in knowing more about database systems or bottleneck detection, as it will enable you to work more closely and cooperatively with your administrators.

This book is for system administrators, database administrators, data architects, developers, and anyone with an interest in planning for, or running, live production databases. This book is most suited to those who have some technical experience.

本书分为四大部分，分别为准备篇、基础篇、提高篇和配套开源软件及架构篇。 准备篇为没有数据库基础的读者准备的，如果你已经具备了一定的数据库基础，可以跳过其中的一些内容。 基础篇介绍了PostgreSQL数据库中的一些基础内容，你学习完此篇可以完成基本的PostgreSQL数据库的日常操作工作。 提高篇讲解了一些更深的内容，如PostgreSQL的一些技术内幕、特色功能、优化等方面的内容，你仔细阅读此篇以便早日成为PostgreSQL数据库高手。 第三方开源软件及架构篇讲解了与PostgreSQL数据库配套使用的一些常用的开源软件及架构设计方面的内容，通过阅读此篇，可以提高你的眼界和数据库架构设计能力。