Postgres Pro
Downloads
Home   >   mailing lists

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

From Sushant Postgres
Subject Vacuum Full is not returning space to OS
Date
Msg-id CAHzMYRJbQf63iV7N2u3odte_E2KXN33=2BbL4RVsY9Zrm9KC5g@mail.gmail.com
Whole thread Raw
Responses Re: Vacuum Full is not returning space to OS
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Torge
Date:
Subject: Re: Feature request for count_estimate(samplesize) aggregate or SAMPLE keyword
Next
From: Ron
Date:
Subject: Re: Vacuum Full is not returning space to OS