Henrietta Dombrovskaya covers a couple of background processes:
Welcome to the second blog of the “magic of parameters” series. In the first entry, I covered memory parameters, and in this article. In this article will talk about PostgreSQL configuration parameters which manage the (auto)vacuum and (auto)analyze background processes.
Read on for a deeper dive into vacuuming and a bit on auto-analyze as well.