On Wed, Dec 6, 2017 at 9:29 PM, Dylan Luong
wrote:
> Since the temp files are easily identifiable as it has the PID in the
> fileaname.
> Is it ok just manually deleting these files as the process has already
> being killed.
>
I've done that before without issue.
Cheers,
Jeff
: Dylan Luong
Cc: pgsql-general@lists.postgresql.org
Subject: Re: clean out ./data/base/pgsql_tmp
On Thu, Dec 7, 2017 at 5:18 PM, Dylan Luong wrote:
> 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
On Wed, Dec 6, 2017 at 8:18 PM, Dylan Luong
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 f
On Thu, Dec 7, 2017 at 1:18 PM, Dylan Luong wrote:
> How do we clean up the pgsql_tmp folder? Will Postgres periodically clean
> it? Ie CHECKPOINT?
A postmaster restart cleans up those files automatically.
--
Michael
On Thu, Dec 7, 2017 at 5:18 PM, Dylan Luong wrote:
> 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
>
