Chapter 6. Handling Replication and Improving Performance
This chapter is dedicated to everything that is related to the PostgreSQL transaction log as well as replication. The following key topics will be covered in this chapter:
- Understanding the PostgreSQL transaction log
- Configuring checkpoints
- Setting up an asynchronous replication
- Upgrading to a synchronous replication
- Monitoring the replication
At the end of the chapter you should be able to understand, set up, and debug a typical replication scenario with ease.
Understanding the PostgreSQL transaction log
Before digging into the world of replication, it makes sense to stop for a while and focus our attention on the PostgreSQL transaction log. Many people have heard about the transaction log but ...