diff options
author | Bruce Momjian <bruce@momjian.us> | 2005-02-02 13:41:18 +0000 |
---|---|---|
committer | Bruce Momjian <bruce@momjian.us> | 2005-02-02 13:41:18 +0000 |
commit | cde6056e34ac45a3d76028deabdfa09c5404db78 (patch) | |
tree | 14cc92f6a636a587584056df52e5c4413926ed23 /doc/src/FAQ/FAQ.html | |
parent | 73f630500bcb3034f65dc5af6cb410b3221fe717 (diff) | |
download | postgresql-cde6056e34ac45a3d76028deabdfa09c5404db78.tar.gz |
Remove pgsql_tmp directory FAQ item.
Diffstat (limited to 'doc/src/FAQ/FAQ.html')
-rw-r--r-- | doc/src/FAQ/FAQ.html | 34 |
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> |