![]() ![]() ![]() This is a useful distinction if you do not have space constraints but want your VACUUM command to be as quick as possible. ![]() VACUUM SORT ONLY: This type of VACUUM command only sorts the data on disc.One can specify a specific table to VACUUM, or it can do an entire database (this operation can take a long time). It sorts the specified table and reclaims any disc space cleared out by DELETE or UPDATE commands. VACUUM FULL: This is the default VACUUM command.There are a few different types of VACUUM commands: ![]() This condenses the data footprint, making data more easily accessible and cheaper to store. Redshift will automatically sort rows and run VACUUM DELETE in the background.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |