| From: | Micah Anderson <micah(at)colltech(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | HUGE pg_sorttemp files, can I delete? |
| Date: | 2000-11-14 20:49:06 |
| Message-ID: | 20001114144906.G24165@psasolar.colltech.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
In my /var/postgres/base/database directory I've got a bunch of REALLY big
files that are from several months ago:
-rw------- 1 postgres postgres 191684608 Oct 30 23:35 pg_sorttemp10964.0
-rw------- 1 postgres postgres 192126976 Oct 30 23:44 pg_sorttemp11353.0
-rw------- 1 postgres postgres 192126976 Oct 30 23:44 pg_sorttemp11369.0
-rw------- 1 postgres postgres 983040 Oct 23 17:37 pg_sorttemp22475.0
-rw------- 1 postgres postgres 26787840 Oct 21 14:00 pg_sorttemp2372.0
-rw------- 1 postgres postgres 130465792 Nov 9 13:42 pg_sorttemp30831.0
-rw------- 1 postgres postgres 232701952 Oct 30 20:41 pg_sorttemp5564.0
-rw------- 1 postgres postgres 232701952 Oct 30 20:41 pg_sorttemp5576.0
-rw------- 1 postgres postgres 232701952 Oct 30 20:41 pg_sorttemp5588.0
-rw------- 1 postgres postgres 232792064 Oct 30 20:41 pg_sorttemp5749.0
-rw------- 1 postgres postgres 190275584 Oct 30 20:41 pg_sorttemp6480.0
-rw------- 1 postgres postgres 190275584 Oct 30 20:41 pg_sorttemp6494.0
There are some there that are from today - but from Oct 30? Can I delete
these files? What are causing these? Can I set a limit or something? My
database is 3.6 gigs, that is HUGE. I think it is largely because of these
files.
Thanks!
Micah
--
Micah Anderson
Collective Technologies
www.colltech.com
"To be and not to do is not to be at all"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gunnar R|nning | 2000-11-14 21:07:44 | Re: a request for some experienced input..... |
| Previous Message | Stephan Szabo | 2000-11-14 20:31:28 | Re: a request for some experienced input..... |