What do you get with eBook?

Instant access to your Digital eBook purchase

Download this book in EPUB and PDF formats

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

AI Assistant (beta) to help accelerate your learning

PostgreSQL 12 Overview

After the usual development cycle, PostgreSQL 12 was released to the public in autumn 2019. The new release offers a variety of new features and provides a rich set of functionality to users, which will make application development faster, improve performance, and generally make PostgreSQL even more usable than it previously was. Many of the new features open the door for further development in the future and will enable developers to implement cutting edge technologies in the decades to come. In this chapter, you will be introduced to those new features and will get an overview of what has been improved, added, and even changed.

The following topics will be covered:

What's new in PostgreSQL 12?
SQL and developer-related features
Backup, recovery, and replication
Performance-related topics
Storage-related topics

All relevant features will be covered...

Key benefits

Grasp advanced PostgreSQL 12 concepts with real-world examples and sample datasets

Explore query parallelism, data replication, database administration, and more

Extend PostgreSQL functionalities to suit your organization’s needs with minimal effort

Description

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.

What you will learn

Understand the advanced SQL functions in PostgreSQL 12

Use indexing features in PostgreSQL to fine-tune the performance of queries

Work with stored procedures and manage backup and recovery

Master replication and failover techniques to reduce data loss

Replicate PostgreSQL database systems to create backups and to scale your database

Manage and improve the security of your server to protect your data

Troubleshoot your PostgreSQL instance for solutions to common and not-so-common problems

What do you get with eBook?

Instant access to your Digital eBook purchase

Download this book in EPUB and PDF formats

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

AI Assistant (beta) to help accelerate your learning

Frequently bought together

£32.99

£41.99

£36.99

Total £ 111.97

Dad Feb 16, 2021

This is a good comprehensive book for someone coming back to PostgreSQL after not using it for a while.

Amazon Verified review

Susanthab Jul 12, 2020

I'm new to Postgres. My back ground is MS SQL Server. This book helped me greatly, to quickly learn and practice Postgres from the beginning. This book has plenty of examples which you can run yourself and see its execution. So I'd highly recommend this book for anyone who wants to learn Postgres.

G. Wideman Feb 11, 2020

This is not an intro book about PostgreSQL or databases in general, but it is a very good book for someone already generally familiar with databases such as MySQL or SQL Server, who can use some in-depth discussion of the PostgreSQL particulars of a spectrum of essential and moderately advanced topics. Inexplicably, Packt has failed to include the Table of Contents in the Amazon preview, so here it is: 1 Basic Overview 2 PostgreSQL 12 Overview 3 Understanding Transactions and Locking 4 Section 2: Advanced Concepts 5 Making Use of Indexes 6 Handling Advanced SQL 7 Log Files and System Statistics 8 Optimizing Queries for Good Performance 9 Writing Stored Procedures 10 Managing PostgreSQL Security 11 Handling Backup and Recovery 12 Making Sense of Backups and Replication 13 Deciding on Useful Extensions 14 Troubleshooting PostgreSQL 15 Migrating to PostgreSQL 16 Assessment 17 Other Books You May EnjoyIn the past I've found some Packt books utterly abysmal, from incomprehensible writing that was seemingly raw from Google translate, to technical information that was badly organized, irrelevant or just plain wrong. This book is very far from that. The narrative is very readable, the topics are covered at a good level of detail, and often anticipate issues that might puzzle you, or tie in related topics that you would likely want to know. "Well done!" to author Schonig, and to those at Packt responsible for facilitating a good quality result. (But maybe get that ToC into the "Look Inside"?)

Mike Hogarth Jun 17, 2020

Average book, no details on PostgreSQL architecture. Mostly DBA info. Ok topics but adding insights into how it achieves ACID is important as fundamental knowledge

Cathy Hart May 11, 2020

Based on the chapter headings, these topics are clearly important to mastering Postgres. However, delving into the content, the results are well short of mastering. There is repeated use of the words, "understanding", "digging into", "making use of", "handling" but again, well short of accomplishment.For example, in Chapter 9: Handling Backup and Recovery, there is little or no description of the requirements, setup, and execution of said backup and recovery; the subsequent chapter "Making sense of Backups..." is no better. There is hinting insofar as what the syntax is and what a replay command looks like, but no detail of the structure/process of the WAL, checkpoints, lsn's and other important information needed to master the topic. Case in point, in the 'Running pg_dump' section, the entire content of that is one page, half of which is consumed by an example of the command and a screen capture of the output of the --help text. It does mention that pg_dump locks the table, so that's useful, but I can get that from the official Postgres documentation.At no point did I consider myself mastering the topic after reading the brief discussions - I only realized I would have to find another source for more information. I gave it 2 stars becuase the author made good examples and determined a decent outline for the topics. However, if the intent is to produce masters after reading, the book will need to be significantly deeper.

Mastering PostgreSQL 12: Advanced techniques to build and administer scalable and reliable PostgreSQL database applications , Third Edition

What do you get with eBook?

Mastering PostgreSQL 12

PostgreSQL 12 Overview

What's new in PostgreSQL 12?

Digging into SQL and developer-related topics

Improving psql and database documentation

Summary

Page 1 of 3

Key benefits

Description

Who is this book for?

What you will learn

Product Details

What do you get with eBook?

Product Details

Frequently bought together

Table of Contents

Recommendations for you

Customer reviews

People who bought this also bought

About the author

FAQs

Mastering PostgreSQL 12: Advanced techniques to build and administer scalable and reliable PostgreSQL database applications , Third Edition

What do you get with eBook?

Key benefits

Description

Who is this book for?

What you will learn

Product Details

What do you get with eBook?

Product Details

Packt Subscriptions

Frequently bought together

Table of Contents

Recommendations for you

Customer reviews

People who bought this also bought

About the author

FAQs