Postgres Pro
Downloads
Home   >   mailing lists

Re: Autovacuum Problem - Mailing list pgsql-general

From Achilleas Mantzios
Subject Re: Autovacuum Problem
Date
Msg-id 01f04a0e-5013-605d-418c-acba834c3609@matrix.gatewaynet.com
Whole thread Raw
In response to Re: Autovacuum Problem  (Kein Name <muelladdi@gmail.com>)
List pgsql-general
Tree view
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@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 <achill@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


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

pgsql-general by date:

Previous
From: Kein Name
Date:
Subject: Re: Autovacuum Problem
Next
From: Ranjith Ramachandra
Date:
Subject: Seems like there is an issue with reltuples showing twice the numberof rows