Search Postgresql Archives

Re: when do pg_temp SCHEMAS get purged?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux