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