| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Fernando Papa" <fpapa(at)claxson(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_temp schemas |
| Date: | 2003-02-06 21:25:55 |
| Message-ID: | 15888.1044566755@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Fernando Papa" <fpapa(at)claxson(dot)com> writes:
> What is the origin of these schemas? local temporary tables? sorts?
Right, they're made to hold temporary tables. The first time a given
backend does CREATE TEMP TABLE, it looks for a pg_temp_n schema, and
makes it if it's not there. On shutdown, it removes the temp tables,
but it seemed like a waste of cycles to remove the pg_temp_n schema
itself.
(ObTrivialFact: the 'n' is the backend's pgproc slot number, so it's
known not to be in use by any concurrently running backend. But it
will certainly be used again in future.)
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | greg | 2003-02-06 21:29:54 | Re: List online archives and spam |
| Previous Message | Bruno Wolff III | 2003-02-06 21:25:53 | Re: Question: unique on multiple columns |