So it's an optimization to reuse existing but currently unused temp schemas, correct? On Mon, Jul 10, 2023 at 11:22 AM David G. Johnston <david.g.johnston@xxxxxxxxx> wrote: > > On Mon, Jul 10, 2023 at 9:20 AM Ted Toth <txtoth@xxxxxxxxx> wrote: >> >> I don't see that the schema is removed when the session is over and I >> see other sessions come along later and use it. I'm assuming here that >> a session is started on connect and ended when the connection is >> closed. >> > > The first time a session needs a temporary schema it is assigned one which is then immediately cleared out. > > David J.