From: Greg Burd <greg@burd.me>
To: Robert Haas <robertmhaas@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Daniel Gustafsson <daniel@yesql.se>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: Trying to break online checksums with LLMs
Date: Thu, 10 Sep 2026 17:04:17 -0400
Message-ID: <5d89549c-117e-45ae-b934-a2bb71c82a79@app.fastmail.com> (raw)
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>
On Thu, Sep 10, 2026, at 4:51 PM, Robert Haas wrote:
> On Thu, Sep 10, 2026 at 4:37 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> 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
> --
> Robert Haas
> EDB: http://www.enterprisedb.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: greg@burd.me, robertmhaas@gmail.com, tgl@sss.pgh.pa.us, daniel@yesql.se, pgsql-hackers@lists.postgresql.org
Subject: Re: Trying to break online checksums with LLMs
In-Reply-To: <5d89549c-117e-45ae-b934-a2bb71c82a79@app.fastmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox