| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | Dustin Jantz <djantz(at)frontporch(dot)com> |
| Cc: | "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Recover Disk Space From Terminated VACUUM FULL ANALYZE |
| Date: | 2021-10-12 20:05:12 |
| Message-ID: | CAECtzeU8NYOeXESxf7E_Wa8w1rpvO-Yq_Xksjoz270mSA-86Aw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi,
Le mar. 12 oct. 2021 à 21:39, Dustin Jantz <djantz(at)frontporch(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Satoshi Nakamoto | 2021-10-12 20:22:40 | Re: Recover Disk Space From Terminated VACUUM FULL ANALYZE |
| Previous Message | Dustin Jantz | 2021-10-12 19:38:30 | Recover Disk Space From Terminated VACUUM FULL ANALYZE |