diff options
Diffstat (limited to 'doc/FAQ')
| -rw-r--r-- | doc/FAQ | 34 |
1 files changed, 11 insertions, 23 deletions
@@ -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. |