Re: Vacuum Full is not returning space to OS - Mailing list pgsql-general

From Ron
Subject Re: Vacuum Full is not returning space to OS
Date
Msg-id 96329d94-12bc-a168-6636-3f50859700d9@gmail.com
Whole thread Raw
In response to Vacuum Full is not returning space to OS  (Sushant Postgres <sushant.postgres@gmail.com>)
Responses Re: Vacuum Full is not returning space to OS
List pgsql-general
On 9/1/22 04:47, Sushant Postgres wrote:
> Hi All,
>
> I am running Azure PostgreSQL database version 11 with replication enabled.

Azure Postgresql is sufficiently different from Vanilla that the standard 
answer is "ask AWS".

> But the autovacuum is not happening. Even Vacuum full is also not 
> reclaiming the space and returning back to OS.
>
> when, I disable to replication then only Full Vacuum is working as 
> expected but vacuum isn't working as expected.
>
> Database size is just 2 GB but bloat is around 14 GB in the database.

What metric are you using to determine that 12GB is not freed up?

-- 
Angular momentum makes the world go 'round.



pgsql-general by date:

Previous
From: Sushant Postgres
Date:
Subject: Vacuum Full is not returning space to OS
Next
From: Daniel Gustafsson
Date:
Subject: Re: Vacuum Full is not returning space to OS