cleanup of pg_temp schemas

Поиск
Список
Период
Сортировка
От Marcel Gsteiger
Тема cleanup of pg_temp schemas
Дата
Msg-id s1f7a939.021@milprog1.milprog.ch
обсуждение исходный текст
Ответы Re: cleanup of pg_temp schemas
Re: cleanup of pg_temp schemas
Список pgsql-general
Hi all,

My PostgreSQL app uses temporary tables. After some time, my database shows lots of pg_temp_xxx schemas with no data
inside.I tried to do a vacuum full analyze to get rid of them, but they still persisted. 

Who takes care for removing these schemas? Can I safely ignore them, or do I have to clean them up periodically? How
shouldthis be done preferably? 

Any help would very much be appreciated.

Regards
--Marcel


В списке pgsql-general по дате отправления: