•SELECT version(); --PostgreSQL 9.4.9
•Currently we have vacuum enabled with conservative setting of %20.
1. The language on the support sites talks about the tables of the Postgress DB being held in individual files ?
If we were to issue a 'vacuum full' command, would the recovery process re-write each table 1 at a time and 0 out the previous table ?
How much extra space do we need to have available to issue 'vacuum full' and not run out of disk space ? (At least as much as the largest table ? or the whole D.B. ?)
2. Can we call 'Vacuum Full' and specify a particular table, we only that table get locked ?
3. Can 'vacuum full' be cancelled once called if it is taking too long and we need to get production back up and running on that table ?