Skip to content

Commit 3bb2761

Browse files
dmpgprodmpgpro
committed
Update intro.sgml from 9.5
1 parent 943cd56 commit 3bb2761

File tree

1 file changed

+67
-15
lines changed

1 file changed

+67
-15
lines changed

‎doc/src/sgml/intro.sgml

Lines changed: 67 additions & 15 deletions
Original file line numberDiff line numberDiff line change
@@ -5,20 +5,20 @@
55

66
<para>
77
This book is the official documentation of
8-
<productname>PostgreSQL</productname>. It has been written by the
9-
<productname>PostgreSQL</productname> developers and other
8+
<productname>&productname;</productname>. It has been written by the
9+
<productname>&productname;</productname> developers and other
1010
volunteers in parallel to the development of the
11-
<productname>PostgreSQL</productname> software. It describes all
11+
<productname>&productname;</productname> software. It describes all
1212
the functionality that the current version of
13-
<productname>PostgreSQL</productname> officially supports.
13+
<productname>&productname;</productname> officially supports.
1414
</para>
1515

1616
<para>
1717
To make the large amount of information about
18-
<productname>PostgreSQL</productname> manageable, this book has been
18+
<productname>&productname;</productname> manageable, this book has been
1919
organized in several parts. Each part is targeted at a different
2020
class of users, or at users in different stages of their
21-
<productname>PostgreSQL</productname> experience:
21+
<productname>&productname;</productname> experience:
2222

2323
<itemizedlist>
2424
<listitem>
@@ -32,23 +32,23 @@
3232
<xref linkend="sql"> documents the <acronym>SQL</acronym> query
3333
language environment, including data types and functions, as well
3434
as user-level performance tuning. Every
35-
<productname>PostgreSQL</> user should read this.
35+
<productname>&productname;</> user should read this.
3636
</para>
3737
</listitem>
3838

3939
<listitem>
4040
<para>
4141
<xref linkend="admin"> describes the installation and
4242
administration of the server. Everyone who runs a
43-
<productname>PostgreSQL</productname> server, be it for private
43+
<productname>&productname;</productname> server, be it for private
4444
use or for others, should read this part.
4545
</para>
4646
</listitem>
4747

4848
<listitem>
4949
<para>
5050
<xref linkend="client-interfaces"> describes the programming
51-
interfaces for <productname>PostgreSQL</productname> client
51+
interfaces for <productname>&productname;</productname> client
5252
programs.
5353
</para>
5454
</listitem>
@@ -75,18 +75,19 @@
7575
<listitem>
7676
<para>
7777
<xref linkend="internals"> contains assorted information that might be of
78-
use to <productname>PostgreSQL</> developers.
78+
use to <productname>&productname;</> developers.
7979
</para>
8080
</listitem>
8181
</itemizedlist>
8282
</para>
8383

8484
<sect1 id="intro-whatis">
85-
<title> What is <productname>PostgreSQL</productname>?</title>
85+
<title> What is <productname>&productname;</productname>?</title>
8686

8787
<para>
88-
<productname>PostgreSQL</productname> is an object-relational
89-
database management system (<acronym>ORDBMS</acronym>) based on
88+
<productname>&productname;</productname> is an object-relational
89+
database management system (<acronym>ORDBMS</acronym>), developed by Postgres Professional on the base of<ulink
90+
url="http://postgresql.org"><productname>PostgreSQL</productname></ulink>, which is in turn based on
9091
<ulink url="http://db.cs.berkeley.edu/postgres.html">
9192
<productname>POSTGRES, Version 4.2</productname></ulink>,
9293
developed at the University of California at Berkeley Computer Science
@@ -120,7 +121,7 @@
120121
</listitem>
121122
</itemizedlist>
122123

123-
Also, <productname>PostgreSQL</productname> can be extended by the
124+
Also, <productname>&productname;</productname>, as well as <productname>PostgreSQL</productname>, can be extended by the
124125
user in many ways, for example by adding new
125126

126127
<itemizedlist spacing="compact">
@@ -147,10 +148,61 @@
147148

148149
<para>
149150
And because of the liberal license,
150-
<productname>PostgreSQL</productname> can be used, modified, and
151+
<productname>&productname;</productname> and <productname>PostgreSQL</productname> can be used, modified, and
151152
distributed by anyone free of charge for any purpose, be it
152153
private, commercial, or academic.
153154
</para>
155+
</sect1>
156+
157+
<sect1 id="intro-pgpro-vs-pg">
158+
<title> Difference between <productname>&productname;</productname> and PostgreSQL</title>
159+
160+
<para>
161+
<productname>&productname;</productname> is the most actual PostgreSQL version with some additional patches applied and extensions added.
162+
Mostly, these are patches already accepted by the PostgreSQL community and committed into PostgreSQL.
163+
Also there some patches and extensions developed by Postgres Professional.
164+
Users of <productname>&productname;</productname> thus have early access to some important features and fixes.
165+
</para>
166+
167+
<para>Currently the difference between <productname>&productname;</productname> and PostgreSQL is the following:
168+
<itemizedlist spacing="compact">
169+
<listitem>
170+
<simpara>Performance improvement on multicore systems (buffer manager and locks optimization).</simpara>
171+
</listitem>
172+
<listitem>
173+
<simpara>Full text search improvements: phrase search, hunspell morphology,
174+
some dictionaries are bundled with distribution and can be enabled by a single SQL statement,
175+
<application>shared_ispell</application> allowing to store dictionaries in shared memory.</simpara>
176+
</listitem>
177+
<listitem>
178+
<simpara>Covering indexes.</simpara>
179+
</listitem>
180+
<listitem>
181+
<simpara><application>libicu</application> support on all platforms, providing platform-independent sort for various locales.</simpara>
182+
</listitem>
183+
<listitem>
184+
<simpara><application>pg_trgm</application> module supporting fuzzy string comparison and substring search.</simpara>
185+
</listitem>
186+
<listitem>
187+
<simpara>Improved <application>pageinspect</application> module provides access to internal data storage structure.</simpara>
188+
</listitem>
189+
<listitem>
190+
<simpara><application>sr_plan</application> module allows to save and restore query plans.</simpara>
191+
</listitem>
192+
<listitem>
193+
<simpara><application>dump_stat</application> module allowing to save and restore database statistics when dumping/restoring the database. </simpara>
194+
</listitem>
195+
<listitem>
196+
<simpara><application>jsquery</application> module provides a specific language for effective index-supported querying of JSONB data.</simpara>
197+
</listitem>
198+
</itemizedlist>
199+
</para>
200+
201+
<para>
202+
<productname>&productname;</productname> releases are following the PostgreSQL releases, though sometimes occur more frequently.
203+
The <productname>&productname;</productname> versioning scheme is based on the PostgreSQL one and has an additional decimal place.
204+
</para>
205+
154206
</sect1>
155207

156208
&history;

0 commit comments

Comments
 (0)