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

From: Francois Lacoursiere <lacouf(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: My main/base/pgsql_tmp directory has over 5.7 millions files
Date: 2012-04-09 17:25:35
Message-ID: CALKy+0SByRG1UQVvbLFEwDZ==41Mb6Rd2M9GsQrKAm-WNecpcw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2012-04-09 17:44:50 Re: My main/base/pgsql_tmp directory has over 5.7 millions files
Previous Message Bruno Wolff III 2012-04-09 17:22:26 Re: GROUP BY or alternative means to group