orphaned?? tmp files

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

Responses

Browse pgsql-general by date

  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