On 03/04/2018 09:36, Kein Name wrote:
However no space seems to be freed to the system.
Is there any way a bloody newbie can debug this behaviour?
VACUUM <> VACUUM FULL
Normally running VACUUM via autovacuum should help reuse free space but not
actually return it to the filesystem / OS (unless it happens to be the last
blocks in the data file(s)).
Ppl in normal/average type of installations/workloads no longer (since 8.2) run
VACUUM (or VACUUM FULL) by hand, except in extra ordinary cases where e.g. need
for free space is urgent.
Any help is appreciated!
Thanks
Stefan
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
