lundi 29 décembre 2014

Does changing a Postgresql table's tablespace compact it like "vacuum full" or "cluster"?


I need to reclaim disk space in a table in a Postgresql 9.3.2 database to be used for other tables. The standard suggestions to accomplish this are: "VACUUM FULL" or "CLUSTER" or copy the contents into a flat file and copy them back in. When moving an existing table to a new tablespace with an "ALTER TABLE" command, the table's contents are copied. Can anyone tell me if they are compacted during the "ALTER TABLE" process?





Aucun commentaire:

Enregistrer un commentaire