Hannu Krosing <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]