In the previous chapter, we saw how to troubleshoot the initial hiccups faced by people who are new to PostgreSQL. We also covered a couple of PostgreSQL views and Linux utilities that help us see what is exactly happening when we are in a no-response situation.

In this chapter, we will cover a variety of topics. We will look at a few useful, but not commonly used data types. We will also cover pgbadger, a nifty third-party tool that can run through a PostgreSQL log. This tool can tell us a lot about what is happening in the cluster. Also, we will look at a few key features that are part of the PostgreSQL 9.4 release. We will cover a couple of useful extensions.