In the last chapter, we talked about the importance of logging and how to/when to/what to log. We looked at different logging parameters and their use cases. And we covered what should be monitored at the OS and database level, and details about a few monitoring tools. In this chapter, we will start with the MVCC concept in PostgreSQL and will continue with the maintenance activities in PostgreSQL and how to schedule them based on information available. We will also look at how autovacuum and VACUUM works in PostgreSQL and how to improve the performance of the database. We will also ...
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.
