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

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Sami Imseih <samimseih(at)gmail(dot)com>
Cc: Mircea Cadariu <cadariu(dot)mircea(at)gmail(dot)com>, Guillaume Lelarge <guillaume(dot)lelarge(at)dalibo(dot)com>, Frédéric Yhuel <frederic(dot)yhuel(at)dalibo(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Benoit Lobréau <benoit(dot)lobreau(at)dalibo(dot)com>, Pierrick Chovelon <pierrick(dot)chovelon(at)dalibo(dot)com>
Subject: Re: [BUG] temporary file usage report with extended protocol and unnamed portals
Date: 2025-11-05 05:44:39
Message-ID: aQrkR_6oGbK3bxUg@paquier.xyz
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Oct 29, 2025 at 04:58:22PM -0500, Sami Imseih wrote:
> We can actually remove "temporary file removed"
> and "no statement logged" since we expect the
> logging to blame the correct query in all these cases.

While looking at the surroundings, I have noticed one comment on top
of the call of CreatePortal() in exec_simple_query() where an unnamed
portal is created, telling about a portal drop, but this still applies
to a succession of normal queries with for example rollbacks quickly
complaining (behavior documented). The same could still be said for
exec_bind_message() for CreatePortal() with an unnamed portal, still I
agree with the change in the docs that the completion of an unnamed
portal is more relevant to mention. So the doc change should be OK.

Some of the comments in the test were not correctly updated, I have
fixed these.

After looking again at the thread, I have decided to credit all three
of you as authors of this patch. Frederic has spent what I guess is a
lot of time on analyzing this, and then both Sami and Mircea have
followed up. This way, nobody should be jealous.

Then done on HEAD. If this proves to be a problem and that we have to
revert 1fd981f05369 for v19, at least we'll have the tests moving
forward. Anyway, let's have this change brew for now.
--
Michael

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bryan Green 2025-11-05 06:03:29 [PATCH] Fix fragile walreceiver test.
Previous Message Michael Paquier 2025-11-05 05:43:31 pgsql: Drop unnamed portal immediately after execution to completion