PostgreSQL 9.0 High Performance

If you’re an intermediate to advanced database administrator, this book is the shortcut to optimizing and troubleshooting your PostgreSQL database. With a balanced mix of theory and practice, it will quickly hone your expertise.

PostgreSQL 9.0 High Performance

Gregory Smith

2 customer reviews
If you’re an intermediate to advanced database administrator, this book is the shortcut to optimizing and troubleshooting your PostgreSQL database. With a balanced mix of theory and practice, it will quickly hone your expertise.
eBook
$10.00
RRP $29.99
Save 66%
Print + eBook
$49.99
RRP $49.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$10.00
$49.99
RRP $29.99
RRP $49.99
eBook
Print + eBook

Frequently bought together


PostgreSQL 9.0 High Performance Book Cover
PostgreSQL 9.0 High Performance
$ 29.99
$ 10.00
PostgreSQL 9 Administration Cookbook - Second Edition Book Cover
PostgreSQL 9 Administration Cookbook - Second Edition
$ 47.99
$ 10.00
Buy 2 for $20.00
Save $57.98
Add to Cart

Book Details

ISBN 139781849510301
Paperback468 pages

Book Description

PostgreSQL database servers have a common set of problems they encounter as their usage gets heavier and requirements more demanding. You could spend years discovering solutions to them all, step by step as you encounter them. Or you can just look in here.

All successful database applications are destined to eventually run into issues scaling up their performance. Peek into the future of your PostgreSQL database's problems today. Know the warning signs to look for, and how to avoid the most common issues before they even happen.

Surprisingly, most PostgreSQL database applications evolve in the same way: Choose the right hardware. Tune the operating system and server memory use. Optimize queries against the database, with the right indexes. Monitor every layer, from hardware to queries, using some tools that are inside PostgreSQL and others that are external.

Using monitoring insight, continuously rework the design and configuration. On reaching the limits of a single server, break things up; connection pooling, caching, partitioning, and replication can all help handle increasing database workloads.

The path to a high performance database system isn't always easy. But it doesn't have to be mysterious with the right guide.

Table of Contents

What You Will Learn

  • Learn best practices culled from years of work scaling PostgreSQL installations to handle demanding applications
  • Uncover what makes hardware good or bad for high-performance database applications
  • Investigate making informed speed and reliability trade-offs
  • Tweak your operating system for best database performance
  • Benchmark your whole system from hardware to application
  • Learn how the server parameters that impact performance work using real examples
  • Understand how the query optimizer makes its decisions, and what to do when it makes the wrong ones
  • Monitor what happens on your server, both in and outside of the database
  • Find the best add-on tools that extend the core PostgreSQL database
  • Discover how to architect replicated systems using the latest features added to PostgreSQL 9.0

Authors

Table of Contents

Book Details

ISBN 139781849510301
Paperback468 pages
Read More
From 2 reviews

Read More Reviews

These popular $10 titles might interest you

PostgreSQL 9 Administration Cookbook - Second Edition Book Cover
PostgreSQL 9 Administration Cookbook - Second Edition
$ 47.99
$ 10.00
PostgreSQL Server Programming Book Cover
PostgreSQL Server Programming
$ 29.99
$ 6.00
PostgreSQL 9 High Availability Cookbook Book Cover
PostgreSQL 9 High Availability Cookbook
$ 26.99
$ 10.00
Continuous Delivery and DevOps: A Quickstart guide Book Cover
Continuous Delivery and DevOps: A Quickstart guide
$ 14.99
$ 10.00
DNS in Action Book Cover
DNS in Action
$ 17.99
$ 10.00
Python 3 Object Oriented Programming Book Cover
Python 3 Object Oriented Programming
$ 29.99
$ 10.00