Date: Fri, 20 Mar 2020 18:03:18 -0500
From: Justin Pryzby <pryzby@telsasoft.com>
To: =?iso-8859-1?Q?J=FCrgen?= Purtz <juergen@purtz.de>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>,
	Corey Huinker <corey.huinker@gmail.com>,
	Roger Harkavy <rogerharkavy@gmail.com>,
	pgsql-hackers@postgresql.org, Fabien COELHO <coelho@cri.ensmp.fr>,
	Michael Paquier <michael@paquier.xyz>
Subject: Re: Add A Glossary
Message-ID: <20200320230318.GB13662@telsasoft.com>
References: 
 <CADkLM=fwtE-TCU7sRnvaE74z12kOp_A+CdUwMr7aZt39pXbh6A@mail.gmail.com>
 <20200320001122.GA19602@alvherre.pgsql>
 <20200320195841.GA13662@telsasoft.com>
 <64b49f34-eaf6-6de2-e951-0eb8d4afabc2@purtz.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <64b49f34-eaf6-6de2-e951-0eb8d4afabc2@purtz.de>
User-Agent: Mutt/1.9.4 (2018-02-28)
Precedence: bulk

On Fri, Mar 20, 2020 at 11:32:25PM +0100, Jürgen Purtz wrote:
> > > +   <glossentry id="glossary-file-segment">
> > > +    <glossterm>File Segment</glossterm>
> > > +    <glossdef>
> > > +     <para>
> > > +       If a heap or index file grows in size over 1 GB, it will be split
> > 1GB is the default "segment size", which you should define.
> 
> ???

"A <<Table>> or other >>Relation<<" is larger than a >Cluster's< segment size
is stored in multiple physical files.  This avoids file size limitations which
vary across operating systems."

https://www.postgresql.org/docs/devel/runtime-config-preset.html

ts=# SELECT name, setting, unit, category, short_desc FROM pg_settings WHERE name~'block_size|segment_size';
       name       | setting  | unit |    category    |                  short_desc                  
------------------+----------+------+----------------+----------------------------------------------
 block_size       | 8192     |      | Preset Options | Shows the size of a disk block.
 segment_size     | 131072   | 8kB  | Preset Options | Shows the number of pages per disk file.
 wal_block_size   | 8192     |      | Preset Options | Shows the block size in the write ahead log.
 wal_segment_size | 16777216 | B    | Preset Options | Shows the size of write ahead log segments.

> > > +   <glossentry id="glossary-heap">
> > > +    <glossterm>Heap</glossterm>
> > > +    <glossdef>
> > > +     <para>
> > > +      Contains the original values of <glossterm>Row</glossterm> attributes
> > I'm not sure what "original" means here ?
> 
> Yes, this may be misleading. I want to express, that values are stored in
> the heap (the 'original') and possibly repeated as a key in an index.

Maybe "this is the content of rows/attributes in >>Tables<< or other >>Relations<<".
or "this is the data store for ..."

> > > +   <glossentry id="glossary-host">
> > > +    <glossterm>Host</glossterm>
> > > +    <glossdef>
> > > +     <para>
> > > +      See <glossterm>Server</glossterm>.
> > Or client.  Or proxy at some layer or other intermediate thing.  Maybe just
> > remove this.
> 
> Sometimes the term "host" is used in a different meaning. Therefor we shall
> have this glossary entry for clarification that it shall be used only in the
> sense of a "server".

I think that suggests just removing "host" and consistently saying "server".

-- 
Justin