更新时间：2021-04-13 16:59:07
封面
版权页
Credits
About the Author
About the Reviewers
Preface
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Chapter 1. PostgreSQL Versions
PostgreSQL or another database?
PostgreSQL tools
PostgreSQL application scaling lifecycle
Performance tuning as a practice
Summary
Chapter 2. Database Hardware
Reliable controller and disk setup
Chapter 3. Database Hardware Benchmarking
Physical disk performance
Disk benchmarking tools
Sample disk results
Chapter 4. Disk Setup
Filesystem crash recovery
Linux filesystems
Solaris and FreeBSD filesystems
Windows filesystems
Disk layout for PostgreSQL
Chapter 5. Memory for Database Caching
Inspecting the database cache
Crash recovery and the buffer cache
Database buffer cache versus operating system cache
Analyzing buffer cache contents
Chapter 6. Server Configuration Tuning
Server-wide settings
Per-client settings
New server tuning
Dedicated server guidelines
Shared server guidelines
pgtune
Chapter 7. Routine Maintenance
Vacuum
Autoanalyze
Index bloat
Detailed data and index page monitoring
Monitoring query logs
Chapter 8. Database Benchmarking
Running pgbench manually
Graphing results with pgbench-tools
Sample pgbench test results
Sources for bad results and variation
pgbench custom tests
Transaction Processing Performance Council benchmarks
Chapter 9. Database Indexing
Index creation and maintenance
Index types
Advanced index use
Chapter 10. Query Optimization
EXPLAIN basics
Query plan node structure
Explain analysis tools
Assembling row sets
Processing nodes
Joins
Statistics
Other query planning parameters
Executing other statement types
Improving queries
SQL Limitations
Chapter 11. Database Activity and Statistics
Cumulative and live views
Table statistics
Index statistics
Database wide totals
Connections and activity
Locks
Disk usage
Buffer background writer and checkpoint activity
Chapter 12. Monitoring and Trending
Windows monitoring tools
Trending software
Chapter 13. Pooling and Caching
Database caching
Chapter 14. Scaling with Replication
Replication queue managers
Special application requirements
Other interesting replication projects
