Re: Recover Disk Space From Terminated VACUUM FULL ANALYZE

Поиск
Список
Период
Сортировка
От Satoshi Nakamoto
Тема Re: Recover Disk Space From Terminated VACUUM FULL ANALYZE
Дата
Msg-id BYAPR02MB64384C8DFC0B1AF5EF3685D7B3B69@BYAPR02MB6438.namprd02.prod.outlook.com
обсуждение исходный текст
Ответ на Re: Recover Disk Space From Terminated VACUUM FULL ANALYZE  (Guillaume Lelarge <guillaume@lelarge.info>)
Список pgsql-admin
Дерево обсуждения
I'm not shore

From: Guillaume Lelarge <guillaume@lelarge.info>
Sent: Tuesday, October 12, 2021 1:05:12 PM
To: Dustin Jantz <djantz@frontporch.com>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: Recover Disk Space From Terminated VACUUM FULL ANALYZE
 
Hi,

Le mar. 12 oct. 2021 à 21:39, Dustin Jantz <djantz@frontporch.com> a écrit :

VACUUM FULL ANALYZE was ran on the 4 largest tables on the database from a remote server. Before the commands could be completed the server lost connection to the database. Normally the database disk usage is approximately 400 GB but after the terminated VACUUM FULL ANALYZE the disk usage is over 600 GB. Summing the disk used by the tables in the database with size is still around 400 GB but the disk used by the DB as a whole is over 600 GB. What is the best way to recover the disk space?

 

Postgres version 12.6

 


You probably have orphaned files. You can look for them with https://github.com/bdrouvot/pg_orphaned.


--
Guillaume.

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

Предыдущее
От: Guillaume Lelarge
Дата:
Сообщение: Re: Recover Disk Space From Terminated VACUUM FULL ANALYZE
Следующее
От: Henry Francisco Garcia Cortez
Дата:
Сообщение: bgwriter_flush_after