Re: clean out ./data/base/pgsql_tmp - Mailing list pgsql-general

From Jeff Janes
Subject Re: clean out ./data/base/pgsql_tmp
Date
Msg-id CAMkU=1yvm6dxqPjkQhQsWbgxQ7Yqm1tDNfHGaUm5Cj_2i322Uw@mail.gmail.com
Whole thread Raw
In response to clean out ./data/base/pgsql_tmp  (Dylan Luong <Dylan.Luong@unisa.edu.au>)
List pgsql-general
On Wed, Dec 6, 2017 at 8:18 PM, Dylan Luong <Dylan.Luong@unisa.edu.au> wrote:

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.


Did you try kill -15 first?  If you did try it and it did not work, then that is probably a bug.  And if you have a reproducible test case, then we will probably be able to fix it.

Cheers,

Jeff

pgsql-general by date:

Previous
From: Michael Paquier
Date:
Subject: Re: clean out ./data/base/pgsql_tmp
Next
From: John R Pierce
Date:
Subject: Re: Migrating From CentOS-6 Oracle 11g R2 To CentOS-7 PostgreSQL ??