In the last chapter, we talked about some basic things about MVCC in PostgreSQL, and what is bloat in the database and how it can be removed. We explained how autovacuum helps in removing bloat and improving performance. We also covered the best practices to execute maintenance activities like VACUUM and reindex in detail. In this chapter, we will talk about the importance of High Availability (HA), and what information we need to build an HA solution and the procedures to implement it in PostgreSQL. We will cover some open source and enterprise tools ...
7. High Availability Procedures and Implementing a Pooler
Baji Shaik1
(1)
Hyderabad, Andhra Pradesh, India
Get PostgreSQL Configuration: Best Practices for Performance and Security now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
