Feedback-ID: i675e48f3:Fastmail
MIME-Version: 1.0
Date: Thu, 10 Sep 2026 17:04:17 -0400
From: "Greg Burd" <greg@burd.me>
To: "Robert Haas" <robertmhaas@gmail.com>, "Tom Lane" <tgl@sss.pgh.pa.us>
Cc: "Daniel Gustafsson" <daniel@yesql.se>,
 "PostgreSQL Hackers" <pgsql-hackers@lists.postgresql.org>
Message-Id: <5d89549c-117e-45ae-b934-a2bb71c82a79@app.fastmail.com>
In-Reply-To: 
 <CA+TgmoafHbFwzgKQZn+UgEXHYs_UmC4Wrc5pricG7--di8po6w@mail.gmail.com>
References: <E15AC050-C4B5-488D-BB2D-3C7AC9F89EA8@yesql.se>
 <CA+TgmoaOCdjAjr240e_+xoqQCRmLC9MFn3kZOu-7j8w8HBrd8g@mail.gmail.com>
 <927668.1789072635@sss.pgh.pa.us>
 <CA+TgmoafHbFwzgKQZn+UgEXHYs_UmC4Wrc5pricG7--di8po6w@mail.gmail.com>
Subject: Re: Trying to break online checksums with LLMs
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Archived-At: 
 <https://www.postgresql.org/message-id/5d89549c-117e-45ae-b934-a2bb71c82a79%40app.fastmail.com>
Precedence: bulk


On Thu, Sep 10, 2026, at 4:51 PM, Robert Haas wrote:
> On Thu, Sep 10, 2026 at 4:37=E2=80=AFPM Tom Lane <tgl@sss.pgh.pa.us> w=
rote:
>> Don't we have logic somewhere to clean up orphaned relation files?
>
> Uh ... no?
>
> I mean, temp tables get cleaned up and unlogged tables get reset to
> empty, but the goal of being able to remove permanent relation files
> instead of permanently leaking them has, to my knowledge, thus far
> eluded us. I had hope to address that when working on UNDO, and other
> people have tried as well, but unless I've missed something big,
> nobody has thus far succeeded.

This is incoming with my resurrection of the UNDO work you and other
did and the addition of what I call "FILEOPS".

ETA... a week, target v20.

-greg

> --=20
> Robert Haas
> EDB: http://www.enterprisedb.com