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

About the author (2010)

Gregory Smith is the principal consultant in the United States for international PostgreSQL services firm 2ndQuadrant. Based in Baltimore, MD, he's been providing database advice to clients in industries like manufacturing, finance, and web development for twenty years. Dedicated to open-source technology since early in his career, Greg turned to full-time PostgreSQL work by diving in at the source code level. He contributes regular feature patches to the core database and has written a variety of database tools. This book reflects the perspective that he's gained over the last few years as one of the most prolific sources of advice on the popular PostgreSQL community mailing lists.

Bibliographic information