From 23e5b16c71f2706978c5f54aabd28ed23a54b6a5 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Sun, 17 Jul 2011 14:19:31 -0400 Subject: Add temp_file_limit GUC parameter to constrain temporary file space usage. MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit 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 --- doc/src/sgml/config.sgml | 33 ++++++++++++++++++++++++++++++++- 1 file changed, 32 insertions(+), 1 deletion(-) (limited to 'doc/src') diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 842558d6735..afa087a3465 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -1025,10 +1025,41 @@ SET ENABLE_SEQSCAN TO OFF; + + Disk + + + + temp_file_limit (integer) + + temp_file_limit configuration parameter + + + + Specifies the maximum amount of disk space that a session can use + for temporary files, such as sort and hash temporary files, or the + storage file for a held cursor. + The value is specified in kilobytes, and -1 (the + default) means no limit. + Only superusers can change this setting. + + + This setting constrains the total space used at any instant by all + temporary files used by a given PostgreSQL session. + It should be noted that disk space used for explicit temporary + tables, as opposed to temporary files used behind-the-scenes in query + execution, does not count against this limit. + + + + + + + Kernel Resource Usage - + max_files_per_process (integer) -- cgit v1.2.3