Thread: problems with pg_sorttemp

problems with pg_sorttemp

From
Manuel Trujillo
Date:
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?

Thank you very much.

--
Manuel Trujillo         manueltrujillo@dorna.es
Technical Engineer      http://www.motograndprix.com
Dorna Sports S.L.       +34 93 4702864


Re: problems with pg_sorttemp

From
Bruce Momjian
Date:
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