On sön, 2011-07-17 at 18:39 -0400, Bruce Momjian wrote: > 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.
Sounds like it would be good to document the behavior if the limit is exceeded in each case. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
