Subscription

Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

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

Summary

This chapter was all about system statistics. You learned how to extract information from PostgreSQL and how to use system statistics in a beneficial way. The most important views were discussed in detail. Chapter 6, Optimizing Queries for Good Performance, which is the next chapter in this book, is all about query optimization. You will learn how to inspect queries and how they are optimized.

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