After vacuum db size is increasing

Поиск
Список
Период
Сортировка
От srijith s
Тема After vacuum db size is increasing
Дата
Msg-id 7C3DCEF8-BBCF-4E92-B330-1D83121E638B@gmail.com
обсуждение исходный текст
Ответы Re: After vacuum db size is increasing
Re: After vacuum db size is increasing
Список pgsql-admin
Hi Postgres Admins

Any help is much appreciated . When i am running vacuum full, the database size is getting increased a lot, my database
wasaround 100gb and when i did vacuum full on the large table ( which consume 95% of data in the database) , database
sizebecome 200+ gb , then i did a full vacuum on the database itself and that made the db grow to 300+gb 🙄 and filled
mydata drive . 
The large table size is showing only 80gb.

 I am running Postgres on windows. Anybody know why its behaving like this

Thanks in advance
Regards
Sri





Sent from my iPhone


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

Предыдущее
От: Scott Ribe
Дата:
Сообщение: Re: max_slot_wal_keep_size
Следующее
От: "Peter M. Groen"
Дата:
Сообщение: Re: After vacuum db size is increasing