Re: [COMMITTERS] pgsql: Add temp_file_limit GUC parameter to constrain temporary file sp

Tom Lane wrote:
> Bruce Momjian <bruce@momjian.us> writes:
> > Tom Lane wrote:
> >> Add temp_file_limit GUC parameter to constrain temporary file space usage.
> >> 
> >> The limit is enforced against the total amount of temp file space used by
> >> each session.
> >> 
> >> Mark Kirkwood, reviewed by C?dric Villemain and Tatsuo Ishii
> 
> > Should we document that sessions that exceed this limit generate an
> > error?  I don't see any mention of this in the docs.
> 
> Huh?  Seems like a waste of text to me.  What else would happen?

Well, if we exceed work_mem, we spill to temp disk.  If we exceed temp
disk, we error out.  Those different behaviors don't seem obvious to me.
The work_mem docs do mention is spills to disk though, so maybe it is
OK.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +