I have a large database running with PostgreSQL v11, and the disk space is very limited, so I have to
VACUUM (FULL) the database frequently (e.g. every day).
But vacuuming is a very time-consuming operation. Furthermore, I often encounter vacuum error message such as
ERROR: canceling autovacuum task CONTEXT: automatic vacuum of table ***
Fortunately, the service can be shutdown at a particular time point of the day, so I can dump the database after shutting it down, restore it immediately and restart the service again.
In addition, I found that "dumping/restoring" is faster than "vacuuming".
My question: Do the things that are done by "dumping/restoring" include the things what are done by "vacuuming full"?
If so, I can do it instead of vacuuming.