Re: pg_sorttemp11938.0 - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_sorttemp11938.0
Date
Msg-id 25691.971110038@sss.pgh.pa.us
Whole thread Raw
In response to pg_sorttemp11938.0  ("Ingram, Bryan" <BIngram@sixtyfootspider.com>)
List pgsql-general
"Ingram, Bryan" <BIngram@sixtyfootspider.com> writes:
> I've got a file called pg_sorttemp11938.0 in the data directory of one of my
> databases.

If you no longer have a running backend with PID 11938, then that file
is trash.  Temp files are supposed to be cleaned up at backend exit,
but sometimes they're not...

            regards, tom lane

pgsql-general by date:

Previous
From: "Tamsin"
Date:
Subject: pg_hba.conf
Next
From: Bruce Momjian
Date:
Subject: Re: Re: JDBC Performance