| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Hannu Krosing <hannu(at)tm(dot)ee> |
| Cc: | "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Schemas: status report, call for developers |
| Date: | 2002-05-03 14:44:34 |
| Message-ID: | 7109.1020437074@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-interfaces |
Hannu Krosing <hannu(at)tm(dot)ee> writes:
> On Thu, 2002-05-02 at 16:52, Tom Lane wrote:
>> If we used PID then we'd eventually have 64K (or whatever the range of
>> PIDs is on your platform) different pg_temp_nnn entries cluttering
>> pg_namespace.
> Should they not be cleaned up at backend exit even when they are in
> range 1..MaxBackends ?
Hm. We currently remove the schema contents (ie the temp tables) but
not the pg_namespace entry itself. Seems like deleting that only to
have to recreate it would be a waste of cycles.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc G. Fournier | 2002-05-03 14:54:27 | Re: HEADS UP: Win32/OS2/BeOS native ports |
| Previous Message | Tom Lane | 2002-05-03 14:42:26 | Re: HEADS UP: Win32/OS2/BeOS native ports |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hannu Krosing | 2002-05-03 15:39:36 | Re: Schemas: status report, call for developers |
| Previous Message | Shawn Stephens - Q Data KZN | 2002-05-03 12:39:20 | libpq interface problem. |