© Baji Shaik 2020
B. ShaikPostgreSQL Configurationhttps://doi.org/10.1007/978-1-4842-5663-3_6

6. Execute Maintenance

Baji Shaik1 
(1)
Hyderabad, Andhra Pradesh, India
 

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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.