Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jKTI8-0004z5-1f for pgsql-hackers@arkaria.postgresql.org; Fri, 03 Apr 2020 20:51:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jKTI6-0006Y1-TA for pgsql-hackers@arkaria.postgresql.org; Fri, 03 Apr 2020 20:51:50 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jKTI6-0006Xu-Ch for pgsql-hackers@lists.postgresql.org; Fri, 03 Apr 2020 20:51:50 +0000 Received: from mail-qk1-x743.google.com ([2607:f8b0:4864:20::743]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jKTI3-0006hZ-Jv for pgsql-hackers@postgresql.org; Fri, 03 Apr 2020 20:51:49 +0000 Received: by mail-qk1-x743.google.com with SMTP id o10so9547686qki.10 for ; Fri, 03 Apr 2020 13:51:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:mime-version:content-disposition :content-transfer-encoding:in-reply-to:user-agent; bh=Hgyc0nXbvyGkjLQY5RrmF48RAO42UIlXDA/UhT18RTQ=; b=HvBReCaE7LdTY9im8k3w7fg0YjFkBmdTLSeDrkS9/it6Twiex4cgJrI5Gm8Y3RjfRD k3hQUFhddoqLYm12S1XXOGGHxzo0fl+ovbvq9wAKz0SL+rxCbc3tyyb4JxpIFEF4Nlb2 pyQVr1Cty6zbN2YibwFhIrADSu4m4KnWNKuOyEWOWXxRAu21YSzpxZOFFH+8vBRUaFnC /J3DZwbC+TzHq/HGxUsnu+7FAuKqzxk0HaazPEjC1bgu4HB2Mq8WMFRESGbYur5U5jzT h7FqV0xcOdoByHekUGet2+Rupauiv4kv4cboYcw94iA6jJ7ha7zdIHPqvcCl7v0Zj6MN JX9g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:mime-version :content-disposition:content-transfer-encoding:in-reply-to :user-agent; bh=Hgyc0nXbvyGkjLQY5RrmF48RAO42UIlXDA/UhT18RTQ=; b=Gtg+vP3gJWedvS+Gu5m37Qz4TTElv0Ls9Q1fLmI+A3guJQxWFCsFhVN00T+r8fzOx9 C/vLP+kgwyxSFb1ZNX+moxGbczeKmjVv7glaLA9kKHMVXqzA80P0Ep3W0L0A3kGU2+6r z7FBYgPR90dbXoI6aVwRo3XkaGGNTn59BbRYGe8cCaf83E6RCWIRaOieexAimJ+2EzUa ayOn+dpp6mkl/ZKHX2Zh6U7340Os1QlyM7bKQyri7JbsLdD+eFVDRuxJpAWXjJ/ev6eU 1QdrAAlF/UJcribc9omeUJnqU10fq3VixYYVn1Dp4QkI1R/7ci4/GssC27NNe50975X0 6b5w== X-Gm-Message-State: AGi0PuZm5NrrXpJeGsPpEICpJpWUPMwW7wFyGz1R/ynOEX58BPAMmYm/ z2D11A58JxUuvsei8igaPTbtFA== X-Google-Smtp-Source: APiQypLRb4ERv4pNnQo4NtV7A8RgRJ6NvYioqzEYnUOUqYwtOIOld1w6Dx0tIz+3yIZQfSlg2p7TWA== X-Received: by 2002:a37:bec5:: with SMTP id o188mr10817594qkf.165.1585947106643; Fri, 03 Apr 2020 13:51:46 -0700 (PDT) Received: from nimloth.alvh.no-ip.org ([190.95.18.252]) by smtp.gmail.com with ESMTPSA id f127sm7214222qkd.74.2020.04.03.13.51.45 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 03 Apr 2020 13:51:45 -0700 (PDT) Received: by nimloth.alvh.no-ip.org (Postfix, from userid 1000) id 59199300719; Fri, 3 Apr 2020 17:51:43 -0300 (-03) Date: Fri, 3 Apr 2020 17:51:43 -0300 From: Alvaro Herrera To: Erik Rijkers Cc: Justin Pryzby , Corey Huinker , =?iso-8859-1?Q?J=FCrgen?= Purtz , Roger Harkavy , pgsql-hackers@postgresql.org, Fabien COELHO , Michael Paquier Subject: Re: Add A Glossary Message-ID: <20200403205143.GA7961@alvherre.pgsql> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="7JfCtLOvnd9MIVvH" Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <7b9b469e804777ac9df4d37716db935e@xs4all.nl> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --7JfCtLOvnd9MIVvH Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit On 2020-Apr-03, Erik Rijkers wrote: > On 2020-04-03 18:45, Alvaro Herrera wrote: > > Pushed now. Many thanks to Corey who put the main thrust, and to Jürgen > > and Roger for the great help, and to Justin for the extensive review and > > Fabien for the initial discussion. > > A few improvements: Thanks! That gives me the attached patch. > Should also be a lemmata in the glossary: > > ACID Agreed. Wording suggestions welcome. > 'archaic' should maybe be 'obsolete'. That seems to me to be an easier word > for non-native speakers. Bummer ;-) -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services --7JfCtLOvnd9MIVvH Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="glossfixes-1.patch" diff --git a/doc/src/sgml/glossary.sgml b/doc/src/sgml/glossary.sgml index 8c6cb6e942..b5155e1a85 100644 --- a/doc/src/sgml/glossary.sgml +++ b/doc/src/sgml/glossary.sgml @@ -48,7 +48,7 @@ In reference to a datum: - the fact that its value that cannot be broken down into smaller + the fact that its value cannot be broken down into smaller components. @@ -270,14 +270,14 @@ global SQL objects. The cluster is managed by exactly one instance. A newly created - Cluster will have three databases created automatically. They are + cluster will have three databases created automatically. They are template0, template1, and postgres. It is expected that an application will create one or more additional database aside from these three. (Don't confuse the PostgreSQL-specific term - Cluster with the SQL + cluster with the SQL command CLUSTER). @@ -363,7 +363,7 @@ A restriction on the values of data allowed within a - Table. + table. For more information, see @@ -424,7 +424,7 @@ Datum - The internal representation of one value of a SQL + The internal representation of one value of an SQL data type. @@ -617,7 +617,7 @@ Contains the values of row - attributes (i.e. the data) for a + attributes (i.e., the data) for a relation. The heap is realized within segment files. @@ -835,7 +835,7 @@ A relation that is - defined in the same way that a a view + defined in the same way that a view is, but stores data in the same way that a table does. It cannot be modified via INSERT, UPDATE, or @@ -900,7 +900,7 @@ In reference to a partitioned table: - One of the tables that each contain part of the data of the partitioned table, + One of multiple tables that each contain part of the data of the partitioned table, which is said to be the parent. The partition is itself a table, so it can also be queried directly; at the same time, a partition can sometimes be a partitioned table, @@ -910,7 +910,7 @@ In reference to a window function: - a partition is a user-defined criteria that identifies which neighboring + a partition is a user-defined criterion that identifies which neighboring rows can be considered by the function. @@ -1103,7 +1103,7 @@ A data structure transmitted from a backend process to - client program upon the completion of a SQL + client program upon the completion of an SQL command, usually a SELECT but it can be an INSERT, UPDATE, or DELETE command if the RETURNING @@ -1134,8 +1134,8 @@ A collection of access privileges to the - instance. - Roless are themselves a privilege that can be granted to other roles. + instance. + Roles are themselves a privilege that can be granted to other roles. This is often done for convenience or to ensure completeness when multiple users need the same privileges. @@ -1151,7 +1151,7 @@ Rollback - A command to undo all of the operations performed since the beginning + A command to undo all operations performed since the beginning of a transaction. @@ -1170,7 +1170,7 @@ Savepoint - A special mark inside the sequence of steps in a + A special mark in the sequence of steps in a transaction. Data modifications after this point in time may be reverted to the time of the savepoint. @@ -1192,7 +1192,8 @@ SQL object must reside in exactly one schema. - The names of SQL objects of the same type in the same schema are enforced unique. + The names of SQL objects of the same type in the same schema are enforced + to be unique. There is no restriction on reusing a name in multiple schemas. @@ -1205,7 +1206,7 @@ - More generically, the term Schema is used to mean + More generically, the term schema is used to mean all data descriptions (table definitions, constraints, comments, etc) for a given database or @@ -1356,7 +1357,7 @@ procedure, trigger, data type, or operator. Every one of those SQL objects - belong to exactly one Schema. + belong to exactly one schema. There also exist SQL objects that do not belong to schemas; those include @@ -1386,7 +1387,7 @@ This process collects statistical information about the - Cluster's activities. + cluster's activities. For more information, see @@ -1431,7 +1432,7 @@ attributes, in the same order, having the same name and type per position). A table is the most common form of - Relation in + relation in PostgreSQL. @@ -1508,7 +1509,7 @@ UPDATE, DELETE, TRUNCATE) is applied to a relation. - A Trigger executes within the same + A trigger executes within the same transaction as the statement which invoked it, and if the function fails, then the invoking statement also fails. @@ -1620,8 +1621,8 @@ The process of removing outdated tuple - versions from tables, and other closely related - garbage-collection-like processing required by PostgreSQL's + versions from tables, and other + processing required by PostgreSQL's implementation of MVCC. This can be initiated through the use of the VACUUM command, but can also be handled automatically @@ -1678,7 +1679,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 are replayed to restore the system to the state as it was + changes is replayed to restore the system to the state as it was before the crash. --7JfCtLOvnd9MIVvH--