Re: Autovacuum Problem

On 03/04/2018 10:54, Kein Name wrote:
> > Why would you want that? Do you have any control over the application? Any "special" patterns used in the app?
>
> Drive is running full :/
> Sadly I have no control and knowledge whatsoever over/about the application.
>
> I tuned the autovacuum parameters now for the critical tables, to have it run more often and using greater ressources while doing so.... but I am unsure if this helps with the bloating.

You could try to setting log_statement=all for a (short) period with a typical "heavy-ish" write activity to know what the app is doing.
IMHO you must prepare for a larger storage. After that you should monitor disk usage periodically to see if usage is stabilized or at least if the increase rate drops.

>
> 2018-04-03 9:39 GMT+02:00 Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com <mailto:achill(at)matrix(dot)gatewaynet(dot)com>>:
>
> On 03/04/2018 10:00, Kein Name wrote:
>> > 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?
> Why would you want that? Do you have any control over the application? Any "special" patterns used in the app?
>>
>> 2018-04-03 8:49 GMT+02:00 Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com <mailto: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
>>
>>
>>
>
> --
> Achilleas Mantzios
> IT DEV Lead
> IT DEPT
> Dynacom Tankers Mgmt
>
>

--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt