MIME-Version: 1.0
References: <GV1PR08MB83052D322AD3FB9A65125339B87E2@GV1PR08MB8305.eurprd08.prod.outlook.com>
 <CAKkG4_krrgxcGgUFoWu56xAS9CinZdpf5nDBfkfm0Mqf-dr6aw@mail.gmail.com> <D816802A-38F4-4402-A542-063DF5BB5648@americanefficient.com>
In-Reply-To: <D816802A-38F4-4402-A542-063DF5BB5648@americanefficient.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Wed, 9 Oct 2024 10:29:09 -0400
Message-ID: <CANzqJaB3D=P6y=zosX3ZyB3dELAT=hm4uzWGZRF3+g+_O6m2xg@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: multipart/alternative; boundary="0000000000005f668406240c14d2"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaB3D%3DP6y%3DzosX3ZyB3dELAT%3Dhm4uzWGZRF3%2Bg%2B_O6m2xg%40mail.gmail.com>
Precedence: bulk

--0000000000005f668406240c14d2
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wed, Oct 9, 2024 at 9:02=E2=80=AFAM Philip Semanchuk <
philip@americanefficient.com> wrote:

>
> > On Oct 9, 2024, at 5:52=E2=80=AFAM, Torsten F=C3=B6rtsch <tfoertsch123@=
gmail.com>
> wrote:
> >
> > Filenames like 16665, 16665.1, 16665.2 etc all represent the same table
> (or similar). The number 16665 is called the file node.
> >
> > To get a list of file nodes for a specific database you can run:
> >
> > SELECT oid::regclass::text, relfilenode FROM pg_class;
> >
> > The /16384/ in the path represents the database. To decipher that you
> can run:
> >
> > SELECT datname, oid FROM pg_database;
> >
> > Once you have all that information, you know which database to connect
> to and which tables are big. Then you can DROP/DELETE/TRUNCATE or so.
>
> Mikael, if you=E2=80=99re unaware of VACUUM FULL (as opposed to just VACU=
UM), you
> should read about that too.
>

VACUUM FULL with an almost-full disk probably isn't the wisest idea.

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> crustacean!

--0000000000005f668406240c14d2
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Wed, Oct 9, 2024 at 9:02=E2=80=AFAM Ph=
ilip Semanchuk &lt;<a href=3D"mailto:philip@americanefficient.com">philip@a=
mericanefficient.com</a>&gt; wrote:<br></div><div class=3D"gmail_quote"><bl=
ockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-lef=
t:1px solid rgb(204,204,204);padding-left:1ex"><br>&gt; On Oct 9, 2024, at =
5:52=E2=80=AFAM, Torsten F=C3=B6rtsch &lt;<a href=3D"mailto:tfoertsch123@gm=
ail.com" target=3D"_blank">tfoertsch123@gmail.com</a>&gt; wrote:<br>
&gt; <br>
&gt; Filenames like 16665, 16665.1, 16665.2 etc all represent the same tabl=
e (or similar). The number 16665 is called the file node.<br>
&gt; <br>
&gt; To get a list of file nodes for a specific database you can run:<br>
&gt; <br>
&gt; SELECT oid::regclass::text, relfilenode FROM pg_class;<br>
&gt; <br>
&gt; The /16384/ in the path represents the database. To decipher that you =
can run:<br>
&gt; <br>
&gt; SELECT datname, oid FROM pg_database;<br>
&gt; <br>
&gt; Once you have all that information, you know which database to connect=
 to and which tables are big. Then you can DROP/DELETE/TRUNCATE or so.<br>
<br>
Mikael, if you=E2=80=99re unaware of VACUUM FULL (as opposed to just VACUUM=
), you should read about that too.<br></blockquote><div><br></div><div>VACU=
UM FULL with an almost-full disk probably isn&#39;t the wisest idea.</div><=
div><br></div></div><span class=3D"gmail_signature_prefix">-- </span><br><d=
iv dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr">Death to &lt;Reda=
cted&gt;, and butter sauce.<div>Don&#39;t boil me, I&#39;m still alive.<br>=
<div><div>&lt;Redacted&gt; crustacean!</div></div></div></div></div></div>

--0000000000005f668406240c14d2--