"Harald Armin Massa" <haraldarminmassa@xxxxxxxxx> 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
