clean out ./data/base/pgsql_tmp

From: Dylan Luong <Dylan(dot)Luong(at)unisa(dot)edu(dot)au>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: clean out ./data/base/pgsql_tmp
Date: 2017-12-07 04:18:28
Message-ID: 4f3c89a224ff4660baa62a2b79fb0f1d@ITUPW-EXMBOX3B.UniNet.unisa.edu.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

We have an issue where one of the developers ran a large query that hung was filling up the DATA drive very rapidly. From 50% usage to 95% in less than 2hrs.
It created a very large pgsql_tmp size (300GB). To stop the drive filling up we had to kill the process manually using kill -9.
How do we clean up the pgsql_tmp folder? Will Postgres periodically clean it? Ie CHECKPOINT?
Thanks.

Regards
Dylan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Munro 2017-12-07 04:26:18 Re: clean out ./data/base/pgsql_tmp
Previous Message Vijay Chaudhery 2017-12-06 23:26:21 RE: Migrating From CentOS-6 Oracle 11g R2 To CentOS-7 PostgreSQL ??