PostgreSQL 9.0: High Performance (Google eBook)

Front Cover
Packt Publishing Ltd, Oct 20, 2010 - Computers - 442 pages
4 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

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  - Mark McGranaghan - Goodreads

A useful survey of performance-related Postgres issues. Obviously based on extensive experience with Postgres in production environments. My only problem with the book is that it feels slightly out of ... Read full review


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

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