MIME-Version: 1.0
References: <GV1PR08MB83052D322AD3FB9A65125339B87E2@GV1PR08MB8305.eurprd08.prod.outlook.com>
 <CAKAnmmKUaeqPjsMdaqK6F8xk0kJ1nzkYN_tbR7i-0xiQp_dVqw@mail.gmail.com>
In-Reply-To: <CAKAnmmKUaeqPjsMdaqK6F8xk0kJ1nzkYN_tbR7i-0xiQp_dVqw@mail.gmail.com>
From: Sergey Fukanchik <fukanchik@gmail.com>
Date: Wed, 9 Oct 2024 19:45:52 +0300
Message-ID: <CAB+D6kVEpN-=RE1RR2Zmcduc1dukN_pyg3-GbPqNsxS3wYBNng@mail.gmail.com>
Subject: Re: Disk is filling up with large files. How can I clean?
To: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CAB%2BD6kVEpN-%3DRE1RR2Zmcduc1dukN_pyg3-GbPqNsxS3wYBNng%40mail.gmail.com>
Precedence: bulk

Another possibility is orphaned files.
See https://www.dbi-services.com/blog/can-there-be-orphaned-data-files-in-p=
ostgresql/
and https://github.com/bdrouvot/pg_orphaned
--
Sergey

On Wed, 9 Oct 2024 at 19:02, Greg Sabino Mullane <htamfids@gmail.com> wrote=
:
>
> On Wed, Oct 9, 2024 at 4:10=E2=80=AFAM Mikael Petterson <mikaelpetterson@=
hotmail.com> 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 : t=
ime 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
>


--=20
Sergey