Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitcde6056

Browse files
committed
Remove pgsql_tmp directory FAQ item.
1 parent73f6305 commitcde6056

File tree

2 files changed

+21
-47
lines changed

2 files changed

+21
-47
lines changed

‎doc/FAQ‎

Lines changed: 11 additions & 23 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
11

22
Frequently Asked Questions (FAQ) for PostgreSQL
33

4-
Last updated:Tue Feb1 16:10:47 EST 2005
4+
Last updated:Wed Feb2 08:40:42 EST 2005
55

66
Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
77

@@ -41,10 +41,9 @@
4141
3.3) How do I tune the database engine for better performance?
4242
3.4) What debugging features are available?
4343
3.5) Why do I get "Sorry, too many clients" when trying to connect?
44-
3.6) What is in the pgsql_tmp directory?
45-
3.7) Why do I need to do a dump and restore to upgrade PostgreSQL
44+
3.6) Why do I need to do a dump and restore to upgrade PostgreSQL
4645
releases?
47-
3.8) What computer hardware should I use?
46+
3.7) What computer hardware should I use?
4847

4948
Operational Questions
5049

@@ -430,18 +429,7 @@
430429
processes it can start by changing the max_connections value in
431430
postgresql.conf and restarting the postmaster.
432431

433-
3.6) What is in the pgsql_tmp directory?
434-
435-
This directory contains temporary files generated by the query
436-
executor. For example, if a sort needs to be done to satisfy an ORDER
437-
BY and the sort requires more space than the backend's -S parameter
438-
allows, then temporary files are created here to hold the extra data.
439-
440-
The temporary files are usually deleted automatically, but might
441-
remain if a backend crashes during a sort. A stop and restart of the
442-
postmaster will remove files from those directories.
443-
444-
3.7) Why do I need to do a dump and restore to upgrade between major
432+
3.6) Why do I need to do a dump and restore to upgrade between major
445433
PostgreSQL releases?
446434

447435
The PostgreSQL team makes only small changes between minor releases,
@@ -452,7 +440,7 @@
452440
files. A dump outputs data in a generic format that can then be loaded
453441
in using the new internal format.
454442

455-
3.8) What computer hardware should I use?
443+
3.7) What computer hardware should I use?
456444

457445
Because PC hardware is mostly compatible, people tend to believe that
458446
all PC hardware is of equal quality. It is not. ECC RAM, SCSI, and
@@ -651,12 +639,12 @@
651639

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

654-
Type Internal Name Notes
655-
VARCHAR(n) varchar size specifies maximum length, no padding
656-
CHAR(n) bpchar blank padded to the specified fixed length
657-
TEXT text no specific upper limit on length
658-
BYTEA bytea variable-length byte array (null-byte safe)
659-
"char" char one character
642+
Type Internal Name Notes
643+
VARCHAR(n) varchar size specifies maximum length, no padding
644+
CHAR(n) bpchar blank padded to the specified fixed length
645+
TEXT text no specific upper limit on length
646+
BYTEA bytea variable-length byte array (null-byte safe)
647+
"char" char one character
660648

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

‎doc/src/FAQ/FAQ.html‎

Lines changed: 10 additions & 24 deletions
Original file line numberDiff line numberDiff line change
@@ -10,7 +10,7 @@
1010
alink="#0000ff">
1111
<H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1>
1212

13-
<P>Last updated:Tue Feb1 16:10:47 EST 2005</P>
13+
<P>Last updated:Wed Feb2 08:40:42 EST 2005</P>
1414

1515
<P>Current maintainer: Bruce Momjian (<Ahref=
1616
"mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>)
@@ -61,11 +61,9 @@ <H2 align="center">Administrative Questions</H2>
6161
<Ahref="#3.4">3.4</A>) What debugging features are available?<BR>
6262
<Ahref="#3.5">3.5</A>) Why do I get<I>"Sorry, too many
6363
clients"</I> when trying to connect?<BR>
64-
<Ahref="#3.6">3.6</A>) What is in the<I>pgsql_tmp</I>
65-
directory?<BR>
66-
<Ahref="#3.7">3.7</A>) Why do I need to do a dump and restore
64+
<Ahref="#3.6">3.6</A>) Why do I need to do a dump and restore
6765
to upgrade PostgreSQL releases?<BR>
68-
<Ahref="#3.8">3.8</A>) What computer hardware should I use?<BR>
66+
<Ahref="#3.7">3.7</A>) What computer hardware should I use?<BR>
6967

