Vacuum Full is not returning space to OS

From: Sushant Postgres <sushant(dot)postgres(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Vacuum Full is not returning space to OS
Date: 2022-09-01 09:47:50
Message-ID: CAHzMYRJbQf63iV7N2u3odte_E2KXN33=2BbL4RVsY9Zrm9KC5g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

I am running Azure PostgreSQL database version 11 with replication enabled.
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.

Currently all the configuration are default as per Azure PostgreSQL.

Please suggest if anything or any parameter needs to be changed.

Thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2022-09-01 11:57:38 Re: Vacuum Full is not returning space to OS
Previous Message Torge 2022-09-01 01:49:40 Re: Feature request for count_estimate(samplesize) aggregate or SAMPLE keyword