| From: | Reid Thompson <Reid(dot)Thompson(at)ateb(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | orphaned?? tmp files |
| Date: | 2011-03-03 20:11:27 |
| Message-ID: | 4D6FF5EF.9050405@ateb.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Given the below information, is it reasonable to assume that files in pgsql_tmp dated prior to 10 days ago can be safely removed?
postgres(at)hw-prod-repdb1> uptime
15:01:35 up 10 days, 13:50, 3 users, load average: 1.23, 1.15, 0.63
postgres(at)hw-prod-repdb1> pwd
/mnt/iscsi/psql_tmp/tmpdata
postgres(at)hw-prod-repdb1> ls -rtlh *
-rw------- 1 postgres postgres 4 May 11 2009 PG_VERSION
pgsql_tmp:
total 0
41099:
total 3.0G
-rw------- 1 postgres postgres 8.0K Mar 12 2010 88326
-rw------- 1 postgres postgres 0 Mar 12 2010 88324
-rw------- 1 postgres postgres 0 Mar 16 2010 88580
-rw------- 1 postgres postgres 0 Mar 16 2010 88577.3
-rw------- 1 postgres postgres 0 Mar 16 2010 88577.4
-rw------- 1 postgres postgres 0 Mar 16 2010 88577.5
-rw------- 1 postgres postgres 8.0K Mar 16 2010 88592
-rw------- 1 postgres postgres 8.0K Jun 2 2010 94968
-rw------- 1 postgres postgres 0 Jun 2 2010 94966
-rw------- 1 postgres postgres 8.0K Jun 2 2010 94974
-rw------- 1 postgres postgres 0 Jun 2 2010 94972
-rw------- 1 postgres postgres 8.0K Aug 26 2010 104559
-rw------- 1 postgres postgres 0 Aug 26 2010 104557
-rw------- 1 postgres postgres 1.0G Oct 27 10:05 88577
-rw------- 1 postgres postgres 1.0G Oct 27 10:07 88577.1
-rw------- 1 postgres postgres 824M Oct 27 10:09 88577.2
-rw------- 1 postgres postgres 488K Nov 2 12:17 111724
-rw------- 1 postgres postgres 43M Dec 7 14:46 94963
-rw------- 1 postgres postgres 25M Dec 7 14:46 94969
-rw------- 1 postgres postgres 8.0K Feb 22 15:45 104560
-rw------- 1 postgres postgres 8.0K Feb 22 15:45 104554
-rw------- 1 postgres postgres 72M Mar 2 16:12 88321
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2011-03-03 22:04:50 | Re: orphaned?? tmp files |
| Previous Message | Derrick Rice | 2011-03-03 17:44:23 | Re: Tracking table modifications / table stats |