Given the below information, is it reasonable to assume that files in pgsql_tmp dated prior to 10 days ago can be
safelyremoved?
postgres@hw-prod-repdb1> uptime
15:01:35 up 10 days, 13:50, 3 users, load average: 1.23, 1.15, 0.63
postgres@hw-prod-repdb1> pwd
/mnt/iscsi/psql_tmp/tmpdata
postgres@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
