Michael Glaesemann <[email protected]> writes:
> We've got over 250GB of files in a pgsql_tmp directory, some with
> modification timestamps going back to August 2010 when the server was last
> restarted.
That's very peculiar. Do you keep query logs? It would be useful to
try to correlate the temp files' PIDs and timestamps with the specific
queries that must have created them.
> Does this query look reasonable? What other things should I take into account
> before I start deleting files from the file system? Why might these files not
> be cleaned up on their own?
Personally, I'd not risk trying to match on PID; it should be sufficient
to delete anything with a timestamp older than the oldest active
backend. (Unless you've got some really long-lived sessions in
there...)
What PG version is this?
regards, tom lane
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
