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 1ja4cw-0007cx-FE for pgsql-hackers@arkaria.postgresql.org; Sat, 16 May 2020 21:45:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ja4cv-0000TT-2C for pgsql-hackers@arkaria.postgresql.org; Sat, 16 May 2020 21:45:49 +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 1ja4cu-0000TG-Eq for pgsql-hackers@lists.postgresql.org; Sat, 16 May 2020 21:45:48 +0000 Received: from lb1-smtp-cloud7.xs4all.net ([194.109.24.24]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ja4cq-0005aD-Jh for pgsql-hackers@postgresql.org; Sat, 16 May 2020 21:45:47 +0000 Received: from webmailclassic.xs4all.nl ([IPv6:2001:888:0:22:194:109:20:200]) by smtp-cloud7.xs4all.net with ESMTPA id a4clji3uStKAsa4cljEuDH; Sat, 16 May 2020 23:45:40 +0200 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=xs4all.nl; s=s1; t=1589665540; bh=mWOfMj1JarPWG5Up5GTtjFao24kkD+6K9nwHlHXNjzM=; h=MIME-Version:Content-Type:Date:From:To:Subject:Message-ID:From: Subject; b=NXJ3kCXNa8MDONUONGRiMkJzTOEiVK4IJGkFhj5N3mFq7vgc4xTCWtRMdA921tkVR Z1ZrmMIYlSyfzLgkMblxaH1MmIjlu/X83NWKyLMY4y5xwHP593MbCPBSRQtjXiWfwi VPQtQSMuXVrRDaQtU/TLklT5eLdPQjNy21Dt4yB47xpp2x/96B4QemNxvKBobDdIV4 gAzXnLzDQJUmHWv/B2p+n3gnO7z4iBlwmZ7/djbtjDAJ+7Ky1ZPAUy+wXby7gEuLur O2QD/lKTFQu2efpVZqmc7hIdJHEQAX5k9+sK6Lr9NIVa7Nj5lDHySQR6wOGOh6bWAx jXgIGd3uiuV/Q== Received: from fc0c:c185:a5f8:6dfd:a400:6e47:313b:867f by webmailclassic.xs4all.nl with HTTP (HTTP/1.1 POST); Sat, 16 May 2020 23:45:39 +0200 MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="=_88405ea267906bd70daa95d4315e55d5" Date: Sat, 16 May 2020 23:45:39 +0200 From: Erik Rijkers To: Alvaro Herrera Cc: Justin Pryzby , Laurenz Albe , Fabien COELHO , =?UTF-8?Q?J=C3=BCrgen_Purtz?= , Peter Eisentraut , Corey Huinker , Roger Harkavy , pgsql-hackers@postgresql.org, Michael Paquier Subject: Re: Add A Glossary In-Reply-To: <20200515172619.GA31053@alvherre.pgsql> References: <20200515172619.GA31053@alvherre.pgsql> Message-ID: <508f2fb1764c3bd518ee96a4f2247d6f@xs4all.nl> X-Sender: er@xs4all.nl User-Agent: XS4ALL Webmail X-CMAE-Envelope: MS4wfAppf4kdmRoO9YqDSPyCEjanInTlil/JNBt8t4w28M8IQJTvSOtcX2q4jltlT9+BRKysngyxSWkqQdr0663iyxL3DuS5bAJtPwHYSpPbBwLs3EcZwmR8 XOpykqCBg0w5xyOlGX0XGsiEoMLvtO6qX76v9ItUPPVbhj9e/2+PeD1FZjG/2IcikkR/5woJriKIy/TmGTR4MI2m8LrCP3sMrd+m1FsERF41tKHpw3zGR1j9 lVK4+fJ//un/YQEg421ilJMSu8aVbWcMjV7VRsz9es5fWPwVaKPfe3yECntwZgml3d0j3/j+aoU9SXX4B7c7ms6W+hyQ0RbJRG9Zj9oZof6qhyaj91ZO8Ygs pQsXwUjoCAVTqULnSKTsew9HZt7O4012XWhn9nEjz27OYtkDtCjvCc2bOAw4zN4MMTKciip4TbTKKDZcN8dNl87KwAcEGogs8EQdaCqBKpvVv/Iw47fnbfjr HYy360RcgNqMw7n6TUPLAo5r7WOj1ASbKREY0VSL+r3yc2NK3tlLINmNFWzLN9iNGuMRY+OnT9cLdBov List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --=_88405ea267906bd70daa95d4315e55d5 Content-Transfer-Encoding: 8bit Content-Type: text/plain; charset=UTF-8; format=flowed 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 --=_88405ea267906bd70daa95d4315e55d5 Content-Transfer-Encoding: base64 Content-Type: text/x-diff; name=glossary-20200516.sgml.diff Content-Disposition: attachment; filename=glossary-20200516.sgml.diff; size=4313 LS0tIGRvYy9zcmMvc2dtbC9nbG9zc2FyeS5zZ21sLm9yaWcJMjAyMC0wNS0xNiAyMzozMDowMS4x MzIyOTAyMzcgKzAyMDAKKysrIGRvYy9zcmMvc2dtbC9nbG9zc2FyeS5zZ21sCTIwMjAtMDUtMTYg MjM6Mzg6MzUuNjQzMzcxMzEwICswMjAwCkBAIC02Nyw3ICs2Nyw3IEBACiAgICA8Z2xvc3NkZWY+ CiAgICAgPHBhcmE+CiAgICAgIEluIHJlZmVyZW5jZSB0byBhIDxnbG9zc3Rlcm0gbGlua2VuZD0i Z2xvc3NhcnktZGF0dW0iPmRhdHVtPC9nbG9zc3Rlcm0+OgotICAgICB0aGUgZmFjdCB0aGF0IGl0 cyB2YWx1ZSB0aGF0IGNhbm5vdCBiZSBicm9rZW4gZG93biBpbnRvIHNtYWxsZXIKKyAgICAgdGhl IGZhY3QgdGhhdCBpdHMgdmFsdWUgY2Fubm90IGJlIGJyb2tlbiBkb3duIGludG8gc21hbGxlcgog ICAgICBjb21wb25lbnRzLgogICAgIDwvcGFyYT4KICAgIDwvZ2xvc3NkZWY+CkBAIC0zNjAsNyAr MzYwLDcgQEAKICAgICAgPGdsb3NzdGVybSBsaW5rZW5kPSJnbG9zc2FyeS1jb25zdHJhaW50Ij5p bnRlZ3JpdHkgY29uc3RyYWludHM8L2dsb3NzdGVybT4uCiAgICAgIFRyYW5zYWN0aW9ucyBtYXkg YmUgYWxsb3dlZCB0byB2aW9sYXRlIHNvbWUgb2YgdGhlIGNvbnN0cmFpbnRzCiAgICAgIHRyYW5z aWVudGx5IGJlZm9yZSBpdCBjb21taXRzLCBidXQgaWYgc3VjaCB2aW9sYXRpb25zIGFyZSBub3Qg cmVzb2x2ZWQKLSAgICAgYnkgdGhlIHRpbWUgaXQgY29tbWl0cywgc3VjaCB0cmFuc2FjdGlvbiBp cyBhdXRvbWF0aWNhbGx5CisgICAgIGJ5IHRoZSB0aW1lIGl0IGNvbW1pdHMsIHN1Y2ggYSB0cmFu c2FjdGlvbiBpcyBhdXRvbWF0aWNhbGx5CiAgICAgIDxnbG9zc3Rlcm0gbGlua2VuZD0iZ2xvc3Nh cnktcm9sbGJhY2siPnJvbGxlZCBiYWNrPC9nbG9zc3Rlcm0+LgogICAgICBUaGlzIGlzIG9uZSBv ZiB0aGUgPGFjcm9ueW0+QUNJRDwvYWNyb255bT4gcHJvcGVydGllcy4KICAgICA8L3BhcmE+CkBA IC02NDksOCArNjQ5LDggQEAKICAgIDxnbG9zc3Rlcm0+R3JhbnQ8L2dsb3NzdGVybT4KICAgIDxn bG9zc2RlZj4KICAgICA8cGFyYT4KLSAgICAgQW4gPGFjcm9ueW0+U1FMPC9hY3JvbnltPiBjb21t YW5kIHRoYXQgaXMgdXNlZCB0byBhbGxvdwotICAgICA8Z2xvc3N0ZXJtIGxpbmtlbmQ9Imdsb3Nz YXJ5LXVzZXIiPnVzZXJzPC9nbG9zc3Rlcm0+IG9yCisgICAgIEFuIDxhY3JvbnltPlNRTDwvYWNy b255bT4gY29tbWFuZCB0aGF0IGlzIHVzZWQgdG8gYWxsb3cgYQorICAgICA8Z2xvc3N0ZXJtIGxp bmtlbmQ9Imdsb3NzYXJ5LXVzZXIiPnVzZXI8L2dsb3NzdGVybT4gb3IKICAgICAgPGdsb3NzdGVy bSBsaW5rZW5kPSJnbG9zc2FyeS1yb2xlIj5yb2xlPC9nbG9zc3Rlcm0+IHRvIGFjY2VzcwogICAg ICBzcGVjaWZpYyBvYmplY3RzIHdpdGhpbiB0aGUgPGdsb3NzdGVybSBsaW5rZW5kPSJnbG9zc2Fy eS1kYXRhYmFzZSI+ZGF0YWJhc2U8L2dsb3NzdGVybT4uCiAgICAgPC9wYXJhPgpAQCAtODg3LDcg Kzg4Nyw3IEBACiAgICA8Z2xvc3NkZWY+CiAgICAgPHBhcmE+CiAgICAgIEEgPGdsb3NzdGVybSBs aW5rZW5kPSJnbG9zc2FyeS1yZWxhdGlvbiI+cmVsYXRpb248L2dsb3NzdGVybT4gdGhhdCBpcwot ICAgICBkZWZpbmVkIGluIHRoZSBzYW1lIHdheSB0aGF0IGEgYSA8Z2xvc3N0ZXJtIGxpbmtlbmQ9 Imdsb3NzYXJ5LXZpZXciPnZpZXc8L2dsb3NzdGVybT4KKyAgICAgZGVmaW5lZCBpbiB0aGUgc2Ft ZSB3YXkgdGhhdCBhIDxnbG9zc3Rlcm0gbGlua2VuZD0iZ2xvc3NhcnktdmlldyI+dmlldzwvZ2xv c3N0ZXJtPgogICAgICBpcywgYnV0IHN0b3JlcyBkYXRhIGluIHRoZSBzYW1lIHdheSB0aGF0IGEK ICAgICAgPGdsb3NzdGVybSBsaW5rZW5kPSJnbG9zc2FyeS10YWJsZSI+dGFibGU8L2dsb3NzdGVy bT4gZG9lcy4gSXQgY2Fubm90IGJlCiAgICAgIG1vZGlmaWVkIHZpYSA8Y29tbWFuZD5JTlNFUlQ8 L2NvbW1hbmQ+LCA8Y29tbWFuZD5VUERBVEU8L2NvbW1hbmQ+LCBvcgpAQCAtOTYyLDcgKzk2Miw3 IEBACiAgICA8Z2xvc3NkZWY+CiAgICAgPHBhcmE+CiAgICAgIEluIHJlZmVyZW5jZSB0byBhIDxn bG9zc3Rlcm0gbGlua2VuZD0iZ2xvc3Nhcnktd2luZG93LWZ1bmN0aW9uIj53aW5kb3cgZnVuY3Rp b248L2dsb3NzdGVybT46Ci0gICAgIGEgcGFydGl0aW9uIGlzIGEgdXNlci1kZWZpbmVkIGNyaXRl cmlhIHRoYXQgaWRlbnRpZmllcyB3aGljaCBuZWlnaGJvcmluZworICAgICBhIHBhcnRpdGlvbiBp cyBhIHVzZXItZGVmaW5lZCBjcml0ZXJpb24gdGhhdCBpZGVudGlmaWVzIHdoaWNoIG5laWdoYm9y aW5nCiAgICAgIDxnbG9zc3Rlcm0gbGlua2VuZD0iZ2xvc3NhcnktdHVwbGUiPnJvd3M8L2dsb3Nz dGVybT4gY2FuIGJlIGNvbnNpZGVyZWQgYnkgdGhlCiAgICAgIGZ1bmN0aW9uLgogICAgIDwvcGFy YT4KQEAgLTE0NDYsOCArMTQ0Niw4IEBACiAgICAgIFRoZSBzeXN0ZW0gY2F0YWxvZyByZXNpZGVz IGluIHRoZSBzY2hlbWEgPGxpdGVyYWw+cGdfY2F0YWxvZzwvbGl0ZXJhbD4uCiAgICAgIFRoZXNl IHRhYmxlcyBjb250YWluIGRhdGEgaW4gaW50ZXJuYWwgcmVwcmVzZW50YXRpb24gYW5kIGFyZQog ICAgICBub3QgdHlwaWNhbGx5IGNvbnNpZGVyZWQgdXNlZnVsIGZvciB1c2VyIGV4YW1pbmF0aW9u OwotICAgICBhIG51bWJlciBvZiB1c2VyLWZyaWVuZGxpZXIgPGdsb3NzdGVybSBsaW5rZW5kPSJn bG9zc2FyeS12aWV3Ij52aWV3czwvZ2xvc3N0ZXJtPgotICAgICBhbHNvIGluIHNjaGVtYSA8bGl0 ZXJhbD5wZ19jYXRhbG9nPC9saXRlcmFsPiBvZmZlciBtb3JlIGNvbnZlbmllbnQgYWNjZXNzIHRv CisgICAgIGEgbnVtYmVyIG9mIHVzZXItZnJpZW5kbGllciA8Z2xvc3N0ZXJtIGxpbmtlbmQ9Imds b3NzYXJ5LXZpZXciPnZpZXdzPC9nbG9zc3Rlcm0+LAorICAgICBhbHNvIGluIHNjaGVtYSA8bGl0 ZXJhbD5wZ19jYXRhbG9nPC9saXRlcmFsPiwgb2ZmZXIgbW9yZSBjb252ZW5pZW50IGFjY2VzcyB0 bwogICAgICBzb21lIG9mIHRoYXQgaW5mb3JtYXRpb24sIHdoaWxlIGFkZGl0aW9uYWwgdGFibGVz IGFuZCB2aWV3cwogICAgICBleGlzdCBpbiBzY2hlbWEgPGxpdGVyYWw+aW5mb3JtYXRpb25fc2No ZW1hPC9saXRlcmFsPgogICAgICAoc2VlIDx4cmVmIGxpbmtlbmQ9ImluZm9ybWF0aW9uLXNjaGVt YSIgLz4pIHRoYXQgZXhwb3NlIHNvbWUKQEAgLTE3MzksNyArMTczOSw3IEBACiAgICAgIGVhY2gg cGFnZSBzdG9yZXMgdHdvIGJpdHM6IHRoZSBmaXJzdCBvbmUKICAgICAgKDxsaXRlcmFsPmFsbC12 aXNpYmxlPC9saXRlcmFsPikgaW5kaWNhdGVzIHRoYXQgYWxsIHR1cGxlcwogICAgICBpbiB0aGUg cGFnZSBhcmUgdmlzaWJsZSB0byBhbGwgdHJhbnNhY3Rpb25zLiAgVGhlIHNlY29uZCBvbmUKLSAg ICAgKDxsaXRlcmFsPmFsbC1mcm96ZW48L2xpdGVyYWw+KSBpbmRpY2F0ZSB0aGF0IGFsbCB0dXBs ZXMKKyAgICAgKDxsaXRlcmFsPmFsbC1mcm96ZW48L2xpdGVyYWw+KSBpbmRpY2F0ZXMgdGhhdCBh bGwgdHVwbGVzCiAgICAgIGluIHRoZSBwYWdlIGFyZSBtYXJrZWQgZnJvemVuLgogICAgIDwvcGFy YT4KICAgIDwvZ2xvc3NkZWY+CkBAIC0xNzU1LDcgKzE3NTUsNyBAQAogICAgPGdsb3NzZGVmPgog ICAgIDxwYXJhPgogICAgICBBIHByb2Nlc3MgdGhhdCBzYXZlcyBjb3BpZXMgb2YgPGdsb3NzdGVy bSBsaW5rZW5kPSJnbG9zc2FyeS13YWwtZmlsZSI+V0FMIGZpbGVzPC9nbG9zc3Rlcm0+Ci0gICAg IGZvciB0aGUgcHVycG9zZXMgb2YgY3JlYXRpbmcgYmFja3VwcyBvciBrZWVwaW5nCisgICAgIGZv ciB0aGUgcHVycG9zZSBvZiBjcmVhdGluZyBiYWNrdXBzIG9yIGtlZXBpbmcKICAgICAgPGdsb3Nz dGVybSBsaW5rZW5kPSJnbG9zc2FyeS1yZXBsaWNhIj5yZXBsaWNhczwvZ2xvc3N0ZXJtPiBjdXJy ZW50LgogICAgIDwvcGFyYT4KICAgICA8cGFyYT4KQEAgLTE3NzcsNyArMTc3Nyw3IEBACiAgICAg IGFuZCBhcmUgd3JpdHRlbiBpbiBzZXF1ZW50aWFsIG9yZGVyLCBpbnRlcnNwZXJzaW5nIGNoYW5n ZXMKICAgICAgYXMgdGhleSBvY2N1ciBpbiBtdWx0aXBsZSBzaW11bHRhbmVvdXMgc2Vzc2lvbnMu CiAgICAgIElmIHRoZSBzeXN0ZW0gY3Jhc2hlcywgdGhlIGZpbGVzIGFyZSByZWFkIGluIG9yZGVy LCBhbmQgZWFjaCBvZiB0aGUKLSAgICAgY2hhbmdlcyBpcyByZXBsYXllZCB0byByZXN0b3JlIHRo ZSBzeXN0ZW0gdG8gdGhlIHN0YXRlIGFzIGl0IHdhcworICAgICBjaGFuZ2VzIGlzIHJlcGxheWVk IHRvIHJlc3RvcmUgdGhlIHN5c3RlbSB0byB0aGUgc3RhdGUgaXQgd2FzIGluCiAgICAgIGJlZm9y ZSB0aGUgY3Jhc2guCiAgICAgPC9wYXJhPgogICAgIDxwYXJhPgo= --=_88405ea267906bd70daa95d4315e55d5--