In Chapter 4, Handling Advanced SQL, you learned a lot about advanced SQL and ways to see SQL in a different light. However, database work does not only consist of hacking up fancy SQL. Sometimes, it is also about keeping things running in a professional manner. To do that, it is highly important to keep an eye on system statistics, log files, and so on. Monitoring is the key to running databases professionally.
In this chapter, you will learn about the following topics:
- Gathering runtime statistics
- Creating log files
- Gathering important information
- Making sense of database statistics
At the end of this chapter, you will be able to configure PostgreSQL's logging infrastructure properly and take care of log ...
