Edit C:\Program Files (x86)\PostgreSQL\9.5\pgAdmin III\docs\en_US\hints\vacuum-full.html
<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <link rel="STYLESHEET" type="text/css" href="../pgadmin3.css"> <title>Guru Hints</title> </head> <body> <h3>VACUUM FULL</h3> <p> VACUUM FULL is not recommended for PostgreSQL versions prior to 9.0, except in extreme circumstances. </p> <p> VACUUM FULL should only be used if large amounts of data have been updated or deleted in a table, in order to release space back to the operating system. In cases where the space can be expected to be used by the table in the future, a regular VACUUM should be used instead. </p> <p> VACUUM FULL will take exclusive locks in the database, preventing <i>all</i> other activity on the table(s) being VACUUMed, and as such will have a very large impact on other users of the database while it runs. </p> <p> After a table or database has been VACUUM FULL'ed, it is recommended to REINDEX all indexes on the table as well. </p> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de