فهرست مطالب

• 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