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

Commit860d507

Browse files
committed
Updates from Ian Barwick.
Update FAQ with new URL's for site.
1 parent8a10119 commit860d507

File tree

2 files changed

+29
-31
lines changed

2 files changed

+29
-31
lines changed

‎doc/FAQ‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
11

22
Frequently Asked Questions (FAQ) for PostgreSQL
33

4-
Last updated: Fri Dec 24 12:13:41 EST 2004
4+
Last updated: Fri Dec 24 12:18:49 EST 2004
55

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

‎doc/src/FAQ/FAQ.html‎

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

13-
<P>Last updated:Wed Dec15 20:06:34 EST 2004</P>
13+
<P>Last updated:Fri Dec24 12:18:49 EST 2004</P>
1414

1515
<P>Current maintainer: Bruce Momjian (<Ahref=
1616
"mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>)<BR>
1717
</P>
1818

1919
<P>The most recent version of this document can be viewed at<Ahref=
20-
"http://www.PostgreSQL.org/docs/faqs/FAQ.html">http://www.PostgreSQL.org/docs/faqs/FAQ.html</A>.</P>
20+
"http://www.postgresql.org/files/documentation/faqs/FAQ.html">
21+
http://www.postgresql.org/files/documentation/faqs/FAQ.html</A>.</P>
2122

2223
<P>Platform-specific questions are answered at<Ahref=
23-
"http://www.PostgreSQL.org/docs/index.html">http://www.PostgreSQL.org/docs/index.html</A>.</P>
24+
"http://www.postgresql.org/docs/faq/">
25+
http://www.postgresql.org/docs/faq/</A>.</P>
2426
<HR>
2527

2628
<H2align="center">General Questions</H2>
@@ -177,7 +179,8 @@ <H4><A name="1.1">1.1</A>) What is PostgreSQL? How is it pronounced?</H4>
177179
responsible for all development of PostgreSQL. It is a community
178180
project and is not controlled by any company. To get involved, see
179181
the developer's FAQ at<Ahref=
180-
"http://www.PostgreSQL.org/docs/faqs/FAQ_DEV.html">http://www.PostgreSQL.org/docs/faqs/FAQ_DEV.html</A>
182+
"http://www.postgresql.org/files/documentation/faqs/FAQ_DEV.html">
183+
http://www.postgresql.org/files/documentation/faqs/FAQ_DEV.html</A>
181184
</P>
182185

183186
<P>The authors of PostgreSQL 1.01 were Andrew Yu and Jolly Chen.
@@ -339,8 +342,9 @@ <H4><A name="1.8">1.8</A>) What documentation is available?</H4>
339342
href=
340343
"http://techdocs.PostgreSQL.org/">http://techdocs.PostgreSQL.org/</A>.</P>
341344

342-
<P><I>psql</I> has some nice \d commands to show information about
343-
types, operators, functions, aggregates, etc.</P>
345+
<P>The command line client program<I>psql</I> has some \d commands to show
346+
information about types, operators, functions, aggregates, etc. - use \? to
347+
display the available commands.</P>
344348

345349
<P>Our web site contains even more documentation.</P>
346350

@@ -398,8 +402,8 @@ <H4><A name="1.12">1.12</A>) How do I join the development
398402
<H4><Aname="1.13">1.13</A>) How do I submit a bug report?</H4>
399403

400404
<P>Visit the PostgreSQL bug form at<Ahref=
401-
"http://www.postgresql.org/bugform.html">
402-
http://www.postgresql.org/bugform.html</A>.</P>
405+
"http://www.postgresql.org/support/submitbug">
406+
http://www.postgresql.org/support/submitbug</A>.</P>
403407

404408
<P>Also check out our ftp site<Ahref=
405409
"ftp://ftp.PostgreSQL.org/pub">ftp://ftp.PostgreSQL.org/pub</A> to
@@ -425,21 +429,15 @@ <H4><A name="1.14">1.14</A>) How does PostgreSQL compare to other
425429

426430
<DT><B>Performance</B></DT>
427431

