| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | darcy(at)druid(dot)net (D'Arcy J(dot)M(dot) Cain) |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: pg_sorttemp files |
| Date: | 2001-10-18 17:45:49 |
| Message-ID: | 24666.1003427149@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
darcy(at)druid(dot)net (D'Arcy J.M. Cain) writes:
> I have tons of old files with names like base/db/pg_sorttemp####.##. I
> assume that they are temporary sorting files but somehow they never got
> cleared out. Is it safe to delete these from a running system. The files
> are months old.
The first #### is the PID of the backend that made them. If there is no
such backend anymore according to ps, it's safe to zap 'em. I'd rely on
that much more than the mod date.
BTW, if you are seeing unreclaimed sorttemp files in a recent release
(7.0 or later), I'd like to know about it. That shouldn't happen,
short of a backend crash anyway...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-10-18 17:58:30 | Re: autoconf taking forever? |
| Previous Message | Joel Burton | 2001-10-18 17:44:57 | Re: To Postgres Devs : Wouldn't changing the select limit |