Saved Bookmarks
| 1. |
What Is Vacuum And When Should I Run This? |
|
Answer» VACUUM reclaims storage occupied by deleted tuples. In NORMAL GPDB operation, tuples that are deleted or OBSOLETED by an update are not physically REMOVED from their table. They REMAIN present on DISK until a VACUUM is done. Therefore, it is necessary to do VACUUM periodically, especially on frequently-updated table. VACUUM reclaims storage occupied by deleted tuples. In normal GPDB operation, tuples that are deleted or obsoleted by an update are not physically removed from their table. They remain present on disk until a VACUUM is done. Therefore, it is necessary to do VACUUM periodically, especially on frequently-updated table. |
|