Book Image

Troubleshooting PostgreSQL

Book Image

Troubleshooting PostgreSQL

Overview of this book

Table of Contents (17 chapters)
Troubleshooting PostgreSQL
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Chapter 10. A Standard Approach to Troubleshooting

In this chapter, the goal is to sum up some of the approaches you have seen in this book and combine them into one overall approach for typical everyday scenarios. Customers may come up with any or all of the following statements:

  • "My database is slow"

  • "CPU usage and I/O are going through the roof"

  • "It has not always been so slow"

  • "Sometimes, replication fails"

  • "I'm adding new hardware"

The goal here is to provide you with a systematic approach to the problem and point to solutions. Note that the example outlined in this chapter is a typical case faced by clients around the globe.