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. +