Postgres Pro
Downloads
Home   >   mailing lists

PostgreSQL 9.2.4 temp files never released? - Mailing list pgsql-general

From Edson Richter
Subject PostgreSQL 9.2.4 temp files never released?
Date
Msg-id BLU0-SMTP1182D6ABFE33DB6883B0F8FCF2A0@phx.gbl
Whole thread Raw
Responses Re: PostgreSQL 9.2.4 temp files never released?  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: PostgreSQL 9.2.4 temp files never released?  (Edson Richter <edsonrichter@hotmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Eugene Ostrovsky
Date:
Subject: multiple databases vs multiple clusters on the same host
Next
From: tuanhoanganh
Date:
Subject: Re: PlPython with pyodbc error DLL load failed: A dynamic link library (DLL) initialization routine failed.