428-
<DD>PostgreSQL hasperformancesimilar to other commercial and
429-
open source databases.it is faster for some things, slower for
432+
<DD>PostgreSQL'sperformanceis comparable to other commercial and
433+
open source databases.It is faster for some things, slower for
430434
others. In comparison to MySQL or leaner database systems, we are
431435
faster for multiple users, complex queries, and a read/write query
432436
load. MySQL is faster for simple SELECT queries done by a few users.
433437
Of course, MySQL does not have most of the features mentioned in the
434438
<I>Features</I> section above. We are built for reliability and
435439
features, and we continue to improve performance in every
436-
release. There is an interesting Web page comparing PostgreSQL to
437-
MySQL at<Ahref="http://openacs.org/philosophy/why-not-mysql.html">
438-
http://openacs.org/philosophy/why-not-mysql.html</A> Also, MySQL is
439-
is a company that distributes its products via open source, and requires
440-
a commercial license for close-source software, not an
441-
open source development community like PostgreSQL.<BR>
442-
440+
release.<BR>
443441
<BR>
444442
</DD>
445443

@@ -498,12 +496,12 @@ <H4><A name="1.15">1.15</A>) How can I financially assist
498496
"contributions" item is solely to support the PostgreSQL project
499497
and does not fund any specific company. If you prefer, you can also
500498
send a check to the contact address.</P>
501-
<HR>
502499

503-
<P>Also, if you have a success story about PostgreSQL, pleasesubmit
504-
it to our advocacysite at<ahref="http://advocacy.postgresql.org">
505-
http://advocacy.postgresql.org</a>.</P>
500+
<P>Also, if you have a success story about PostgreSQL, pleaseemail
501+
it to our advocacylist at<ahref="mailto:pgsql-advocacy@postgresql.org">
502+
pgsql-advocacy@postgresql.org</a>.</P>
506503

504+
<HR>
507505

508506
<H2align="center">User Client Questions</H2>
509507

@@ -544,7 +542,7 @@ <H4><A name="2.3">2.3</A>) Does PostgreSQL have a graphical user
544542

545543
<P>Yes, there are several graphical interfaces to PostgreSQL available.
546544
These include PgAccess<ahref="http://www.pgaccess.org">
547-
http://www.pgaccess.org</a>),PgAdmin III (<a
545+
http://www.pgaccess.org</a>),pgAdmin III (<a
548546
href="http://www.pgadmin.org">http://www.pgadmin.org</a>, RHDB Admin (<a
549547
href="http://sources.redhat.com/rhdb/">http://sources.redhat.com/rhdb/
550548
</a>), TORA (<ahref="http://www.globecom.net/tora/">http://www.globecom.net/tora/
@@ -674,9 +672,9 @@ <H4><A name="3.6">3.6</A>) How do I tune the database engine for
674672
kernel's limit on shared memory space. Each buffer is 8K and the
675673
default is 1000 buffers.</P>
676674

677-
<P>You can also use the<I>sort_mem</I>and<I>work_mem</I> options
678-
to increase the maximum amount of memory used by the backend processes
679-
for each temporary sort. The default is 1024 (i.e. 1MB).</P>
675+
<P>You can also use the<I>sort_mem</I>(from PostgreSQL 8.0:<I>work_mem</I>)
676+
optionsto increase the maximum amount of memory used by the backend
677+
processesfor each temporary sort. The default is 1024 (i.e. 1MB).</P>
680678

681679
<P>You can also use the<SMALL>CLUSTER</SMALL> command to group
682680
data in tables to match an index. See the<SMALL>CLUSTER</SMALL>
@@ -1170,14 +1168,14 @@ <H4><A name="4.15.2">4.15.2</A>) How do I get the value of a
11701168
execute("INSERT INTO person (name) VALUES ('Blaise Pascal')");
11711169
new_id = execute("SELECT currval('person_id_seq')");
11721170
</PRE>
1173-
1174-
Finally, you could use the<Ahref="#4.16"><SMALL>OID</SMALL></A>
1171+
1172+
<P>Finally, you could use the<Ahref="#4.16"><SMALL>OID</SMALL></A>
11751173
returned from the<SMALL>INSERT</SMALL> statement to look up the
11761174
default value, though this is probably the least portable approach,
11771175
and the oid value will wrap around when it reaches 4 billion.
1178-
In Perl, using DBI withEdmund Mergl'sDBD::Pg module, the oid
1179-
value is madeavailable via<I>$sth-&gt;{pg_oid_status}</I> after
1180-
<I>$sth-&gt;execute()</I>.
1176+
In Perl, using DBI withtheDBD::Pg module, the oid value is made
1177+
available via<I>$sth-&gt;{pg_oid_status}</I> after
1178+
<I>$sth-&gt;execute()</I>.</P>
11811179

11821180
<H4><Aname="4.15.3">4.15.3</A>) Doesn't<I>currval()</I>
11831181
lead to a race condition with other users?</H4>

0 commit comments

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