From: Satoshi Nakamoto <70camero@live.com>
To: Guillaume Lelarge <guillaume@lelarge.info>
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
Date: Tue, 12 Oct 2021 20:22:40 +0000
Message-ID: <BYAPR02MB64384C8DFC0B1AF5EF3685D7B3B69@BYAPR02MB6438.namprd02.prod.outlook.com> (raw)
In-Reply-To: <CAECtzeU8NYOeXESxf7E_Wa8w1rpvO-Yq_Xksjoz270mSA-86Aw@mail.gmail.com>
References: <SJ0PR17MB5724B25C6790E1627D3E5DD2BDB69@SJ0PR17MB5724.namprd17.prod.outlook.com>
<CAECtzeU8NYOeXESxf7E_Wa8w1rpvO-Yq_Xksjoz270mSA-86Aw@mail.gmail.com>
I'm not shore
Get Outlook for Android<https://aka.ms/AAb9ysg;
________________________________
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<mailto: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<https://na01.safelinks.protection.outlook.com/?url=https%...;.
--
Guillaume.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: 70camero@live.com, guillaume@lelarge.info, djantz@frontporch.com, pgsql-admin@lists.postgresql.org
Subject: Re: Recover Disk Space From Terminated VACUUM FULL ANALYZE
In-Reply-To: <BYAPR02MB64384C8DFC0B1AF5EF3685D7B3B69@BYAPR02MB6438.namprd02.prod.outlook.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox