My main/base/pgsql_tmp directory has over 5.7 millions files

Поиск
Список
Период
Сортировка
От Francois Lacoursiere
Тема My main/base/pgsql_tmp directory has over 5.7 millions files
Дата
Msg-id CALKy+0SByRG1UQVvbLFEwDZ==41Mb6Rd2M9GsQrKAm-WNecpcw@mail.gmail.com
обсуждение исходный текст
Ответы Re: My main/base/pgsql_tmp directory has over 5.7 millions files
Список pgsql-general
Is there any reason why these files aren't cleaned-up ?  We have just installed postgresql-9.1.3 and it seems we have this problem since this update.
I haven't checked the ratio (ls takes more than 5 minutes to return) but most of these files seems to be empty.  It causes me problem when I try to tar/untar my data directory to have SR on a slave machine.

Would it be safe to have a cron script cleaining up these files once a day ?  Better yet, any idea why those files are not automatically deleted when they are no longer needed ?

Francois L.
Montreal, Canada

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

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: GROUP BY or alternative means to group
Следующее
От: Tom Lane
Дата:
Сообщение: Re: My main/base/pgsql_tmp directory has over 5.7 millions files