summaryrefslogtreecommitdiff
path: root/doc/src/FAQ/FAQ.html
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2005-02-02 13:41:18 +0000
committerBruce Momjian <bruce@momjian.us>2005-02-02 13:41:18 +0000
commitcde6056e34ac45a3d76028deabdfa09c5404db78 (patch)
tree14cc92f6a636a587584056df52e5c4413926ed23 /doc/src/FAQ/FAQ.html
parent73f630500bcb3034f65dc5af6cb410b3221fe717 (diff)
downloadpostgresql-cde6056e34ac45a3d76028deabdfa09c5404db78.tar.gz
Remove pgsql_tmp directory FAQ item.
Diffstat (limited to 'doc/src/FAQ/FAQ.html')
-rw-r--r--doc/src/FAQ/FAQ.html34
1 files changed, 10 insertions, 24 deletions
diff --git a/doc/src/FAQ/FAQ.html b/doc/src/FAQ/FAQ.html
index 860ab838cd..14ec635d85 100644
--- a/doc/src/FAQ/FAQ.html
+++ b/doc/src/FAQ/FAQ.html
@@ -10,7 +10,7 @@
alink="#0000ff">
<H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1>
- <P>Last updated: Tue Feb 1 16:10:47 EST 2005</P>
+ <P>Last updated: Wed Feb 2 08:40:42 EST 2005</P>
<P>Current maintainer: Bruce Momjian (<A href=
"mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>)
@@ -61,11 +61,9 @@
<A href="#3.4">3.4</A>) What debugging features are available?<BR>
<A href="#3.5">3.5</A>) Why do I get <I>"Sorry, too many
clients"</I> when trying to connect?<BR>
- <A href="#3.6">3.6</A>) What is in the <I>pgsql_tmp</I>
- directory?<BR>
- <A href="#3.7">3.7</A>) Why do I need to do a dump and restore
+ <A href="#3.6">3.6</A>) Why do I need to do a dump and restore
to upgrade PostgreSQL releases?<BR>
- <A href="#3.8">3.8</A>) What computer hardware should I use?<BR>
+ <A href="#3.7">3.7</A>) What computer hardware should I use?<BR>
<H2 align="center">Operational Questions</H2>
@@ -573,19 +571,7 @@
<I>max_connections</I> value in <I>postgresql.conf</I> and
restarting the <I>postmaster</I>.</P>
- <H4><A name="3.6">3.6</A>) What is in the <I>pgsql_tmp</I> directory?</H4>
-
- <P>This directory contains temporary files generated by the query
- executor. For example, if a sort needs to be done to satisfy an
- <SMALL>ORDER BY</SMALL> and the sort requires more space than the
- backend's <I>-S</I> parameter allows, then temporary files are created
- here to hold the extra data.</P>
-
- <P>The temporary files are usually deleted automatically, but might
- remain if a backend crashes during a sort. A stop and restart of the
- <I>postmaster</I> will remove files from those directories.</P>
-
- <H4><A name="3.7">3.7</A>) Why do I need to do a dump and restore
+ <H4><A name="3.6">3.6</A>) Why do I need to do a dump and restore
to upgrade between major PostgreSQL releases?</H4>
<P>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.</P>
- <H4><A name="3.8">3.8</A>) What computer hardware should I use?</H4>
+ <H4><A name="3.7">3.7</A>) What computer hardware should I use?</H4>
<P>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?</H4>
<P>These are the limits:</P>
-<CENTER>
+<BLOCKQUOTE>
<TABLE BORDER=1>
<TR><TD>Maximum size for a database?</TD><TD>unlimited (32 TB databases
exist)</TD></TR>
@@ -685,8 +671,7 @@ on column types</TD></TR>
<TR><TD>Maximum number of indexes on a
table?</TD><TD>unlimited</TD></TR>
</TABLE>
-</CENTER>
-<BR>
+</BLOCKQUOTE>
<P>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?</TD><TD>unlimited</TD></TR>
<H4><A name="4.10">4.10</A>) What is the difference between the
various character types?</H4>
-<CENTER>
+<BLOCKQUOTE>
<TABLE BORDER=1>
<TR><TH>Type</TH><TH>Internal Name</TH><TH>Notes</TH></TR>
<TR><TD>VARCHAR(n)</TD><TD>varchar</TD><TD>size specifies maximum
@@ -850,7 +835,8 @@ length</TD></TR>
(null-byte safe)</TD></TR>
<TR><TD>"char"</TD><TD>char</TD><TD>one character</TD></TR>
</TABLE>
-</CENTER>
+</BLOCKQUOTE>
+
<P>You will see the internal name when examining system catalogs
and in some error messages.</P>