cleanup of pgsql_tmp directory

From: "Robert Klaus" <rklaus(at)nexgenwireless(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: cleanup of pgsql_tmp directory
Date: 2013-02-05 15:50:09
Message-ID: 004e01ce03b8$7ae5a820$70b0f860$@com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

This morning we found out that our filesystem was at 98% and filling
quickly. We immediately found one query running for a long time and saw
1500+ files in the pgsql_tmp directory we could attribute to it.

I killed using pg_terminate_backend and some space was reclaimed, but the
temporary files from the process are still in the pgsql_tmp directory.

We're on postgres 8.4.9 on centos. Which process should be deleting these
files and what is normally the delay? I'm assuming the postmaster process
will eventually delete them, but does the server have to be bounced in order
for this to happen? It's been 30 minutes since the process was killed.

Also, is there some method of governing the temporary space used? Our
temp_tablespace parameter is null.

Thanks

Robert

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Amit Kapila 2013-02-05 16:06:04 Re: [BUGS] BUG #7850: left outer join is not working or I didn't contruct the query properly
Previous Message Pavel Stehule 2013-02-05 14:45:44 Re: BUG #7850: left outer join is not working or I didn't contruct the query properly