Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1maOIU-0006Ah-J6 for pgsql-admin@arkaria.postgresql.org; Tue, 12 Oct 2021 20:22:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1maOIT-0002No-JL for pgsql-admin@arkaria.postgresql.org; Tue, 12 Oct 2021 20:22:49 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from <70camero@live.com>) id 1maOIS-0002Ng-J1 for pgsql-admin@lists.postgresql.org; Tue, 12 Oct 2021 20:22:49 +0000 Received: from mail-co1nam11olkn2080a.outbound.protection.outlook.com ([2a01:111:f400:7eab::80a] helo=NAM11-CO1-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from <70camero@live.com>) id 1maOIO-0006fc-VM for pgsql-admin@lists.postgresql.org; Tue, 12 Oct 2021 20:22:47 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=MGWX8QCYDvrSYtR/LQvPiF0TvKTd6/75soqpTU4qB9VTZkl5h8eeuj92DzZIG9J+aRbBvAJCVpUUwP8ttqj2k1Bo8u3BorRenviiqwfcaMa3cw0/i6sRNLzcLFYxv46mjNPdE8cCV9lNKHX8SXHKBjee3QnQuzdrDTMNEtc637TYQcoTp4iat9SMxA0KkXcWb/i8jkPBPdaCTb0mE002vXYIU4w7gI2AyRLg//tbr9Ddl74Ua+8qBoFIcMz4o+o+QgDwBVG/UUaag7Fv2/i5qtZ1eAPRmMyM3/3U5xUY4TcqonrWXfGPSOqCswfnzt82+H+7MVizaxhQLEox3avv9Q== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=CzmJbIShVlKmD6xx2YEey95KABVnrK2ERAipVVafbjA=; b=B2m9Izb5lhxsBNRa00+TJ5hnHRu/LaqONJdQduTdTZ/0lPq7Cl0vXhM4kISCn1MmN0r/uoo1xLvvV1Jl2Q3hb818ZdKrWkAkMrjskw4ApflVfQKySAna12EMkR8bCuhevQKRzhm2WL+f7upb08P5C5HtEvQSu40un4wEIGUFF8o7no32F/ZZ9GcwwMUksVXI93o8H2nBxU89zjU2H7GXaTsEjoaPj7xSQXzWB6KV/GrCst54QcA0rxMl+uT8FNats5kLksZO6Ej7XSJlOEAonzpR7d6OSfBG1rj4zkTgESWmIYhNYNI498ODohUkBUW6/CH2B0t5P2cMlxecI1M16Q== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=live.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=CzmJbIShVlKmD6xx2YEey95KABVnrK2ERAipVVafbjA=; b=sYGgqDgKpG+tVCCrJpaXXV0c8uIir18LhTAVNLQk93RnBKgr4xuGPQwgkm85lZEj3xafNtIKUsHnVUke3P00LlXRe87YGI8lJd4uriBfQq5f+B1Xiso/TynKtdsHsBu79M1kvBeNZopifio/jmJgxWXOMUqQNf+WpoVeZqgMqbpBsRFUMdmxXqBws0kgAAbjo7cRi8G/yoNFY8ytkMqJh1bBy1VYAKU6kI3VxdZ1w3K1Tz7vz6G9IVQo6YdsGQiJxj6zlyQUsZQKhBs8UCIENzVIO6Ar5pKOVHoPmaJKF6qayE7xLMRylT9DZDVdWxyOmRFdZDEUWglcRCV6PxfbmQ== Received: from BYAPR02MB6438.namprd02.prod.outlook.com (2603:10b6:a03:11d::33) by BYAPR02MB4792.namprd02.prod.outlook.com (2603:10b6:a03:4a::20) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4587.18; Tue, 12 Oct 2021 20:22:40 +0000 Received: from BYAPR02MB6438.namprd02.prod.outlook.com ([fe80::6948:8b09:f03c:b114]) by BYAPR02MB6438.namprd02.prod.outlook.com ([fe80::6948:8b09:f03c:b114%5]) with mapi id 15.20.4587.026; Tue, 12 Oct 2021 20:22:40 +0000 From: Satoshi Nakamoto <70camero@live.com> To: Guillaume Lelarge , Dustin Jantz CC: "pgsql-admin@lists.postgresql.org" Subject: Re: Recover Disk Space From Terminated VACUUM FULL ANALYZE Thread-Topic: Recover Disk Space From Terminated VACUUM FULL ANALYZE Thread-Index: Ade/n7DZlwK29Z4jSJ2/zrfC9SwMuQABMX8AAACZum4= Date: Tue, 12 Oct 2021 20:22:40 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-messagesentrepresentingtype: 1 x-tmn: [QXvDbgUrvC5UOM4A9gNbCMJ6Fn/OknTh] x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: e600c349-5f57-4579-b592-08d98dbe0a1e x-ms-traffictypediagnostic: BYAPR02MB4792: x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: LI4quWRcjpUR/W0erjs9sZBR7hqBLJSPjFrdajeLkWVKs2UgP15d4+zeI52jufp6b+ZyV5O9IOnHbwF3uADV7sRY8W1z4lJ+U9XWdv9kk5gJ/kXk0vZMEf7is1BA1+7VZUZSTWdUEAV4ksaHT46PwLXIrVZD0q7SjPK1rc+CMd2Tw3dwenLluPljIzc6iOVNPmUQ/3niMn5YjQDHov5MPFzBoM72SrF3YAL7onLAFKd/9QgsCd8J5QOE+YZQNqHtRibg6++QrD3/UDPMtupqPj3LWVseC/kywpTEWVKuMTaX7xbB+Sgac2/PCTooinxkklFcH7K64CpqMsX8cAXy54vk7l9LpGXu/XcLCvfFHP4B9BOyJpPnAPSuu2K1bdNN4liuoYBEeD7ItVzC3CgHboGy02yx9gAZ3AtTFMB3svm3AU3H55OxhIrx4p3FIm4h6/4rm3+U+DoFQhpAQmBQgDMzJS0x5gFtw57tfCag66EP9/u9Cm9nfxpiuf8iDvYacqqW+g8YYz5oOucRvK1xCg== x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: 3srPV9BSW1LWAZBnkLSNp/jRgac3gflf2p4OgT9Je094sFVtzwVFbio0XtTZTk9c9oWEy/m/X57H9M90RkBvUzEAPGnUUlfcvypviC9K4SIZAwOi4I103VW0FlzqkyDeBEbvoOxC6YMTcDzhZ4L5OA== x-ms-exchange-transport-forked: True Content-Type: multipart/alternative; boundary="_000_BYAPR02MB64384C8DFC0B1AF5EF3685D7B3B69BYAPR02MB6438namp_" MIME-Version: 1.0 X-OriginatorOrg: sct-15-20-3174-20-msonline-outlook-cec7a.templateTenant X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: BYAPR02MB6438.namprd02.prod.outlook.com X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-Network-Message-Id: e600c349-5f57-4579-b592-08d98dbe0a1e X-MS-Exchange-CrossTenant-originalarrivaltime: 12 Oct 2021 20:22:40.2263 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-Transport-CrossTenantHeadersStamped: BYAPR02MB4792 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_BYAPR02MB64384C8DFC0B1AF5EF3685D7B3B69BYAPR02MB6438namp_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I'm not shore Get Outlook for Android ________________________________ From: Guillaume Lelarge Sent: Tuesday, October 12, 2021 1:05:12 PM To: Dustin Jantz Cc: pgsql-admin@lists.postgresql.org Subject: Re: Recover Disk Space From Terminated VACUUM FULL ANALYZE Hi, Le mar. 12 oct. 2021 =E0 21:39, Dustin Jantz > a =E9crit : 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 conne= ction to the database. Normally the database disk usage is approximately 40= 0 GB but after the terminated VACUUM FULL ANALYZE the disk usage is over 60= 0 GB. Summing the disk used by the tables in the database with size is stil= l 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. --_000_BYAPR02MB64384C8DFC0B1AF5EF3685D7B3B69BYAPR02MB6438namp_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
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.postgresq= l.org>
Subject: Re: Recover Disk Space From Terminated VACUUM FULL ANALYZE<= /font>
 
Hi,

Le mar. 12 oct. 2021 =E0 = 21:39, Dustin Jantz <djantz@fro= ntporch.com> a =E9crit :

VACUUM FULL ANALYZE was ran on the 4 largest table= s on the database from a remote server. Before the commands could be comple= ted 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. Su= mming 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.
--_000_BYAPR02MB64384C8DFC0B1AF5EF3685D7B3B69BYAPR02MB6438namp_--