Tom,
> 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.
thanks for the information! Now I understand: every backend gets it's own pg_tempxx, that is why in production those number rose fairly quickly; and the pg_tempxx schemas gets recycled after the backend exits.
Now if only I would sell my software after maximum simultanuos concurrend users, I would have a very good, free measurement :)
Thank you very much,
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
Let's set so double the killer delete select all.
