Обсуждение: Vacuum Full is not returning space to OS

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.