Re: Schemas: status report, call for developers - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Schemas: status report, call for developers
Date
Msg-id 7109.1020437074@sss.pgh.pa.us
Whole thread Raw
In response to Re: Schemas: status report, call for developers  (Hannu Krosing <hannu@tm.ee>)
Responses Re: Schemas: status report, call for developers  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
List pgsql-hackers
Hannu Krosing <hannu@tm.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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: HEADS UP: Win32/OS2/BeOS native ports
Next
From: "Marc G. Fournier"
Date:
Subject: Re: HEADS UP: Win32/OS2/BeOS native ports