pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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>


view thread (95+ messages)  latest in thread

Message-ID: <508f2fb1764c3bd518ee96a4f2247d6f@xs4all.nl>
Permalink:  ../508f2fb1764c3bd518ee96a4f2247d6f@xs4all.nl/
Also on:    postgresql.org/message-id/508f2fb1764c3bd518ee96a4f2247d6f@xs4all.nl

 ·  · 

reply

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