Using PostgreSQL Database

PostgreSQL 9.5 offers several new features such as support for UPSERT, BRIN indexing, faster sorts, and the TABLESAMPLE clause for getting a statistical sample of a large table. In this chapter we shall discuss creating a PostgreSQL 9.5 cluster using the Kubernetes cluster manager. We shall discuss both the imperative approach and the declarative approach to creating and scaling a PostgreSQL cluster. This chapter has the following sections.