7068

7169
<H2align="center">Operational Questions</H2>
@@ -573,19 +571,7 @@ <H4><A name="3.5">3.5</A>) Why do I get <I>"Sorry, too many
573571
<I>max_connections</I> value in<I>postgresql.conf</I> and
574572
restarting the<I>postmaster</I>.</P>
575573

576-
<H4><Aname="3.6">3.6</A>) What is in the<I>pgsql_tmp</I> directory?</H4>
577-
578-
<P>This directory contains temporary files generated by the query
579-
executor. For example, if a sort needs to be done to satisfy an
580-
<SMALL>ORDER BY</SMALL> and the sort requires more space than the
581-
backend's<I>-S</I> parameter allows, then temporary files are created
582-
here to hold the extra data.</P>
583-
584-
<P>The temporary files are usually deleted automatically, but might
585-
remain if a backend crashes during a sort. A stop and restart of the
586-
<I>postmaster</I> will remove files from those directories.</P>
587-
588-
<H4><Aname="3.7">3.7</A>) Why do I need to do a dump and restore
574+
<H4><Aname="3.6">3.6</A>) Why do I need to do a dump and restore
589575
to upgrade between major PostgreSQL releases?</H4>
590576

591577
<P>The PostgreSQL team makes only small changes between minor releases,
@@ -596,7 +582,7 @@ <H4><A name="3.7">3.7</A>) Why do I need to do a dump and restore
596582
data in a generic format that can then be loaded in using the new internal
597583
format.</P>
598584

599-
<H4><Aname="3.8">3.8</A>) What computer hardware should I use?</H4>
585+
<H4><Aname="3.7">3.7</A>) What computer hardware should I use?</H4>
600586

601587
<P>Because PC hardware is mostly compatible, people tend to believe that
602588
all PC hardware is of equal quality. It is not. ECC RAM, SCSI, and
@@ -672,7 +658,7 @@ <H4><A name="4.4">4.4</A>) What is the maximum size for a row, a
672658
table, and a database?</H4>
673659

674660
<P>These are the limits:</P>
675-
<CENTER>
661+
<BLOCKQUOTE>
676662
<TABLEBORDER=1>
677663
<TR><TD>Maximum size for a database?</TD><TD>unlimited (32 TB databases
678664
exist)</TD></TR>
@@ -685,8 +671,7 @@ <H4><A name="4.4">4.4</A>) What is the maximum size for a row, a
685671
<TR><TD>Maximum number of indexes on a
686672
table?</TD><TD>unlimited</TD></TR>
687673
</TABLE>
688-
</CENTER>
689-
<BR>
674+
</BLOCKQUOTE>
690675

691676
<P>Of course, these are not actually unlimited, but limited to
692677
available disk space and memory/swap space. Performance may suffer
@@ -837,7 +822,7 @@ <H4><A name="4.9">4.9</A>) In a query, how do I detect if a field
837822

838823
<H4><Aname="4.10">4.10</A>) What is the difference between the
839824
various character types?</H4>
840-
<CENTER>
825+
<BLOCKQUOTE>
841826
<TABLEBORDER=1>
842827
<TR><TH>Type</TH><TH>Internal Name</TH><TH>Notes</TH></TR>
843828
<TR><TD>VARCHAR(n)</TD><TD>varchar</TD><TD>size specifies maximum
@@ -850,7 +835,8 @@ <H4><A name="4.10">4.10</A>) What is the difference between the
850835
(null-byte safe)</TD></TR>
851836
<TR><TD>"char"</TD><TD>char</TD><TD>one character</TD></TR>
852837
</TABLE>
853-
</CENTER>
838+
</BLOCKQUOTE>
839+
854840
<P>You will see the internal name when examining system catalogs
855841
and in some error messages.</P>
856842

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp