From cde6056e34ac45a3d76028deabdfa09c5404db78 Mon Sep 17 00:00:00 2001
From: Bruce Momjian
Date: Wed, 2 Feb 2005 13:41:18 +0000
Subject: Remove pgsql_tmp directory FAQ item.

---
 doc/FAQ | 34 +++++++++++-----------------------
 1 file changed, 11 insertions(+), 23 deletions(-)

(limited to 'doc/FAQ')

diff --git a/doc/FAQ b/doc/FAQ
index 81ae9fbd579..3f53e13bb57 100644
--- a/doc/FAQ
+++ b/doc/FAQ
@@ -1,7 +1,7 @@
 
                 Frequently Asked Questions (FAQ) for PostgreSQL
                                        
-   Last updated: Tue Feb 1 16:10:47 EST 2005
+   Last updated: Wed Feb 2 08:40:42 EST 2005
    
    Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
    
@@ -41,10 +41,9 @@
    3.3) How do I tune the database engine for better performance?
    3.4) What debugging features are available?
    3.5) Why do I get "Sorry, too many clients" when trying to connect?
-   3.6) What is in the pgsql_tmp directory?
-   3.7) Why do I need to do a dump and restore to upgrade PostgreSQL
+   3.6) Why do I need to do a dump and restore to upgrade PostgreSQL
    releases?
-   3.8) What computer hardware should I use?
+   3.7) What computer hardware should I use?
    
                            Operational Questions
                                       
@@ -430,18 +429,7 @@
    processes it can start by changing the max_connections value in
    postgresql.conf and restarting the postmaster.
    
-    3.6) What is in the pgsql_tmp directory?
-    
-   This directory contains temporary files generated by the query
-   executor. For example, if a sort needs to be done to satisfy an ORDER
-   BY and the sort requires more space than the backend's -S parameter
-   allows, then temporary files are created here to hold the extra data.
-   
-   The temporary files are usually deleted automatically, but might
-   remain if a backend crashes during a sort. A stop and restart of the
-   postmaster will remove files from those directories.
-   
-    3.7) Why do I need to do a dump and restore to upgrade between major
+    3.6) Why do I need to do a dump and restore to upgrade between major
     PostgreSQL releases?
     
    The PostgreSQL team makes only small changes between minor releases,
@@ -452,7 +440,7 @@
    files. A dump outputs data in a generic format that can then be loaded
    in using the new internal format.
    
-    3.8) What computer hardware should I use?
+    3.7) What computer hardware should I use?
     
    Because PC hardware is mostly compatible, people tend to believe that
    all PC hardware is of equal quality. It is not. ECC RAM, SCSI, and
@@ -651,12 +639,12 @@
    
     4.10) What is the difference between the various character types?
     
-       Type    Internal Name                    Notes
-    VARCHAR(n) varchar       size specifies maximum length, no padding
-    CHAR(n)    bpchar        blank padded to the specified fixed length
-    TEXT       text          no specific upper limit on length
-    BYTEA      bytea         variable-length byte array (null-byte safe)
-    "char"     char          one character
+        Type    Internal Name                    Notes
+     VARCHAR(n) varchar       size specifies maximum length, no padding
+     CHAR(n)    bpchar        blank padded to the specified fixed length
+     TEXT       text          no specific upper limit on length
+     BYTEA      bytea         variable-length byte array (null-byte safe)
+     "char"     char          one character
    
    You will see the internal name when examining system catalogs and in
    some error messages.
-- 
cgit v1.2.3