Home > Categories > Programming > Mastering PostgreSQL 17
Mastering PostgreSQL 17
📥 Download PDF

Mastering PostgreSQL 17

by Hans-Jürgen Schönig

Programming

Book Details

Book Title

Mastering PostgreSQL 17

Author

Hans-Jürgen Schönig

Publisher

Packt Publishing City: Birmingham, UK

Publication Date

2024

ISBN

9781836205975

Number of Pages

474

Language

English

Format

PDF

File Size

2.6MB

Subject

Database – Advanced Level

Table of Contents

  • Cover
  • Title page
  • Copyright and credits
  • Contributors
  • Preface
  • Table of contents
  • Chapter 1: What is New in PostgreSQL 17
  • Understanding DBA and administration features
  • Using SQL and developer features
  • Making use of new replication and backup add-ons
  • Considering breaking changes in PostgreSQL 17
  • Summary
  • Chapter 2: Understanding Transactions and Locking
  • Working with PostgreSQL transactions
  • Understanding basic locking
  • Making use of FOR SHARE and FOR UPDATE
  • Understanding transaction isolation levels
  • Observing deadlocks and similar issues
  • Utilizing advisory locks
  • Optimizing storage and managing cleanup
  • Summary
  • Chapter 3: Making Use of Indexes
  • Understanding simple queries and the cost model
  • Improving speed using clustered tables
  • Understanding additional B-tree features
  • Introducing operator classes
  • Understanding PostgreSQL index types
  • Achieving better answers with fuzzy searching
  • Understanding full-text searches
  • Summary
  • Chapter 4: Handling Advanced SQL
  • Supporting range types
  • Introducing grouping sets
  • Making use of ordered sets
  • Understanding hypothetical aggregates
  • Utilizing windowing functions and analytics
  • Writing your own aggregates
  • Handling recursions
  • Working with JSON and JSONB
  • Summary
  • Chapter 5: Log Files and System Statistics
  • Gathering runtime statistics
  • Creating log files
  • Summary
  • Chapter 6: Optimizing Queries for Good Performance
  • Learning what the PostgreSQL optimizer does
  • Understanding execution plans
  • Understanding and fixing joins
  • Enabling and disabling optimizer settings
  • Partitioning data
  • Adjusting parameters for good query performance
  • Making use of parallel queries
  • Introducing just-in-time (JIT) compilation
  • Summary
  • Chapter 7: Writing Stored Procedures
  • Understanding stored procedure languages
  • Exploring various stored procedure languages
  • Improving functions
  • Using functions for various purposes
  • Summary
  • Chapter 8: Managing PostgreSQL Security
  • Managing network security
  • Digging into row-level security
  • Inspecting and handling permissions
  • Reassigning objects and dropping users
  • Summary
  • Chapter 9: Handling Backup and Recovery
  • Performing simple dumps
  • Handling various formats
  • Replaying backups
  • Handling global data
  • Summary
  • Chapter 10: Making Sense of Backups and Replication
  • Understanding the transaction log
  • Transaction log archiving and recovery
  • Setting up asynchronous replication
  • Upgrading to synchronous replication
  • Making use of replication slots
  • Making use of the CREATE PUBLICATION and CREATE SUBSCRIPTION commands
  • Summary
  • Chapter 11: Deciding on Useful Extensions
  • Understanding how extensions work
  • Making use of contrib modules
  • Other useful extensions
  • Summary
  • Chapter 12: Troubleshooting PostgreSQL
  • Approaching an unknown database
  • Inspecting pg_stat_activity
  • Checking for slow queries
  • Inspecting the log
  • Checking for missing indexes
  • Checking for memory and I/O
  • Understanding noteworthy error scenarios
  • Classical cloud and Kubernetes problems
  • Summary
  • Chapter 13: Migrating to PostgreSQL
  • Migrating SQL statements to PostgreSQL
  • Moving from Oracle to PostgreSQL
  • Summary
  • Index
  • Other Books You May Enjoy