| From: | Michael Paquier <michael(at)paquier(dot)xyz> |
|---|---|
| To: | Sami Imseih <samimseih(dot)pg(at)gmail(dot)com> |
| Cc: | Lukas Fittl <lukas(at)fittl(dot)com>, Gaurav Singh <gaurav(dot)singh(at)yugabyte(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: pg_stat_statements stores WITH HOLD cursor query with literals |
| Date: | 2026-10-27 23:35:06 |
| Message-ID: | auE1KoaP-pZBSlwc@paquier.xyz |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Tue, Oct 27, 2026 at 05:03:21PM -0500, Sami Imseih wrote:
> So at least for these two contrib modules, preserving the current behavior
> would seem to require keeping the nesting decision decoupled from a single
> shared nesting_level.
>
> Those differences could perhaps be worked around, but each extension would
> still need to decide what the value means for its own purposes, so they may
> still need some form of queryDesc state.
And I doubt that it would fly far without a way to handle the
concurrent activity of more than one extension. FWIW, to me,
QueryDesc is a natural fit to track the nesting level, still my
previous sentence points out that we had better use a different memory
area for each definition we'd want to put on a query basis.
I am wondering if we don't have a bit more we could do for each
QueryDesc at extension level, like activity tracking or stuff in this
area.
--
Michael
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hayato Kuroda (Fujitsu) | 2026-10-28 03:18:31 | RE: START_REPLICATION silently truncates an overlong LSN component |
| Previous Message | Sami Imseih | 2026-10-27 22:03:21 | Re: pg_stat_statements stores WITH HOLD cursor query with literals |