Home Explore Blog CI



postgresql

4th chunk of `doc/src/sgml/glossary.sgml`
ef5b37d3d567563847af8ab0444c3ccc0d7d5f07640ceea40000000100000fa2
 linkend="glossary-auxiliary-proc">auxiliary process</glossterm>
     that writes dirty
     <glossterm linkend="glossary-data-page">data pages</glossterm> from
     <glossterm linkend="glossary-shared-memory">shared memory</glossterm> to
     the file system.  It wakes up periodically, but works only for a short
     period in order to distribute its expensive <acronym>I/O</acronym>
     activity over time to avoid generating larger
     <acronym>I/O</acronym> peaks which could block other processes.
    </para>
    <para>
     For more information, see
     <xref linkend="runtime-config-resource-background-writer"/>.
    </para>
   </glossdef>
  </glossentry>

  <glossentry id="glossary-basebackup">
   <glossterm>Base Backup</glossterm>
   <glossdef>
    <para>
     A binary copy of all
     <glossterm linkend="glossary-db-cluster">database cluster</glossterm>
     files. It is generated by the tool <xref linkend="app-pgbasebackup"/>.
     In combination with WAL files it can be used as the starting point
     for recovery, log shipping, or streaming replication.
    </para>
   </glossdef>
  </glossentry>

  <glossentry id="glossary-bloat">
   <glossterm>Bloat</glossterm>
   <glossdef>
    <para>
     Space in data pages which does not contain current row versions,
     such as unused (free) space or outdated row versions.
    </para>
   </glossdef>
  </glossentry>

  <glossentry id="glossary-bootstrap-superuser">
   <glossterm>Bootstrap superuser</glossterm>
   <glossdef>
    <para>
     The first <glossterm linkend="glossary-user">user</glossterm> initialized in a
     <glossterm linkend="glossary-db-cluster">database cluster</glossterm>.
    </para>
    <para>
     This user owns all system catalog tables in each database.  It is also the role
     from which all granted permissions originate.  Because of these things, this
     role may not be dropped.
    </para>
    <para>
     This role also behaves as a normal
     <glossterm linkend="glossary-database-superuser">database superuser</glossterm>,
     and its superuser status cannot be removed.
    </para>
   </glossdef>
  </glossentry>

  <glossentry id="glossary-buffer-access-strategy">
   <glossterm>Buffer Access Strategy</glossterm>
   <glossdef>
    <para>
     Some operations will access a large number of
     <glossterm linkend="glossary-data-page">pages</glossterm>.  A
     <firstterm>Buffer Access Strategy</firstterm> helps to prevent these
     operations from evicting too many pages from
     <glossterm linkend="glossary-shared-memory">shared buffers</glossterm>.
    </para>
    <para>
     A Buffer Access Strategy sets up references to a limited number of
     <glossterm linkend="glossary-shared-memory">shared buffers</glossterm> and
     reuses them circularly.  When the operation requires a new page, a victim
     buffer is chosen from the buffers in the strategy ring, which may require
     flushing the page's dirty data and possibly also unflushed
     <glossterm linkend="glossary-wal">WAL</glossterm> to permanent storage.
    </para>
    <para>
     Buffer Access Strategies are used for various operations such as
     sequential scans of large tables, <command>VACUUM</command>,
     <command>COPY</command>, <command>CREATE TABLE AS SELECT</command>,
     <command>ALTER TABLE</command>, <command>CREATE DATABASE</command>,
     <command>CREATE INDEX</command>, and <command>CLUSTER</command>.
    </para>
   </glossdef>
  </glossentry>

  <glossentry id="glossary-cast">
   <glossterm>Cast</glossterm>
   <glossdef>
    <para>
     A conversion of a <glossterm linkend="glossary-datum">datum</glossterm>
     from its current data type to another data type.
    </para>
    <para>
     For more information, see
     <xref linkend="sql-createcast"/>.
    </para>
   </glossdef>
  </glossentry>

  <glossentry id="glossary-catalog">
   <glossterm>Catalog</glossterm>
   <glossdef>
    <para>
     The <acronym>SQL</acronym> standard uses this term to
     indicate what

Title: PostgreSQL Database Concepts and Operations
Summary
This section covers several important PostgreSQL concepts and operations. It explains the Base Backup, which is a binary copy of all database cluster files used for recovery and replication. The text defines Bloat as unused space in data pages. It describes the Bootstrap superuser, the first user initialized in a database cluster with special privileges. The Buffer Access Strategy is explained as a method to manage shared buffers during large operations. Lastly, it defines Cast as the conversion of data from one type to another, and introduces the concept of Catalog in the context of SQL standards.