"Harald Armin Massa" <haraldarminmassa(at)gmail(dot)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