Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1syRm7-00GrwO-9r for pgsql-general@arkaria.postgresql.org; Wed, 09 Oct 2024 08:10:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1syRm6-00FTlN-2d for pgsql-general@arkaria.postgresql.org; Wed, 09 Oct 2024 08:10:26 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sy82e-007K9W-Uj for pgsql-general@lists.postgresql.org; Tue, 08 Oct 2024 11:06:13 +0000 Received: from mail-am0eur02olkn2010.outbound.protection.outlook.com ([40.92.49.10] helo=EUR02-AM0-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sy82a-0036qK-LU for pgsql-general@lists.postgresql.org; Tue, 08 Oct 2024 11:06:11 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=pLzkUVbTy1xcpXJVLCVDQJbglOSkxrESP16vPwjV/8Gmb4he95v0epGU98ZssESFtbwDFu+nz7MoDjhtKKcJUboPfNz3SiSivWHjo/e8xSPIpm5HwMnVxpKVFg3cS0YVGzjQvlJqU9JqzuiIPek1Xj3LyeIHm/zj4oH6TCAW+Oj8ft753L/KLcWLhMt+4XZqGiKMM1beleJYRhECsjaFVj8NcYXKLdBhx44Bxey/Ffd87P+ZWfUeB/JjAGoARNkB42B9UWntGov200V4v5JTLYLGtVHu7Pda29mAmtuT4NlL45/F8N0V/8MtrSAQKEQ2W4ueWdmt2wiiye+nEnnm/w== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; 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=WbOrh3qhHP1OoGBLJgnPwD1sM3/sHBzxq+28t5b9NGM=; b=PY0qswZzkqRNYjmHq17VU3jrMU8JovJf1uXRqQHkb5AYRqNwjEkMze8nEGk5OMWvQedJ9RrHNh7Gr5h1hRL5Z0d57MIXiS10eApkYblOiiJd7s0YNtiHRuaNW+W4lXL1oWT1r2xZd3uF2uiRGAud1B449NWsq2BzguZSSYIwvUiNlL0+YePLppjy0XWF98+fgW0iB/SCeS5FuMNcQ0JTlYmJ7octsvHX14etvgaCSnsF8JQuubYQ//sp22kLULcVG8vrS9fWhkqVXsyDoc63bf1QlMpBSHZXeZBumxG03Q9mNXn0K9esoa2sL84AtRrQAV76T9S6l3BszO2ZVrOsVw== 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=hotmail.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=WbOrh3qhHP1OoGBLJgnPwD1sM3/sHBzxq+28t5b9NGM=; b=r5PD67qXlX8kt9Cpd8wmdz9E5+zm8fQhohbGEV2AGaVNgVD61ZyWdKHFjOmqd27Smtskw7oCMsOHvGuWfmQ6qjlFwwE+yJlM62PrO2XjmNzlZNGQZ45HDZ7DT5CK00Czw4sIxk+Tee97YXMwU758xxRFPW1fnjEsZmLOqQ0IwVJDJ4CuutgT/f0ggSSzhIl/GpHqiF41SDYybt5/QhhYcoNR0epjAml3YoVZxMg3/Zeck3vKYIFmLiZlztkDjrEbHd2mQ8xdOX1QS9CQi6tvmiyJzNYZjLnyxnnf3J3Ke3p6eaSJw89QOMCFXgwvClS/0j6Z1fhvKcKrMxCllJpabQ== Received: from GV1PR08MB8305.eurprd08.prod.outlook.com (2603:10a6:150:a2::16) by DU0PR08MB9876.eurprd08.prod.outlook.com (2603:10a6:10:424::11) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.8026.22; Tue, 8 Oct 2024 11:06:04 +0000 Received: from GV1PR08MB8305.eurprd08.prod.outlook.com ([fe80::41ad:bb80:2674:d25c]) by GV1PR08MB8305.eurprd08.prod.outlook.com ([fe80::41ad:bb80:2674:d25c%7]) with mapi id 15.20.8026.020; Tue, 8 Oct 2024 11:06:04 +0000 From: Mikael Petterson To: "pgsql-general@lists.postgresql.org" Subject: Disk is filling up with large files. How can I clean? Thread-Topic: Disk is filling up with large files. How can I clean? Thread-Index: AQHbGXHxfDERI4qVK02p8ncOZ6w64g== Date: Tue, 8 Oct 2024 11:06:04 +0000 Message-ID: Accept-Language: sv-SE, en-US Content-Language: sv-SE X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: x-ms-exchange-messagesentrepresentingtype: 1 x-ms-publictraffictype: Email x-ms-traffictypediagnostic: GV1PR08MB8305:EE_|DU0PR08MB9876:EE_ x-ms-office365-filtering-correlation-id: b7fcaff3-e077-4c20-511b-08dce789338f x-ms-exchange-slblob-mailprops: znQPCv1HvwXEkPgdKd+m+ET1AUZMABgkG7Uc4CvmfyxjCnrXaD6ZZA0yMVuRSLChsPfLh5bktztFuL3nyscnC2aeKULRfyar4yaIF1/phBDLO3Itq7wKbpCfa5ota+yUsTSy3Ddh8Zsx6GmDba0xAOVD4keyk9LokTR+d5dDMQdIJBJiG/LPpmhpfGgiv+0uGhla7rQ9RskXEQfiKuZa+A8Fuaofw72Q6CH6Z6XLNx4mwWcrQWF6KD0CD0lOeoxzzklQ3Q9q98CyhlAaoHeAKYt7dJjAMZPJnRp59TZcAaqD6Mjfe4QGW7cVCbAuIIyYuZLjmIWQUYZjXyzYEmiA2ByDawT/0YHI8IyT7jTQSlDpLZigTkENRnGLbtx8OGgshs//6r8zEHDcR/0QUuJQ9Hxs44bvi7l24sCCU2mKWlES/j96nulHwEg+uQ4A4cCeL+WVs89Q5hg+Ob87kbAYQZ7DZGtFr7ylacoDmJGHDeI8CI00MfWffXVV9b0biskQzh3o5cympiI1wUHHm2FHjE/ZlBgVQG4/mn/jANAJ9v7fFECGyhIN97X7YndVY2GRlDb0wIaa3eHQ2O7do/biZFWhuzgLrnTKFiaA3Uyb/3r188RoWa1fpTSc+pIuaTk2zzS6eir3JobBkQ7tV+3Do9eR2FvkH0iUw9WVDfWsqZJowWd6FIM8cVrEpdwv0XuoUDxt1sSd6R6EYMhI0s3Cgt4ecK2vXh9JY9w5gPwemtt0tsjwyzmg1NwX9Gr/dUdp4nCw8+7LNF0= x-microsoft-antispam: BCL:0;ARA:14566002|15080799006|7092599003|8062599003|15030799003|19110799003|8060799006|461199028|440099028|3412199025|102099032; x-microsoft-antispam-message-info: aEkIcCi9yGaQD3JlfAzaAn/MpGCPRIGTQ6dplRTHvWmaDAqGrQbHjgZ2F6anRum2As9uyoYJpZbYrlNmOLGqmsmRntKnfdLtOtx1H9s8VzfhO5VXvsnaoQdWKcMpGyfmV/gX3SEv30L1ShBuRQXJTo82GKe5Gc7EfaUHquJdaRBxAYyROJ4ECeQj8HFjnVEw1lxqMgaMVgyj7W+wcrFAi9LciGy50EhxRSnw/Ols67jFgowynxOlbeYG8Ku8+MuTAtqtkVgyd56rdDv0xzueC1RSgR/5MHPz1EfHuxIb1Z+OaUklL2QN0wOSbQSVAaeUnhe1m7wetiscr3ynyDfPlEkKBTKiBAzQgB6GaDr1Riyrwu8nW+g5bxIT33lQ4ha9UzXJxBjlt1bOSWR9d+d501ZHUW1rmo6E1++/OzdPeKIvIrffnQntxyWi3h0a+RTFooVqg62XVOlInkocF8o45TRK66mgocX2bxuZRjTzOB0T+ib9LvkmJ8DQism7Bb2DYF9yNm6lV4MrrHddY7a7UqpGAzk2WLAEmqSRXHU2MxLARfA87vO1BN8GLO6s3V5w6qtc75FXh+L5ibO3hwmV7oexaoFpaQZAy+YSpZ/BWWpYIMUwDqrTDUR/LGLx8Ma+2iK86sioFu1bG857vo8JElpPrbKZJAeQdezkBfxV2WNkRGJHCO8BuFtsShEk1MFfHtxnx3nFPxBD1HlfISULm6uQXLiDwaELHun5rx4wOT4RMfMBLGIjrahS7+wOw0wJ1GMntqJyYJSNWU4kFEgBKg== x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-8859-1?Q?5awuGOfhrCpRkeXgNMOt4L5r4+wWqwnLpd/7JDpNDVpQLKDRqFv2OelJ2A?= =?iso-8859-1?Q?CWyRw5u9AIBRMxsYZg7T8OvepkPyYr3WRgCCtPBgfpsNK/4u4hlWd1a7v2?= =?iso-8859-1?Q?CnwCkplThZGJCdE+WNr1ev7fFenYgRYQbo2843LEAYv0YX0Ew51T+rV1J3?= =?iso-8859-1?Q?8wAq0WZ7qwuqM9JizsyH0+oMIaqLZy3ozBdVB+fUDy9RZgXeyRqvY64Ftl?= =?iso-8859-1?Q?ootfvgRZ6zlbrn6hPNnvuwPyqI1gldKUNcPyb5cObCBdZ/eAR4h9hyz+QA?= =?iso-8859-1?Q?BUhMTj3+ZtGDCTri7OJkFNI70CAVQJR8QbwNG9BkHeIDVkTR+zPC+7+/Ni?= =?iso-8859-1?Q?Mkh41lGQXSxXNHV5inoONCMqX3BwWiTwfDu+l8C0Ww9MfU6WvzxEWVerT1?= =?iso-8859-1?Q?gx8XsXDoJ1BaFgVUYR9zl0h6v75Pi19MXCiPLSpzgUjk0GRztSjVc2RjA6?= =?iso-8859-1?Q?Wvl+ZeXEbW/H1Wzk34Bm+b8EQH/4e2XDGrQxO0fRwEFrFLvDrZrZOZ71H1?= =?iso-8859-1?Q?Z8zbAeeeCtIHg+CS9Bfvpd6hZW0WubIeeXMlweraDTQgRNVxOnClBKz/et?= =?iso-8859-1?Q?oKnupWHc1LsAVqI6dIv4g7+TZS4sotHBseIWlMtN51dQ+AG1EMwhjNo2mF?= =?iso-8859-1?Q?DmGJ5h03QMUeE5moFLwqHAX73v2z7ciKkk2KQnlnyXlzCub/MxajFSwggf?= =?iso-8859-1?Q?jJu1Hn4yprQyfyhI8+EQRCnlnbjvM1/rInFq4eCMo9VQmjrvP127OWz6H2?= =?iso-8859-1?Q?hJFIpOHt5dTAW+aFjduRp0CU40WXsV+DhiCFOamUbIecl4pvVtLxGch+Li?= =?iso-8859-1?Q?wMVUgl3WCTxsZgHlN1oBRwkdgkFcpAlc96bZlT8d2B/azQoxhkaWGpyzZ4?= =?iso-8859-1?Q?OzArjW3hCQBFAqxa7o8IDMwM37nuespkH0CbnZ/ZT5ds0bB97RqXWMkFxs?= =?iso-8859-1?Q?QfPIkDbyz2N30ALzeZy/hP1iF23SCle46lc7FSc8ubj/2vag0j/KQj8jYP?= =?iso-8859-1?Q?ucxD9aIgkW+ISB4EvKjzfkorpN82XwONm74OIGe+XOJjy9DgnYAxAorqDI?= =?iso-8859-1?Q?ZalshAUu/PxqXTfpp/4W26K4xJcjVjy14vyPBaIBqFVJuGHR9wN6ODWXLl?= =?iso-8859-1?Q?5ACJelFok0Xa3ZW1OGkq2VZUI176TVYnmoWgPgtU2WBswzrjHClhbpXwKi?= =?iso-8859-1?Q?qhNn25rvsrvYX6bJd8lZQv8hIe8LbepJYGxGMkdHq4orbT5lTwtlcQOOMv?= =?iso-8859-1?Q?b5iMgJhvDK/CqGMcycPU2D9DP9Beo6e6ra6GoVmTo=3D?= Content-Type: multipart/alternative; boundary="_000_GV1PR08MB83052D322AD3FB9A65125339B87E2GV1PR08MB8305eurp_" MIME-Version: 1.0 X-OriginatorOrg: sct-15-20-7719-20-msonline-outlook-de33f.templateTenant X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: GV1PR08MB8305.eurprd08.prod.outlook.com X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-Network-Message-Id: b7fcaff3-e077-4c20-511b-08dce789338f X-MS-Exchange-CrossTenant-originalarrivaltime: 08 Oct 2024 11:06:04.1240 (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: DU0PR08MB9876 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_GV1PR08MB83052D322AD3FB9A65125339B87E2GV1PR08MB8305eurp_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I find our disk is filling up. sudo find /var/lib -type f -size +100M -exec ls -lh {} \; | awk '{ print $9= ": " $5 }' /var/lib/rpm/Packages: 278M /var/lib/pgsql/12/data/base/16384/16583: 392M /var/lib/pgsql/12/data/base/16384/16586: 1.0G /var/lib/pgsql/12/data/base/16384/16588: 173M /var/lib/pgsql/12/data/base/16384/16633: 106M /var/lib/pgsql/12/data/base/16384/16644: 179M /var/lib/pgsql/12/data/base/16384/16659: 1.0G /var/lib/pgsql/12/data/base/16384/16662: 438M /var/lib/pgsql/12/data/base/16384/16665: 1.0G /var/lib/pgsql/12/data/base/16384/16667: 1.0G /var/lib/pgsql/12/data/base/16384/16668: 1.0G /var/lib/pgsql/12/data/base/16384/16780: 466M /var/lib/pgsql/12/data/base/16384/16786: 182M /var/lib/pgsql/12/data/base/16384/16788: 163M /var/lib/pgsql/12/data/base/16384/16789: 315M /var/lib/pgsql/12/data/base/16384/16790: 126M /var/lib/pgsql/12/data/base/16384/16665.2: 403M /var/lib/pgsql/12/data/base/16384/16586.7: 1.0G /var/lib/pgsql/12/data/base/16384/16586.6: 1.0G /var/lib/pgsql/12/data/base/16384/16586.9: 1.0G /var/lib/pgsql/12/data/base/16384/16586.8: 1.0G /var/lib/pgsql/12/data/base/16384/16659.6: 1.0G /var/lib/pgsql/12/data/base/16384/16659.4: 1.0G /var/lib/pgsql/12/data/base/16384/16659.5: 1.0G /var/lib/pgsql/12/data/base/16384/16668.3: 586M /var/lib/pgsql/12/data/base/16384/16586.10: 458M /var/lib/pgsql/12/data/base/16384/16659.1: 1.0G /var/lib/pgsql/12/data/base/16384/16586.2: 1.0G /var/lib/pgsql/12/data/base/16384/16659.2: 1.0G /var/lib/pgsql/12/data/base/16384/16668.1: 1.0G /var/lib/pgsql/12/data/base/16384/16586.3: 1.0G /var/lib/pgsql/12/data/base/16384/16659.3: 1.0G /var/lib/pgsql/12/data/base/16384/16586.4: 1.0G /var/lib/pgsql/12/data/base/16384/16665.1: 1.0G /var/lib/pgsql/12/data/base/16384/16586.5: 1.0G /var/lib/pgsql/12/data/base/16384/16586.1: 1.0G /var/lib/pgsql/12/data/base/16384/16668.2: 1.0G /var/lib/pgsql/12/data/base/16384/16667.1: 741M /var/lib/pgsql/12/data/base/16384/4652676: 502M /var/lib/pgsql/12/data/base/16384/4652688: 155M How can I clean up? What can I do to clean up. We are using pgsql 12. Br, //Mikael --_000_GV1PR08MB83052D322AD3FB9A65125339B87E2GV1PR08MB8305eurp_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi,
 
I find our disk is filling up.
 
sudo find /var/lib -type f -size +100M -exec ls -lh {} \; | awk '{ print $9= ": " $5 }'
/var/lib/rpm/Packages: 278M
/var/lib/pgsql/12/data/base/16384/16583: 392M
/var/lib/pgsql/12/data/base/16384/16586: 1.0G
/var/lib/pgsql/12/data/base/16384/16588: 173M
/var/lib/pgsql/12/data/base/16384/16633: 106M
/var/lib/pgsql/12/data/base/16384/16644: 179M
/var/lib/pgsql/12/data/base/16384/16659: 1.0G
/var/lib/pgsql/12/data/base/16384/16662: 438M
/var/lib/pgsql/12/data/base/16384/16665: 1.0G
/var/lib/pgsql/12/data/base/16384/16667: 1.0G
/var/lib/pgsql/12/data/base/16384/16668: 1.0G
/var/lib/pgsql/12/data/base/16384/16780: 466M
/var/lib/pgsql/12/data/base/16384/16786: 182M
/var/lib/pgsql/12/data/base/16384/16788: 163M
/var/lib/pgsql/12/data/base/16384/16789: 315M
/var/lib/pgsql/12/data/base/16384/16790: 126M
/var/lib/pgsql/12/data/base/16384/16665.2: 403M
/var/lib/pgsql/12/data/base/16384/16586.7: 1.0G
/var/lib/pgsql/12/data/base/16384/16586.6: 1.0G
/var/lib/pgsql/12/data/base/16384/16586.9: 1.0G
/var/lib/pgsql/12/data/base/16384/16586.8: 1.0G
/var/lib/pgsql/12/data/base/16384/16659.6: 1.0G
/var/lib/pgsql/12/data/base/16384/16659.4: 1.0G
/var/lib/pgsql/12/data/base/16384/16659.5: 1.0G
/var/lib/pgsql/12/data/base/16384/16668.3: 586M
/var/lib/pgsql/12/data/base/16384/16586.10: 458M
/var/lib/pgsql/12/data/base/16384/16659.1: 1.0G
/var/lib/pgsql/12/data/base/16384/16586.2: 1.0G
/var/lib/pgsql/12/data/base/16384/16659.2: 1.0G
/var/lib/pgsql/12/data/base/16384/16668.1: 1.0G
/var/lib/pgsql/12/data/base/16384/16586.3: 1.0G
/var/lib/pgsql/12/data/base/16384/16659.3: 1.0G
/var/lib/pgsql/12/data/base/16384/16586.4: 1.0G
/var/lib/pgsql/12/data/base/16384/16665.1: 1.0G
/var/lib/pgsql/12/data/base/16384/16586.5: 1.0G
/var/lib/pgsql/12/data/base/16384/16586.1: 1.0G
/var/lib/pgsql/12/data/base/16384/16668.2: 1.0G
/var/lib/pgsql/12/data/base/16384/16667.1: 741M
/var/lib/pgsql/12/data/base/16384/4652676: 502M
/var/lib/pgsql/12/data/base/16384/4652688: 155M
 
How can I clean up?
 
What can I do to clean up. We are using pgsql 12.
 
Br,
 
//Mikael


 

 

--_000_GV1PR08MB83052D322AD3FB9A65125339B87E2GV1PR08MB8305eurp_--