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@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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
