Re: problems with pg_sorttemp - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: problems with pg_sorttemp
Date
Msg-id 200201081901.g08J1PB12464@candle.pha.pa.us
Whole thread Raw
In response to problems with pg_sorttemp  (Manuel Trujillo <manueltrujillo@dorna.es>)
List pgsql-admin
Manuel Trujillo wrote:
> Hi.
>
> Excuse me my ignorance, but I have a problem with the
> ../data/base/xxx/pg_sorttempxxx.x.
> About 7.4 G of file utilization of this files. Anybody can help me for
> look documentation about this, or directly, tell me why occur this?

You can delete it if the postmaster is stopped.  7.2 will clean those up
automatically.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: problem with pg_sorttemp files
Next
From: "Peter T. Brown"
Date:
Subject: query priority