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 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:

Chapter 1, PostgreSQL 12 Overview
Chapter 2, Understanding Transactions and Locking

You have been reading a chapter from

Mastering PostgreSQL 12 - Third Edition

Published in: Nov 2019

Publisher: Packt

ISBN-13: 9781838988821

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