> 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. 2018-04-03 9:39 GMT+02:00 Achilleas Mantzios <ach...@matrix.gatewaynet.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 <ach...@matrix.gatewaynet.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 > >
