Postgres Pro
Downloads
Home   >   mailing lists

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

From Ron
Subject Re: what causes new temp schemas to be created
Date
Msg-id 4494e622-1719-2fba-fc45-cfea5e781be9@gmail.com
Whole thread Raw
In response to Re: what causes new temp schemas to be created  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
On 7/10/23 09:20, David G. Johnston wrote:
On Mon, Jul 10, 2023 at 7:18 AM Ted Toth <txtoth@gmail.com> wrote:
When a temp table is created I see a pg_temp_NNN (for example
pg_temp_3, pg_toast_temp_3) schemas created when/why are additional
temp schemas created( pg_temp_4/pg_toast_temp_4)?


Temporary schemas are isolated to the session they are created in.  Hence, you get multiple temporary schemas if you have concurrent sessions using temporary objects.

IOW, temporary schemata are how Pg lets different sessions have temporary objects use the same name?


--
Born in Arizona, moved to Babylonia.

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: what causes new temp schemas to be created
Next
From: Dimitrios Apostolou
Date:
Subject: Re: Moving data from huge table slow, min() query on indexed column taking 38s