Re: Parallel query and temp_file_limit

From: Peter Geoghegan <pg(at)heroku(dot)com>
To: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Cc: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Parallel query and temp_file_limit
Date: 2016-05-17 22:40:47
Message-ID: CAM3SWZTXfNKSSJE8Q+AH9eHJiKy9BdLFH3S1+oj4ACgLPU+=BQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, May 17, 2016 at 3:33 PM, Peter Geoghegan <pg(at)heroku(dot)com> wrote:
> Fundamentally, since temporary_files_size enforcement simply
> piggy-backs on low-level fd.c file management, without any
> consideration of what the temp files contain, it'll be hard to be sure
> that parallel workers will not have issues. I think it'll be far
> easier to fix the problem then it would be to figure out if it's
> possible to get away with it.

I'll write a patch to fix the issue, if there is a consensus on a solution.

--
Peter Geoghegan

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Langote 2016-05-18 01:26:51 Re: Declarative partitioning
Previous Message Peter Geoghegan 2016-05-17 22:33:45 Re: Parallel query and temp_file_limit