management of pg-schemas: pg_temp_n and pg_toast_n ?

Поиск
Список
Период
Сортировка
От Mark Rostron
Тема management of pg-schemas: pg_temp_n and pg_toast_n ?
Дата
Msg-id FD020D3E50E7FA479567872E5F5F31E30459FB4D73@ex01.corp.ql2.com
обсуждение исходный текст
Ответы Re: management of pg-schemas: pg_temp_n and pg_toast_n ?
Список pgsql-admin

This is occurring In an 8.4.2 pg database, and I have noticed it in 8.3.10 as well.

We do a lot of work with temp tables here, and over time a lot of pg_temp_[n] schemas have appeared.

Similarly, we notice build-up of pg_toast_[n] schemas.

 

Is it ok to drop these if they contain no tables?

Or is there a way to prevent them from persisting past a given life-time??

 

Mr

 

 

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

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: files under pg_clog directories are missing
Следующее
От: Tom Lane
Дата:
Сообщение: Re: management of pg-schemas: pg_temp_n and pg_toast_n ?