Re: Autovacuum Problem

2018-04-03 Thread Kein Name
o 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 : > On 03/04/2018 10:00, Kein Name wrote: > > > VACUUM <> VACUUM FULL > > Normally running VACUUM via autova

Re: Autovacuum Problem

2018-04-03 Thread Kein Name
8.2) run VACUUM (or VACUUM FULL) by hand, except in extra ordinary cases where e.g. need for free space is urgent. H 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 : &g

Autovacuum Problem

2018-04-02 Thread Kein Name
Hello List, I inherited a machine with an Postgres Database, which I am fighting with right now. It seems as if the Database is growing bigger and bigger over time. Once in a while I have to run a VACUUM FULL statement on a few tables, which then releases a lot of space to the OS. By reading the