Re: Autovacuum Problem - Mailing list pgsql-general

From Achilleas Mantzios
Subject Re: Autovacuum Problem
Date
Msg-id b473807b-cfbf-b24b-459a-48a1c7f46d58@matrix.gatewaynet.com
Whole thread Raw
In response to Autovacuum Problem  (Kein Name <muelladdi@gmail.com>)
Responses Re: Autovacuum Problem
List pgsql-general
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
(unlessit 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
inextra 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



pgsql-general by date:

Previous
From: Kein Name
Date:
Subject: Autovacuum Problem
Next
From: Kein Name
Date:
Subject: Re: Autovacuum Problem