attached as patch. It contains some minor corrections / clarifications. Note:
* store.pgsql.com (sec. 1.15) does not work, although it is linked from
http://www.pgsql.com/ - is it dead, or just resting?
* I've taken the liberty of removing this section:
"There is an interesting Web page comparing PostgreSQL to
MySQL at http://openacs.org/philosophy/why-not-mysql.html";>
http://openacs.org/philosophy/why-not-mysql.html Also, MySQL is
is a company that distributes its products via open source, and requires
a commercial license for close-source software, not an
open source development community like PostgreSQL."
as the page linked to is hopelessly outdated (May 2000) and the
reference to the license model is IMHO not directly relevant to
the context (performance).
Ian Barwick
Index: FAQ.html
===
RCS file: /projects/cvsroot/pgsql/doc/src/FAQ/FAQ.html,v
retrieving revision 1.235
diff -c -r1.235 FAQ.html
*** FAQ.html 16 Dec 2004 01:08:23 - 1.235
--- FAQ.html 17 Dec 2004 23:36:56 -
***
*** 339,346
href=
"http://techdocs.PostgreSQL.org/";>http://techdocs.PostgreSQL.org/.
! psql has some nice \d commands to show information about
! types, operators, functions, aggregates, etc.
Our web site contains even more documentation.
--- 339,347
href=
"http://techdocs.PostgreSQL.org/";>http://techdocs.PostgreSQL.org/.
! The command line client program psql has some \d commands to show
! information about types, operators, functions, aggregates, etc. - use \? to
! display the available commands.
Our web site contains even more documentation.
***
*** 425,445
Performance
! PostgreSQL has performance similar to other commercial and
! open source databases. it is faster for some things, slower for
others. In comparison to MySQL or leaner database systems, we are
faster for multiple users, complex queries, and a read/write query
load. MySQL is faster for simple SELECT queries done by a few users.
Of course, MySQL does not have most of the features mentioned in the
Features section above. We are built for reliability and
features, and we continue to improve performance in every
! release. There is an interesting Web page comparing PostgreSQL to
! MySQL at http://openacs.org/philosophy/why-not-mysql.html";>
! http://openacs.org/philosophy/why-not-mysql.html Also, MySQL is
! is a company that distributes its products via open source, and requires
! a commercial license for close-source software, not an
! open source development community like PostgreSQL.
!
--- 426,440
Performance
! PostgreSQL's performance is comparable to other commercial and
! open source databases. It is faster for some things, slower for
others. In comparison to MySQL or leaner database systems, we are
faster for multiple users, complex queries, and a read/write query
load. MySQL is faster for simple SELECT queries done by a few users.
Of course, MySQL does not have most of the features mentioned in the
Features section above. We are built for reliability and
features, and we continue to improve performance in every
! release.
***
*** 498,509
"contributions" item is solely to support the PostgreSQL project
and does not fund any specific company. If you prefer, you can also
send a check to the contact address.
-
Also, if you have a success story about PostgreSQL, please submit
it to our advocacy site at http://advocacy.postgresql.org";>
http://advocacy.postgresql.org.
User Client Questions
--- 493,504
"contributions" item is solely to support the PostgreSQL project
and does not fund any specific company. If you prefer, you can also
send a check to the contact address.
Also, if you have a success story about PostgreSQL, please submit
it to our advocacy site at http://advocacy.postgresql.org";>
http://advocacy.postgresql.org.
+
User Client Questions
***
*** 544,550
Yes, there are several graphical interfaces to PostgreSQL available.
These include PgAccess http://www.pgaccess.org";>
! http://www.pgaccess.org), PgAdmin III (http://www.pgadmin.org";>http://www.pgadmin.org, RHDB Admin (http://sources.redhat.com/rhdb/";>http://sources.redhat.com/rhdb/
), TORA (http://www.globecom.net/tora/";>http://www.globecom.net/tora/
--- 539,545
Yes, there are several graphical interfaces to PostgreSQL available.
These include PgAccess http://www.pgaccess.org";>
! http://www.pgaccess.org), pgAdmin III (http://www.pgadmin.org";>http://www.
