| From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
|---|---|
| To: | Dylan Luong <Dylan(dot)Luong(at)unisa(dot)edu(dot)au> |
| Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: clean out ./data/base/pgsql_tmp |
| Date: | 2017-12-07 05:00:38 |
| Message-ID: | CAMkU=1yvm6dxqPjkQhQsWbgxQ7Yqm1tDNfHGaUm5Cj_2i322Uw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Dec 6, 2017 at 8:18 PM, Dylan Luong <Dylan(dot)Luong(at)unisa(dot)edu(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John R Pierce | 2017-12-07 05:02:13 | Re: Migrating From CentOS-6 Oracle 11g R2 To CentOS-7 PostgreSQL ?? |
| Previous Message | Michael Paquier | 2017-12-07 04:36:26 | Re: clean out ./data/base/pgsql_tmp |