Re: what causes new temp schemas to be created

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ted Toth <txtoth(at)gmail(dot)com>
Cc: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: what causes new temp schemas to be created
Date: 2023-07-10 17:08:45
Message-ID: 2241099.1689008925@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ted Toth <txtoth(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Nathan Bossart 2023-07-10 17:45:31 Re: Is anyone using db_user_namespace?
Previous Message Ted Toth 2023-07-10 17:03:01 Re: what causes new temp schemas to be created