diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2011-07-17 14:19:31 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2011-07-17 14:19:31 -0400 |
| commit | 23e5b16c71f2706978c5f54aabd28ed23a54b6a5 (patch) | |
| tree | 08a53d309e4839fe01b6bc07ae27ec18f1ce7f6d /doc/src | |
| parent | 1bc16a946008a7cbb33a9a06a7c6765a807d7f59 (diff) | |
| download | postgresql-23e5b16c71f2706978c5f54aabd28ed23a54b6a5.tar.gz postgresql-23e5b16c71f2706978c5f54aabd28ed23a54b6a5.zip | |
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
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/config.sgml | 33 |
1 files changed, 32 insertions, 1 deletions
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; </variablelist> </sect2> + <sect2 id="runtime-config-resource-disk"> + <title>Disk</title> + + <variablelist> + <varlistentry id="guc-temp-file-limit" xreflabel="temp_file_limit"> + <term><varname>temp_file_limit</varname> (<type>integer</type>)</term> + <indexterm> + <primary><varname>temp_file_limit</> configuration parameter</primary> + </indexterm> + <listitem> + <para> + 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 <literal>-1</> (the + default) means no limit. + Only superusers can change this setting. + </para> + <para> + This setting constrains the total space used at any instant by all + temporary files used by a given <productname>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 <emphasis>not</emphasis> count against this limit. + </para> + </listitem> + </varlistentry> + + </variablelist> + </sect2> + <sect2 id="runtime-config-resource-kernel"> <title>Kernel Resource Usage</title> - <variablelist> + <variablelist> <varlistentry id="guc-max-files-per-process" xreflabel="max_files_per_process"> <term><varname>max_files_per_process</varname> (<type>integer</type>)</term> <indexterm> |