Re: how do I get rid of huge sorttemp files?

Markus Bertheau <bertheau@bab24.de> writes:
>  PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC 2.96

> How do I get rid of these huge files

"rm" will do fine, assuming that you are certain the creating backends
aren't around anymore.

> and how do I prevent them from being created again?

An update to something newer than 7.1 might help.  I'm guessing that you
are running into some bug that causes backends to crash every now and
then --- a backend should remove all its temp files at normal exit, but
on crash that doesn't happen.

7.2 and later also have code to auto-remove leftover temp files during
postmaster start, but that code is not in 7.1.

            regards, tom lane