PostgreSQL 9.0: High Performance (Google eBook)

Front Cover
Packt Publishing Ltd, 2010 - Computers - 442 pages
1 Review
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

Review: PostgreSQL 9.0 High Performance

User Review  - Ingmar - Goodreads

Definitely full of useful advice, often with detailed background information. Like many tech books, it suffers a bit from the fact that the author is more engineer than author, and apparently also was ... Read full review

Review: PostgreSQL 9.0 High Performance

User Review  - Dave Peticolas - Goodreads

All about making Postgres go fast, everything from low-level disk I/O to query optimization and more. The chapter on using EXPLAIN was worth the price of the book. Read full review

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 C. Smith, PhD is Professor of Human Development, Family Studies, & Gerontology; and Director, Human Development Center, College of Education, Health, & Human Services, Kent State University. His primary research interests concern informal care giving within aging families, for which his work has been funded by the National Institute on Aging, National Institute of Mental Health, and National Institute of Nursing Research. Dr. Smith is Associate Editor of the" International Journal of Aging and Human Development", and a Fellow of the Gerontological Society of America. He has been a peer reviewer of research grant applications submitted to the National Institutes of Health and to the National Institute of Disability and Rehabilitation Research. Dr. Smith was honored as Outstanding Researcher of the Year by the Ohio Association of Gerontology and Education in 2006. Dr. Smith is has contributed over 75 book chapters, peer-reviewed articles, book reviews, and conference presentations.

Bibliographic information