Mastering PostgreSQL 12 - Third Edition

4.3 (3 reviews total)
By Hans-Jürgen Schönig
  • Instant online access to over 7,500+ books and videos
  • Constantly updated with 100+ new titles each month
  • Breadth and depth in over 1,000+ technologies
  1. Section 1: Basic Overview

About 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.

Publication date:
November 2019
Publisher
Packt
Pages
470
ISBN
9781838988821

 

Section 1: Basic Overview

This introductory section aims to provide an overview of the latest version of PostgreSQL and ensuring that you understand some of the basic concepts around it.

This section contains the following chapters:

About the Author

  • Hans-Jürgen Schönig

    Hans-Jürgen Schönig has 18 years' experience with PostgreSQL. He is the CEO of a PostgreSQL consulting and support company called Cybertec Schönig and Schönig GmbH. It has successfully served countless customers around the globe. Before founding Cybertec Schönig and Schönig GmbH in 2000, he worked as a database developer at a private research company that focused on the Austrian labor market, where he primarily worked on data mining and forecast models. He has also written several books about PostgreSQL.

    Browse publications by this author

Latest Reviews

(3 reviews total)
It was informative, helpful, and I learned a few things which pretty much justified the purchase.
很優惠的價格,希望可以常常辦這樣的活動,不過有些檔案太大,不可以傳到kindle有點可惜
it's good , but the general information about the DB is not efficient.

Recommended For You

Book Title
Unlock this full book FREE 10 day trial
Start Free Trial