PostgreSQL 9.2.4 temp files never released?

From: Edson Richter <edsonrichter(at)hotmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: PostgreSQL 9.2.4 temp files never released?
Date: 2013-09-28 18:16:23
Message-ID: BLU0-SMTP1182D6ABFE33DB6883B0F8FCF2A0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I've a 12Gb database running without problems in Linux Centos 64bit for
years now.
Looking database statistics (in pgAdmin III), I can see that there are
366 temporary files, and they sum up 11,863,839,867 bytes in size.

Is that normal? When will this space be released?

I've restarted the server, but seems those files (in number and in size)
are just growing and growing...

Regards,

Edson Richter

Responses

Browse pgsql-general by date

  From Date Subject
Next Message tuanhoanganh 2013-09-28 18:20:44 Re: PlPython with pyodbc error DLL load failed: A dynamic link library (DLL) initialization routine failed.
Previous Message Eugene Ostrovsky 2013-09-28 18:12:48 multiple databases vs multiple clusters on the same host