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 1syZ8Q-000pdG-BV for pgsql-general@arkaria.postgresql.org; Wed, 09 Oct 2024 16:01:59 +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 1syZ8P-002qGW-I8 for pgsql-general@arkaria.postgresql.org; Wed, 09 Oct 2024 16:01:57 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1syZ8P-002qGO-7O for pgsql-general@lists.postgresql.org; Wed, 09 Oct 2024 16:01:57 +0000 Received: from mail-lf1-x12b.google.com ([2a00:1450:4864:20::12b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1syZ8M-000BV1-DN for pgsql-general@lists.postgresql.org; Wed, 09 Oct 2024 16:01:56 +0000 Received: by mail-lf1-x12b.google.com with SMTP id 2adb3069b0e04-5398e33155fso8827585e87.3 for ; Wed, 09 Oct 2024 09:01:55 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1728489714; x=1729094514; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=qZ8LIJCDrjmzkhb6bKv3m9sn8qrgbxqhy4B5o4SB0/Q=; b=JUqKPw4ljJI+GyKozdDL6xlC3J1TIafx517WjfOZ9VeKMacTfUBnCVjFpDUHWiILqI Ew86apLsRWW8HYNYfJndXux2sBVZcLmSnKBgPMvuzuOWVIRL8sjDdzR2fyL/5pnBSjEL wFYsyvpCK/cS6d76QMGsDwSH3rRiEHchn2v00dl9B0S3cpxVxKq4WjKVyHokFdgdt12o CuSgt9Qk1hxQKlthzQSyMd5uGQftnuNKO328nA9UcHBEq9h8NqjJTfBE+pBtvHWRc7nc SCYWHpkX7t+l8dHrQRjpQbct77jr91ESRskamTS5actrN5sKxcPKE7e17O5As9IKgdVM lGnw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1728489714; x=1729094514; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=qZ8LIJCDrjmzkhb6bKv3m9sn8qrgbxqhy4B5o4SB0/Q=; b=RdTYITSxivm3A5Zhkte2zMD5axgfKXBeFpdhkDT7gsv4JH9xbdEwYp2XbR+CeP3GH8 w0zgvxAvUgDICNHa+SMxxuDysze+PCGvw9jknhPj8KouyvXTEE3F1Rlx8yGkqVqJ9hGw nW+hKcY4KlOv+8WhHor/iYC2qQ8ue5GXkDeckv4mv5wvmSZuntPBV0ElhgoS5XBQTOVG GBxRzB3gl5rySVIitfR995Ix/GkhmYMsLUKh1pWYyGO8ft5fbrQiVrOJB7n/poiYU0TC XqdhD4jZ+pse5SihLwpIb3hvk0SJMP3iA0e0WybrysFoToqO8BXl+xknwVI5plzm6UfK F2nQ== X-Gm-Message-State: AOJu0YwNc7iopGFywxwGlgQJ3vNeKNVlR7ig19WM21x1eeOY3h7qM/pX lW96icymamnlEAZVEq0y4F9jVONAXt5Wpjdd7QmRJ8FeLJi9g6WuFHv+OwFmmppGmlB70eS5aC0 CpjW78GfnGnrR+ksOueBzZsvoWXE= X-Google-Smtp-Source: AGHT+IEATXp/0dV5zE/inN8QN4cBi8pNRmadOTdwfehERn/O5KUTP70ik6GHBD0Oe/ULDLgFUiyplFJfoVPb07AcHjw= X-Received: by 2002:a05:6512:6ca:b0:539:94c4:d9cb with SMTP id 2adb3069b0e04-539c48e2719mr2192262e87.31.1728489714136; Wed, 09 Oct 2024 09:01:54 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Greg Sabino Mullane Date: Wed, 9 Oct 2024 12:01:17 -0400 Message-ID: Subject: Re: Disk is filling up with large files. How can I clean? To: Mikael Petterson Cc: "pgsql-general@lists.postgresql.org" Content-Type: multipart/alternative; boundary="00000000000068c0d406240d5f5c" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000068c0d406240d5f5c Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wed, Oct 9, 2024 at 4:10=E2=80=AFAM Mikael Petterson wrote: > Hi, > > I find our disk is filling up. > > sudo find /var/lib -type f -size +100M -exec ls -lh {} \; | awk '{ print > $9 ": " $5 }' > ... Those files only add up to about 30GB. That's pretty small these days : time for a bigger disk? Or perhaps the space is elsewhere: probably want to do something like sudo find / -xdev -maxdepth 2 -exec du -sh {} \; | grep -E 'G|M' | sort -g Cheers, Greg --00000000000068c0d406240d5f5c Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Wed, Oct 9, 2024 at 4:10=E2=80=AFAM Mi= kael Petterson <mikaelpet= terson@hotmail.com> wrote:
Hi,
=C2=A0
I find our disk is filling up.
=C2=A0
sudo find /var/lib -type f -size +100M -exec ls -lh {} \; | awk '{ prin= t $9 ": " $5 }'
...=C2=A0<= /div>

Those files only add up to about 30GB. That's = pretty small these days : time for a bigger disk? Or perhaps the space is e= lsewhere: probably want to do something=C2=A0like=C2=A0
sudo find= / -xdev -maxdepth 2 -exec du -sh {} \; | grep -E 'G|M' | sort -g

Cheers,
Greg

--00000000000068c0d406240d5f5c--