Re: Re: patch review : Add ability to constrain backend temporary file space - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Re: patch review : Add ability to constrain backend temporary file space
Date
Msg-id BANLkTi=YbuHDjexdua+dNmNYdqaEev4mdQ@mail.gmail.com
Whole thread Raw
In response to Re: Re: patch review : Add ability to constrain backend temporary file space  (Cédric Villemain <cedric.villemain.debian@gmail.com>)
Responses Re: Re: patch review : Add ability to constrain backend temporary file space
List pgsql-hackers
On Mon, Jun 20, 2011 at 9:15 AM, Cédric Villemain
<cedric.villemain.debian@gmail.com> wrote:
> The feature does not work exactly as expected because the write limit
> is rounded per 8kB because we write before checking. I believe if one
> write a file of 1GB in one pass (instead of repetitive 8kB increment),
> and the temp_file_limit is 0, then the server will write the 1GB
> before aborting.

Can we rearrange thing so we check first, and then write?

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Range Types and extensions
Next
From: Simon Riggs
Date:
Subject: Re: ALTER TABLE lock strength reduction patch is unsafe