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/src/FAQ/FAQ.html | 34 ++++++++++------------------------ 1 file changed, 10 insertions(+), 24 deletions(-) (limited to 'doc/src') diff --git a/doc/src/FAQ/FAQ.html b/doc/src/FAQ/FAQ.html index 860ab838cd2..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: 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) @@ -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

@@ -573,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, @@ -596,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 @@ -672,7 +658,7 @@ table, and a database?

These are the limits:

-
+
@@ -685,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 @@ -837,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 @@ -850,7 +835,8 @@ length
"char"charone character
-
+ +

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

-- cgit v1.2.3