Re: what causes new temp schemas to be created

From: Ted Toth <txtoth(at)gmail(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: what causes new temp schemas to be created
Date: 2023-07-10 17:03:01
Message-ID: CAFPpqQEkg3g4jRf4Fxf3UF3F0tHLdEkNo37Q4tnSDnuQR3yCBw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

So it's an optimization to reuse existing but currently unused temp
schemas, correct?

On Mon, Jul 10, 2023 at 11:22 AM David G. Johnston
<david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
>
> On Mon, Jul 10, 2023 at 9:20 AM Ted Toth <txtoth(at)gmail(dot)com> wrote:
>>
>> I don't see that the schema is removed when the session is over and I
>> see other sessions come along later and use it. I'm assuming here that
>> a session is started on connect and ended when the connection is
>> closed.
>>
>
> The first time a session needs a temporary schema it is assigned one which is then immediately cleared out.
>
> David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2023-07-10 17:08:45 Re: what causes new temp schemas to be created
Previous Message David G. Johnston 2023-07-10 16:22:34 Re: what causes new temp schemas to be created