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">
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?
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.
- -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.
-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?
-
Type Internal Name Notes (null-byte safe) VARCHAR(n) varchar size specifies maximum @@ -850,7 +835,8 @@ length "char" char one character
You will see the internal name when examining system catalogs and in some error messages.
-- cgit v1.2.3