Re: Autovacuum Problem

> 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.

Hmmmm then when is the space released to the system when the manual VACUUM
FULL run is not done? Any way to "force" this?

2018-04-03 8:49 GMT+02:00 Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>:

> 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
>
>
>