Re: what causes new temp schemas to be created - Mailing list pgsql-general

From Tom Lane
Subject Re: what causes new temp schemas to be created
Date
Msg-id 2241099.1689008925@sss.pgh.pa.us
Whole thread Raw
In response to Re: what causes new temp schemas to be created  (Ted Toth <txtoth@gmail.com>)
List pgsql-general
Ted Toth <txtoth@gmail.com> writes:
> So it's an optimization to reuse existing but currently unused temp
> schemas, correct?

Exactly.  We could just destroy and recreate the old temp schema,
but that seems to lead to useless catalog churn.  Instead we just
destroy any old contents, if there's an existing temp schema in
the slot assigned to the current backend.

            regards, tom lane



pgsql-general by date:

Previous
From: Ted Toth
Date:
Subject: Re: what causes new temp schemas to be created
Next
From: Nathan Bossart
Date:
Subject: Re: Is anyone using db_user_namespace?