Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Conferences

Free Learning

You're reading from Mastering PostgreSQL 12 Advanced techniques to build and administer scalable and reliable PostgreSQL database applications

Product type Paperback

Published in Nov 2019

Publisher Packt

ISBN-13 9781838988821

Length 470 pages

Edition 3rd Edition

Languages

SQL

Tools

PostgreSQL

Concepts

Databases

Author (1):

Hans-Jürgen Schönig

View More author details

Table of Contents (18) Chapters

Preface

1. Section 1: Basic Overview FREE CHAPTER

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 Enjoy

Leave a review - let other readers know what you think

Section 2: Advanced Concepts

This section expands upon the key topics of PostgreSQL 12.

This section contains the following chapters:

Chapter 3, Making Use of Indexes
Chapter 4, Handling Advanced SQL
Chapter 5, Log Files and System Statistics
Chapter 6, Optimizing Queries for Good Performance
Chapter 7, Writing Stored Procedures
Chapter 8, Managing PostgreSQL Security
Chapter 9, Handling Backup and Recovery
Chapter 10, Making Sense of Backups and Replication
Chapter 11, Deciding on Useful Extensions
Chapter 12, Troubleshooting PostgreSQL
Chapter 13, Migrating to PostgreSQL

The rest of the chapter is locked

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $19.99/month. Cancel anytime

Authors (1)

Hans-Jürgen Schönig

Hans-Jürgen Schönig has 25 years of experience with PostgreSQL. He is the CEO of a PostgreSQL consulting and support company called CYBERTEC PostgreSQL International GmbH, which has successfully served countless customers around the globe. Before founding CYBERTEC PostgreSQL International 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.

See other products by Hans-Jürgen Schönig