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.


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