From: Erik Rijkers <er@xs4all.nl>
To: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Justin Pryzby <pryzby@telsasoft.com>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Fabien COELHO <coelho@cri.ensmp.fr>
Cc: Jürgen Purtz <juergen@purtz.de>
Cc: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Cc: Corey Huinker <corey.huinker@gmail.com>
Cc: Roger Harkavy <rogerharkavy@gmail.com>
Cc: pgsql-hackers@postgresql.org, Michael Paquier <michael@paquier.xyz>
Subject: Re: Add A Glossary
Date: Sat, 16 May 2020 23:45:39 +0200
Message-ID: <508f2fb1764c3bd518ee96a4f2247d6f@xs4all.nl> (raw)
In-Reply-To: <20200515172619.GA31053@alvherre.pgsql>
References: <20200515172619.GA31053@alvherre.pgsql>
On 2020-05-15 19:26, Alvaro Herrera wrote:
> Applied all these suggestions, and made a few additional very small
> edits, and pushed -- better to ship what we have now in beta1, but
> further edits are still possible.
I've gone through the glossary as committed and found some more small
things; patch attached.
Thanks,
Erik Rijkers
> Other possible terms to define, including those from the tweet I linked
> to and a couple more:
>
> archive
> availability
> backup
> composite type
> common table expression
> data type
> domain
> dump
> export
> fault tolerance
> GUC
> high availability
> hot standby
> LSN
> restore
> secondary server (?)
> snapshot
> transactions per second
>
> Anybody want to try their hand at a tentative definition?
>
> --
> Álvaro Herrera https://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Attachments:
[text/x-diff] glossary-20200516.sgml.diff (4.2K, ../508f2fb1764c3bd518ee96a4f2247d6f@xs4all.nl/2-glossary-20200516.sgml.diff)
download | inline diff:--- doc/src/sgml/glossary.sgml.orig 2020-05-16 23:30:01.132290237 +0200+++ doc/src/sgml/glossary.sgml 2020-05-16 23:38:35.643371310 +0200@@ -67,7 +67,7 @@
<glossdef>
<para>
In reference to a <glossterm linkend="glossary-datum">datum</glossterm>:
- the fact that its value that cannot be broken down into smaller+ the fact that its value cannot be broken down into smaller
components.
</para>
</glossdef>
@@ -360,7 +360,7 @@
<glossterm linkend="glossary-constraint">integrity constraints</glossterm>.
Transactions may be allowed to violate some of the constraints
transiently before it commits, but if such violations are not resolved
- by the time it commits, such transaction is automatically+ by the time it commits, such a transaction is automatically
<glossterm linkend="glossary-rollback">rolled back</glossterm>.
This is one of the <acronym>ACID</acronym> properties.
</para>
@@ -649,8 +649,8 @@
<glossterm>Grant</glossterm>
<glossdef>
<para>
- An <acronym>SQL</acronym> command that is used to allow- <glossterm linkend="glossary-user">users</glossterm> or+ An <acronym>SQL</acronym> command that is used to allow a+ <glossterm linkend="glossary-user">user</glossterm> or
<glossterm linkend="glossary-role">role</glossterm> to access
specific objects within the <glossterm linkend="glossary-database">database</glossterm>.
</para>
@@ -887,7 +887,7 @@
<glossdef>
<para>
A <glossterm linkend="glossary-relation">relation</glossterm> that is
- defined in the same way that a a <glossterm linkend="glossary-view">view</glossterm>+ defined in the same way that a <glossterm linkend="glossary-view">view</glossterm>
is, but stores data in the same way that a
<glossterm linkend="glossary-table">table</glossterm> does. It cannot be
modified via <command>INSERT</command>, <command>UPDATE</command>, or
@@ -962,7 +962,7 @@
<glossdef>
<para>
In reference to a <glossterm linkend="glossary-window-function">window function</glossterm>:
- a partition is a user-defined criteria that identifies which neighboring+ a partition is a user-defined criterion that identifies which neighboring
<glossterm linkend="glossary-tuple">rows</glossterm> can be considered by the
function.
</para>
@@ -1446,8 +1446,8 @@
The system catalog resides in the schema <literal>pg_catalog</literal>.
These tables contain data in internal representation and are
not typically considered useful for user examination;
- a number of user-friendlier <glossterm linkend="glossary-view">views</glossterm>- also in schema <literal>pg_catalog</literal> offer more convenient access to+ a number of user-friendlier <glossterm linkend="glossary-view">views</glossterm>,+ also in schema <literal>pg_catalog</literal>, offer more convenient access to
some of that information, while additional tables and views
exist in schema <literal>information_schema</literal>
(see <xref linkend="information-schema" />) that expose some
@@ -1739,7 +1739,7 @@
each page stores two bits: the first one
(<literal>all-visible</literal>) indicates that all tuples
in the page are visible to all transactions. The second one
- (<literal>all-frozen</literal>) indicate that all tuples+ (<literal>all-frozen</literal>) indicates that all tuples
in the page are marked frozen.
</para>
</glossdef>
@@ -1755,7 +1755,7 @@
<glossdef>
<para>
A process that saves copies of <glossterm linkend="glossary-wal-file">WAL files</glossterm>
- for the purposes of creating backups or keeping+ for the purpose of creating backups or keeping
<glossterm linkend="glossary-replica">replicas</glossterm> current.
</para>
<para>
@@ -1777,7 +1777,7 @@
and are written in sequential order, interspersing changes
as they occur in multiple simultaneous sessions.
If the system crashes, the files are read in order, and each of the
- changes is replayed to restore the system to the state as it was+ changes is replayed to restore the system to the state it was in
before the crash.
</para>
<para>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: er@xs4all.nl, alvherre@2ndquadrant.com, pryzby@telsasoft.com, laurenz.albe@cybertec.at, coelho@cri.ensmp.fr, juergen@purtz.de, peter.eisentraut@2ndquadrant.com, corey.huinker@gmail.com, rogerharkavy@gmail.com, michael@paquier.xyz
Subject: Re: Add A Glossary
In-Reply-To: <508f2fb1764c3bd518ee96a4f2247d6f@xs4all.nl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox