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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Markus Bertheau <bertheau(at)bab24(dot)de>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: how do I get rid of huge sorttemp files?
Date: 2003-06-16 19:22:11
Message-ID: 6100.1055791331@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Markus Bertheau <bertheau(at)bab24(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2003-06-16 19:27:33 Re: Move passwords between databases
Previous Message scott.marlowe 2003-06-16 19:06:59 Re: Run 4 postgresql session on ONE server?