Re: [GENERAL] My main/base/pgsql_tmp directory has over 5.7 millions files

2012-04-09 Thread Tom Lane
Francois Lacoursiere writes: > 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. They're certainly supposed to be cleaned up. Can you provide a test case that causes one to be created and not

[GENERAL] My main/base/pgsql_tmp directory has over 5.7 millions files

2012-04-09 Thread Francois Lacoursiere
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 t