Vacuum Full is not returning space to OS
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
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.
On 1 Sep 2022, at 13:57, Ron <ronljohnsonjr@gmail.com> wrote:
On 9/1/22 04:47, Sushant Postgres wrote:
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".
It will most likely be more helpful to ask Microsoft Azure in this case.
--
Daniel Gustafsson https://vmware.com/
On 9/1/22 07:01, Daniel Gustafsson wrote:
On 1 Sep 2022, at 13:57, Ron <ronljohnsonjr@gmail.com> wrote:
On 9/1/22 04:47, Sushant Postgres wrote: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".
It will most likely be more helpful to ask Microsoft Azure in this case.
Azure... Aurora... close enough!! :D
--
Angular momentum makes the world go 'round.