pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Michael Paquier <michael@paquier.xyz>
To: Mircea Cadariu <cadariu.mircea@gmail.com>
Cc: Sami Imseih <samimseih@gmail.com>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Frédéric Yhuel <frederic.yhuel@dalibo.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: pgsql: Drop unnamed portal immediately after execution to completion
Date: Sat, 15 Nov 2025 07:13:42 +0900
Message-ID: <aReplkCd0YIkS5AH@paquier.xyz> (raw)
In-Reply-To: <0a666d28-9080-4239-90d6-f6345bb43468@gmail.com>
References: <CA+TgmoYFJyJNQw3RT7veO3M2BWRE9Aw4hprC5rOcawHZti-f8g@mail.gmail.com>
	<1982325.1762810082@sss.pgh.pa.us>
	<aRJ1zn0z-Bn0qc2H@paquier.xyz>
	<CA+TgmoYR2OP8C+MHC8VCA80-r=Q09aF-_=juvBLvUKS09d__Mw@mail.gmail.com>
	<00d71a54-2118-4b18-87e8-33f4a99dc624@gmail.com>
	<aRV6D3vxMQTQ7CxG@paquier.xyz>
	<e0ab1ea2-7084-44c5-b6aa-f01db7be7792@gmail.com>
	<CAA5RZ0uFhj3bGbwSFWX1_hRhdHvp3JO1zAuSvp=XrfOoZ2GCcw@mail.gmail.com>
	<aRbGaQTisuKMREuS@paquier.xyz>
	<0a666d28-9080-4239-90d6-f6345bb43468@gmail.com>

On Fri, Nov 14, 2025 at 03:10:32PM +0000, Mircea Cadariu wrote:
> What's interesting about the holdable cursors scenario is that as far as I
> can tell the temp files are cleaned up during PersistHoldablePortal instead
> of PortalDrop.

As part of the ExecutorEnd() done in this case.  Right, it looks like
a good thing to track this behavior as well in the long-run.  I'll
double-check that later.
--
Michael

Attachments:

  signature.asc (application/pgp-signature, 832B) download

view thread (14+ messages)  latest in thread

Message-ID: <aReplkCd0YIkS5AH@paquier.xyz>
Permalink:  ../aReplkCd0YIkS5AH@paquier.xyz/
Also on:    postgresql.org/message-id/aReplkCd0YIkS5AH@paquier.xyz

 · 

reply
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-committers@postgresql.org
  Cc: michael@paquier.xyz, cadariu.mircea@gmail.com, samimseih@gmail.com, robertmhaas@gmail.com, tgl@sss.pgh.pa.us, frederic.yhuel@dalibo.com, pgsql-hackers@lists.postgresql.org
  Subject: Re: pgsql: Drop unnamed portal immediately after execution to completion
  In-Reply-To: <aReplkCd0YIkS5AH@paquier.xyz>

* 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