Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Mastering PostgreSQL 12

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

Arrow left icon
Product type Paperback
Published in Nov 2019
Publisher Packt
ISBN-13 9781838988821
Length 470 pages
Edition 3rd Edition
Languages
Concepts
Arrow right icon
Author (1):
Arrow left icon
Hans-Jürgen Schönig Hans-Jürgen Schönig
Author Profile Icon Hans-Jürgen Schönig
Hans-Jürgen Schönig
Arrow right icon
View More author details
Toc

Table of Contents (18) Chapters Close

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

What this book covers

Chapter 1, PostgreSQL 12 Overviewprovides an overview of PostgreSQL and its features. You will learn about the new functionalities available in PostgreSQL 12.

Chapter 2, Understanding Transactions and Lockingcovers one of the most important aspects of any database system: proper database work is usually not possible without the existence of transactions. Understanding transactions and locking is vital to performance, as well as professional work.

Chapter 3, Making Use of Indexescovers everything you need to know about indexes. Indexes are key to performance and are therefore an important cornerstone if you want a good user experience and high throughput. All the important aspects of indexing will be covered in this chapter.

Chapter 4, Handling Advanced SQLintroduces you to some of the most important concepts of modern SQL. You will learn about windowing functions as well as other important current elements of SQL.

Chapter 5, Log Files and System Statisticsguides you through administrative tasks such as log file management and monitoring. You will learn how to inspect your servers and extract runtime information from PostgreSQL. 

Chapter 6, Optimizing Queries for Good Performancetells you everything you need to know about good PostgreSQL performance. The chapter covers SQL tuning and information about memory management.

Chapter 7, Writing Stored Proceduresteaches you some of the advanced topics related to server-side code. In this chapter, the most important server-side programming languages are covered and important aspects are pointed out.

Chapter 8, Managing PostgreSQL Securityis designed to help you improve the security of your server. The chapter features everything from user management to Row-Level Security (RLS). Information about encryption is also included.

Chapter 9, Handling Backup and Recoveryis all about backups and data recovery. You will learn how to back up your data, which will enable you to restore things in the event of a disaster.

Chapter 10, Making Sense of Backups and Replicationis all about redundancy. You will learn how to asynchronously and synchronously replicate PostgreSQL database systems. All modern features are covered as extensively as possible.

Chapter 11, Deciding on Useful Extensionsdescribes the widely used modules that add more functionality to PostgreSQL. You will also learn about the most common extensions.

Chapter 12, Troubleshooting PostgreSQLoffers a systematic approach to fixing problems in PostgreSQL. It will enable you to spot common problems and approach them in an organized way.

Chapter 13, Migrating to PostgreSQLis the final chapter of this book and it shows you how to migrate from commercial databases to PostgreSQL. This chapter covers the most important databases migrated these days.

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
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
Renews at $19.99/month. Cancel anytime
Banner background image