Re: clean out ./data/base/pgsql_tmp

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: clean out ./data/base/pgsql_tmp
Дата
Msg-id CAMkU=1yvm6dxqPjkQhQsWbgxQ7Yqm1tDNfHGaUm5Cj_2i322Uw@mail.gmail.com
обсуждение исходный текст
Ответ на clean out ./data/base/pgsql_tmp  (Dylan Luong <Dylan.Luong@unisa.edu.au>)
Список 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 по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: clean out ./data/base/pgsql_tmp
Следующее
От: John R Pierce
Дата:
Сообщение: Re: Migrating From CentOS-6 Oracle 11g R2 To CentOS-7 PostgreSQL ??