Hans-Jürgen Schönig - Troubleshooting PostgreSQL [2015, PDF, ENG]

Примеры страниц

Оглавление

1: Installing PostgreSQL
Deciding on a version number
Methods of installing PostgreSQL
Memory and kernel issues
Adding checksums to a database instance
Preventing encoding-related issues
Avoiding template pollution
Summary
2: Creating Data Structures
Grouping columns the right way
Deciding on data types and structure
Deciding on normalization
Summary
3: Handling Indexes
Understanding indexes in PostgreSQL
Avoiding trouble with indexes
Solving common problems
Handling LIKE queries
Finding good matches
Fixing full-text search
Summary
4: Reading Data Efficiently and Correctly
Understanding the power of NULL
Fixing disastrous joins
Reading large amounts of data
Understanding prepared queries
Summary
5: Getting Transactions and Locking Right
The PostgreSQL transaction model
Transaction isolation
Inspecting locks
Summary
6: Writing Proper Procedures
Choosing the right language
Managing procedures and transactions
Procedures and indexing
Understanding memory
Summary
7: PostgreSQL Monitoring
Checking the overall database behavior
Detecting I/O bottlenecks
Checking for conflicts
Chasing down slow queries
Inspecting internal information
Integrating with external tools
Alternative tools
Summary
8: Fixing Backups and Replication
Using pg_dump
Managing point-in-time recovery
Making use of asynchronous replication
Switching to synchronous replication
Handling timelines
Summary
9: Handling Hardware and Software Disasters
Checksums – preventing silent corruption
Zeroing out damaged pages
Dealing with index corruption
Dumping individual pages
Resetting the transaction log
Power-out-related issues
Summary
10: A Standard Approach to Troubleshooting
Getting an overview of the problem
Attacking low performance
Fixing common replication issues
Summary