Very interesting topic, I did not know the database engine would perform in a such way! Gonna definitively check this for MySQL (as I use it on my day-to-day job). Thank you for sharing :)
For MySQL, the Vacuum operation is not needed because it was implemented differently. So Don't worry about that unles you are using PotgreSQL. ;)
We're a place where coders share, stay up-to-date and grow their careers.
We strive for transparency and don't collect excess data.