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: | Raw Message | Whole Thread | 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..... |