PostgreSQL 9.0: High Performance

Front Cover
Packt Publishing Ltd, Oct 20, 2010 - Computers - 442 pages
0 Reviews
Accelerate your PostgreSQL system. Improving database performance requires an equal mix of understanding theoretical concepts and working through hands-on examples. You'll find both here. Many of the examples given will be immediately useful for monitoring and improving your PostgreSQL deployments, providing insight into hard-to-obtain information about your database. This book is aimed at intermediate to advanced database administrators using or planning to use PostgreSQL. Portions will also interest systems administrators looking to build or monitor a PostgreSQL installation, as well as developers interested in advanced database internals that impact application design.
 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

PostgreSQL Versions
Summary
Summary by usage count
Summary
Server Configuration Tuning Interacting with thelive configuration Defaults and reset values
Checkpoints
TransactionIDwraparound Vacuum
Recovering frommajor problems Autoanalyze
pgbench custom tests
Insert speed test Transaction Processing Performance Councilbenchmarks Summary 9 Database Indexing
Processing nodes Sort
Joins
Other query planning parameters effective_cache_size
Summary
Summary
Copyright

Common terms and phrases

Bibliographic information