| From: | Ron <ronljohnsonjr(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: what causes new temp schemas to be created |
| Date: | 2023-07-10 14:28:10 |
| Message-ID: | 4494e622-1719-2fba-fc45-cfea5e781be9@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 7/10/23 09:20, David G. Johnston wrote:
> On Mon, Jul 10, 2023 at 7:18 AM Ted Toth <txtoth(at)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dimitrios Apostolou | 2023-07-10 15:58:45 | Re: Moving data from huge table slow, min() query on indexed column taking 38s |
| Previous Message | David G. Johnston | 2023-07-10 14:20:43 | Re: what causes new temp schemas to be created |