Hello,
I'm sorry in advance if this question been asked already, but I failed to find any information about.
Could you please explain me what each of Housekeeping options actually do and how often I should run it in order to keep my DB working well and fast?
I mean: Vacuum & Analyze, Reindex, Cluster, Vacuum Full & Tune PostgreSQL options.
Also I want to know what does Rebuild Cache? Does it all those options I listed above altogether or does totally different thing?
Thanks in advance for any help!