Vacuum Full is not returning space to OS

Поиск
Список
Период
Сортировка
От Sushant Postgres
Тема Vacuum Full is not returning space to OS
Дата
Msg-id CAHzMYRJbQf63iV7N2u3odte_E2KXN33=2BbL4RVsY9Zrm9KC5g@mail.gmail.com
обсуждение исходный текст
Ответы Re: Vacuum Full is not returning space to OS
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Torge
Дата:
Сообщение: Re: Feature request for count_estimate(samplesize) aggregate or SAMPLE keyword
Следующее
От: Ron
Дата:
Сообщение: Re: Vacuum Full is not returning space to OS