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  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: cleanup of pg_temp schemas  (Martijn van Oosterhout <kleptog@svana.org>)
Список 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 по дате отправления:

Предыдущее
От: "icaro"
Дата:
Сообщение: Case Insensitive & Accent Insensitive
Следующее
От: "Andrew L. Gould"
Дата:
Сообщение: Re: [ODBC] ODBC (win32) X PostgreSQL(Linux)