Re: when do pg_temp SCHEMAS get purged?

"Harald Armin Massa" <haraldarminmassa@gmail.com> writes:
> Now I looked at system objects and detected, that schemas named PG_TEMPn,
> where n is a slowly growing integer,
> are created.

> Those schemas seem to get more and more and more. Is anyprocess taking care
> of purging the ones no longer needed?

We don't bother.  One row in pg_namespace is not worth removing,
especially when it's likely to be needed again someday.

(Now, if any of the *contents* of the temp namespaces don't go away at
backend exit, that's another story...)

            regards, tom lane