"Harald Armin Massa" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
