| From: | Robert Dege <rcd(at)amherst(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Odd files |
| Date: | 2000-12-20 16:58:39 |
| Message-ID: | 3A40E53F.17C9F390@comptekamherst.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I've been running postgresql for quite a while now. And it's been
working with minimal errors, leaving me in a fat, dumb and happy state.
Recently though, I ran out of disk space on my 1 partition. Upon
investigation, it appears that one of my databases was to blame. But
here's the odd part:
[base/cm]>ls -l
-rw------- 1 postgres postgres 0 May 28 2000 pg_sorttemp2662.0
-rw------- 1 postgres postgres 0 May 28 2000 pg_sorttemp2662.1
-rw------- 1 postgres postgres 0 May 28 2000 pg_sorttemp2662.2
-rw------- 1 postgres postgres 0 May 28 2000 pg_sorttemp2662.3
-rw------- 1 postgres postgres 0 May 28 2000 pg_sorttemp2662.4
-rw------- 1 postgres postgres 0 May 28 2000 pg_sorttemp2662.5
-rw------- 1 postgres postgres 0 May 28 2000 pg_sorttemp2662.6
-rw------- 1 postgres postgres 0 May 28 2000
pg_sorttemp32606.0
-rw------- 1 postgres postgres 0 May 28 2000
pg_sorttemp32606.1
-rw------- 1 postgres postgres 0 May 28 2000
pg_sorttemp32606.2
-rw------- 1 postgres postgres 0 May 28 2000
pg_sorttemp32606.3
-rw------- 1 postgres postgres 0 May 28 2000
pg_sorttemp32606.4
-rw------- 1 postgres postgres 0 May 28 2000
pg_sorttemp32606.5
-rw------- 1 postgres postgres 0 May 28 2000
pg_sorttemp32606.6
-rw------- 1 postgres postgres 115482624 Dec 18 23:46
pg_sorttemp3946.0
-rw------- 1 postgres postgres 109785088 Dec 18 23:46
pg_sorttemp3946.1
-rw------- 1 postgres postgres 100233216 Dec 18 23:46
pg_sorttemp3946.2
-rw------- 1 postgres postgres 86548480 Dec 18 23:46 pg_sorttemp3946.3
-rw------- 1 postgres postgres 63303680 Dec 18 23:46 pg_sorttemp3946.4
-rw------- 1 postgres postgres 43204608 Dec 18 23:46 pg_sorttemp3946.5
-rw------- 1 postgres postgres 0 Dec 19 09:37 pg_sorttemp3946.6
My questions:
What are these files?
Are they safe to delete?
Thanks for any input
-Rob
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Dege | 2000-12-20 17:00:20 | Re:Odd Files |
| Previous Message | Ned Lilly | 2000-12-20 15:56:42 | Re: Postgres demographics? |