Re: What are all the reasons/possibilities of failure to free-up disk space occupied by TEMPORARY table?

"Gnanakumar" <gnanam@zoniac.com> wrote:

> We're using PostgreSQL v8.2.3.

There are probably hundreds of bug fixes between 8.2.3 and the
current 8.2 release, which is 8.2.21.

http://www.postgresql.org/support/versioning

http://www.postgresql.org/docs/8.2/static/release.html

On top of that, 8.2 is so old that it's three months away from the
end of its five-year support window:

http://wiki.postgresql.org/wiki/PostgreSQL_Release_Support_Policy

I recommend that you apply the 8.2 bug fixes immediately, and start
working on a plan to move to 9.0.  If you see the problem in a
version which is current and supported, please post again.

-Kevin