Re: Free disk space decreasing after running Vaccum Full

Поиск
Список
Период
Сортировка
От Wells Oliver
Тема Re: Free disk space decreasing after running Vaccum Full
Дата
Msg-id CAOC+FBVAiULBGsNbsfyWGEXx5B8fvgBrkUMKb+s=86uBfQVG3g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Free disk space decreasing after running Vaccum Full  (Ron Johnson <ronljohnsonjr@gmail.com>)
Ответы Re: Free disk space decreasing after running Vaccum Full  (Sabyasachi Mukherjee <mukherjee.sabyasachi@outlook.com>)
Список pgsql-admin
Дерево обсуждения
VACUUM FULL is designed to release disk space back to the OS by rebuilding the table. Unless I misunderstand, this is the effect and desired intent.

On Fri, Jun 28, 2024 at 7:53 AM Ron Johnson <ronljohnsonjr@gmail.com> wrote:
On Fri, Jun 28, 2024 at 9:58 AM Sabyasachi Mukherjee <mukherjee.sabyasachi@outlook.com> wrote:
Hello All,
The disk space is decreasing drastically after running "Vaccum Full".
I was expecting increase of free disk space after running those commands. I am on Postgresql 16.1
Any guidance/advise?
 
3. VACUUM FULL should only be run after deleting or updating a significant portion of a table.


--

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

Предыдущее
От: Ron Johnson
Дата:
Сообщение: Re: Free disk space decreasing after running Vaccum Full
Следующее
От: Sabyasachi Mukherjee
Дата:
Сообщение: Re: Free disk space decreasing after running Vaccum Full