Re: pgsql_tmp( Temporary tablespace)

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: pgsql_tmp( Temporary tablespace)
Дата
Msg-id D960CB61B694CF459DCFB4B0128514C208C0C3F7@exadv11.host.magwien.gv.at
обсуждение исходный текст
Ответ на Re: pgsql_tmp( Temporary tablespace)  ("suhas.basavaraj12" <suhas.b@verse.in>)
Список pgsql-performance
suhas.basavaraj12 wrote:
> Can i delete the content of this folder. I have observed couple of
times ,
> this folder got cleaned automatically.

These files are in use and you should not delete them.
If you need them to go right now, cancel the queries that
create temporary files.

If there are any leftover when PostgreSQL is shut down
(don't know if that can happen), it should be safe to
delete them.

> Which backend process deletes  the data from this folder .Any Idea?

I'm not sure, but probably the one that created them.

Yours,
Laurenz Albe


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

Предыдущее
От: "suhas.basavaraj12"
Дата:
Сообщение: Re: pgsql_tmp( Temporary tablespace)
Следующее
От: Niels Kristian Schjødt
Дата:
Сообщение: Database design - best practice