Mastering PostgreSQL 13 build, administer, and maintain database applications efficiently with PostgreSQL 13

Explore expert techniques such as advanced indexing and high availability to build scalable, reliable, and fault-tolerant database applications using PostgreSQL 13Key FeaturesMaster advanced PostgreSQL 13 concepts with the help of real-world datasets and examplesLeverage PostgreSQL’s indexing featur...

Full description

Bibliographic Details
Other Authors: Schonig, Hans-Jurgen, author (author)
Format: eBook
Language:Inglés
Published: Birmingham, England ; Mumbai : Packt [2020]
Edition:Fourth edition
Subjects:
See on Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009631454006719
Table of Contents:
  • Contributors
  • Table of Contents
  • Preface
  • Chapter 1: PostgreSQL 13 Overview
  • Chapter 2: Understanding Transactions and Locking
  • 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
  • Other Books You May Enjoy
  • Index.