Re: orphaned?? tmp files

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Reid(dot)Thompson(at)ateb(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: orphaned?? tmp files
Date: 2011-03-03 22:04:50
Message-ID: 8445.1299189890@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Reid Thompson <Reid(dot)Thompson(at)ateb(dot)com> writes:
> Given the below information, is it reasonable to assume that files in pgsql_tmp dated prior to 10 days ago can be safely removed?

That listing doesn't show anything in pgsql_tmp ...

What the listing looks like to me is a tablespace containing a few
tables that haven't been touched in awhile. Whether they're still
referenced from anywhere is not apparent from this data.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Williamson 2011-03-04 01:05:37 Re: I need your help to get opinions about this situation
Previous Message Reid Thompson 2011-03-03 20:11:27 orphaned?? tmp files