Re: Vacuum Full is not returning space to OS

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Vacuum Full is not returning space to OS
Date: 2022-09-01 11:57:38
Message-ID: 96329d94-12bc-a168-6636-3f50859700d9@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Gustafsson 2022-09-01 12:01:17 Re: Vacuum Full is not returning space to OS
Previous Message Sushant Postgres 2022-09-01 09:47:50 Vacuum Full is not returning space to OS