As described here - https://www.postgresql.org/docs/current/routine-vacuuming.html#AUTOVACUUM
I didn’t see any mention in the DigitalOcean docs, so I assume not, but wanted to make sure - I’m new to pg and not sure what is standard.
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Sign up for Infrastructure as a Newsletter.
Working on improving health and education, reducing inequality, and spurring economic growth? We'd like to help.
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
I reached out to support some time back with that very question
I think the answer is yes. Anyways it would be nice to have confirmation from official side.
According to this documentation page and as pistle2020 says, the autovacuum deamon is enabled, if the postgres config param ‘autovacuum’ is on.
According to this documentation page, autovacuum only runs, if ‘track_counts’ is on.
Run the following sql queries on your db to find out:
On my fresh instance of digital ocean postgres v13 both queries return:
To find out more about the inner cofiguration of autovacuum, you can output other params listed in the above documentation pages, as e.g.:
Would also like to know! How do we add autovacuum to a DO Managed Database?