On 2006-04-24, Andrus <[EMAIL PROTECTED]> wrote: > After some time of working, Postgres 8.1.3 on W2K creates large a number of > empty schemas in my database. > > Those schemas are named pg_temp_1 .. pg_temp_13 (some names are missing in > sequence).
This is normal. The number of temp schemas created will never exceed max_connections. They are recycled, not removed, as needed. > Some of them do not contain any objects. Some contain temp tables created by > my application. The ones that are in use may contain objects. Those objects are cleared out when the connection ends. In the event of a crash, they are cleared out when the temp schema is next recycled. > Is it safe to remove those schemas ? It is not necessary. I do not know if it is safe. -- Andrew, Supernews http://www.supernews.com - individual and corporate NNTP services ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
