Recover Disk Space From Terminated VACUUM FULL ANALYZE

From: Dustin Jantz <djantz(at)frontporch(dot)com>
To: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Recover Disk Space From Terminated VACUUM FULL ANALYZE
Date: 2021-10-12 19:38:30
Message-ID: SJ0PR17MB5724B25C6790E1627D3E5DD2BDB69@SJ0PR17MB5724.namprd17.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Kind regards,

Dustin Jantz

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Guillaume Lelarge 2021-10-12 20:05:12 Re: Recover Disk Space From Terminated VACUUM FULL ANALYZE
Previous Message David G. Johnston 2021-10-11 21:40:38 Re: all_roles_backup