封面
版权页
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
Summary
Chapter 3. Database Hardware Benchmarking
Physical disk performance
Disk benchmarking tools
Sample disk results
Summary
Chapter 4. Disk Setup
Filesystem crash recovery
Linux filesystems
Solaris and FreeBSD filesystems
Windows filesystems
Disk layout for PostgreSQL
Summary
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
Summary
Chapter 6. Server Configuration Tuning
Server-wide settings
Per-client settings
New server tuning
Dedicated server guidelines
Shared server guidelines
pgtune
Summary
Chapter 7. Routine Maintenance
Vacuum
Autoanalyze
Index bloat
Detailed data and index page monitoring
Monitoring query logs
Summary
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
Summary
Chapter 9. Database Indexing
Index creation and maintenance
Index types
Advanced index use
Summary
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
Summary
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
Summary
Chapter 12. Monitoring and Trending
Windows monitoring tools
Trending software
Summary
Chapter 13. Pooling and Caching
Database caching
Summary
Chapter 14. Scaling with Replication
Replication queue managers
Special application requirements
Other interesting replication projects
Summary
Chapter 15. Partitioning Data
Horizontal partitioning with PL/Proxy
Summary
Chapter 16. Avoiding Common Problems
Common performance issues
Profiling the database
Performance related features by version
Summary
更新时间：2021-04-13 16:59:07
完结共109章
倒序