From 8e2216db6c32c62a7c1de8857e2057ecb8f9140c Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Wed, 2 Feb 2005 13:42:02 +0000 Subject: [PATCH] Backpatch FAQ to 8.0.X. --- doc/FAQ | 36 ++++++++++++------------------------ doc/src/FAQ/FAQ.html | 38 +++++++++++++------------------------- 2 files changed, 25 insertions(+), 49 deletions(-) diff --git a/doc/FAQ b/doc/FAQ index 58842e75b90..3f53e13bb57 100644 --- a/doc/FAQ +++ b/doc/FAQ @@ -1,7 +1,7 @@ Frequently Asked Questions (FAQ) for PostgreSQL - Last updated: Mon Jan 31 21:40:28 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 @@ -378,7 +377,7 @@ Hardware Selection The effect of hardware on performance is detailed in http://candle.pha.pa.us/main/writings/pgsql/hw_performance/inde - x.html. + x.html and http://www.powerpostgresql.com/PerfList/. 3.4) What debugging features are available? @@ -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. diff --git a/doc/src/FAQ/FAQ.html b/doc/src/FAQ/FAQ.html index b0ccf2853f3..14ec635d850 100644 --- a/doc/src/FAQ/FAQ.html +++ b/doc/src/FAQ/FAQ.html @@ -10,7 +10,7 @@ alink="#0000ff">

Frequently Asked Questions (FAQ) for PostgreSQL

-

Last updated: Mon Jan 31 21:40:28 EST 2005

+

Last updated: Wed Feb 2 08:40:42 EST 2005

Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) @@ -61,11 +61,9 @@ 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 + 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

@@ -507,7 +505,9 @@
The effect of hardware on performance is detailed in - http://candle.pha.pa.us/main/writings/pgsql/hw_performance/index.html. + http://candle.pha.pa.us/main/writings/pgsql/hw_performance/index.html and + + http://www.powerpostgresql.com/PerfList/.

@@ -571,19 +571,7 @@ 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 +

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, @@ -594,7 +582,7 @@ 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 @@ -670,7 +658,7 @@ table, and a database?

These are the limits:

-
+
@@ -683,8 +671,7 @@ on column types
Maximum size for a database?unlimited (32 TB databases exist)
Maximum number of indexes on a table?unlimited
-
-
+

Of course, these are not actually unlimited, but limited to available disk space and memory/swap space. Performance may suffer @@ -835,7 +822,7 @@ table?unlimited

4.10) What is the difference between the various character types?

-
+
(null-byte safe)
TypeInternal NameNotes
VARCHAR(n)varcharsize specifies maximum @@ -848,7 +835,8 @@ length
"char"charone character
-
+ +

You will see the internal name when examining system catalogs and in some error messages.

-- 2.39.5