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