Tom Lane wrote: > Bruce Momjian <br...@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 <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
