Michael Glaesemann <michael.glaesemann@xxxxxxxxxxxxxx> 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 (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
