Re: identifying the backend that owns a temporary schema - Mailing list pgsql-hackers

From Tom Lane
Subject Re: identifying the backend that owns a temporary schema
Date
Msg-id 3499642.1664221809@sss.pgh.pa.us
Whole thread Raw
In response to Re: identifying the backend that owns a temporary schema  (Nathan Bossart <nathandbossart@gmail.com>)
Responses Re: identifying the backend that owns a temporary schema
List pgsql-hackers
Nathan Bossart <nathandbossart@gmail.com> writes:
> On Sat, Sep 24, 2022 at 01:41:38PM -0400, Tom Lane wrote:
>> One thing I don't like about it documentation-wise is that it leaves
>> the concept of backend ID pretty much completely undefined.

> How specific do you think this definition ought to be?

Fairly specific, I think, so that people can reason about how it behaves.
Notably, it seems absolutely critical to be clear that the IDs recycle
over short time frames.  Maybe like

    These access functions use the session's backend ID number, which is
    a small integer that is distinct from the backend ID of any concurrent
    session, although an ID can be recycled as soon as the session exits.
    The backend ID is used, among other things, to identify the session's
    temporary schema if it has one.

I'd prefer to use the terminology "session" than "backend" in the
definition.  I suppose we can't get away with actually calling it
a "session ID" given that "backend ID" is used in so many places;
but I think people have a clearer handle on what a session is.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: [RFC] building postgres with meson - v13
Next
From: Robert Haas
Date:
Subject: Re: HOT chain validation in verify_heapam()