Re: [BUG] temporary file usage report with extended protocol and unnamed portals

Michael Paquier <michael@paquier.xyz>

From: Michael Paquier <michael@paquier.xyz>

To: Sami Imseih <samimseih@gmail.com>

Cc: Mircea Cadariu <cadariu.mircea@gmail.com>, Frédéric Yhuel <frederic.yhuel@dalibo.com>, Tom Lane <tgl@sss.pgh.pa.us>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, Benoit Lobréau <benoit.lobreau@dalibo.com>, Guillaume Lelarge <guillaume.lelarge@dalibo.com>, Pierrick Chovelon <pierrick.chovelon@dalibo.com>

Date: 2025-09-26T02:28:48Z

Lists: pgsql-hackers

On Thu, Sep 25, 2025 at 09:05:15PM -0500, Sami Imseih wrote:
>> In short, I would be inclined to do nothing here,
> 
> Maybe we document this behavior? [2]

In the GUC description.  Why not.  The protocol piece with unnamed
portal cleanup is hard to notice by itself..
--
Michael

Commits

Drop unnamed portal immediately after execution to completion
- 1fd981f05369 19 (unreleased) landed
Override log_error_verbosity to "default" in test 009_log_temp_files
- 02c171f63fca 19 (unreleased) landed
Add tests for logging of temporary file removal and statement
- 76bba033128a 19 (unreleased) landed