pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Bruce Momjian <bruce@momjian.us>
To: PostgreSQL-documentation <pgsql-docs@postgresql.org>
Subject: Re: "stable storage"
Date: Fri, 21 Aug 2020 18:12:02 -0400
Message-ID: <20200821221202.GH13363@momjian.us> (raw)
In-Reply-To: <20200817165222.GA31806@momjian.us>
References: <20200817165222.GA31806@momjian.us>

On Mon, Aug 17, 2020 at 12:52:22PM -0400, Bruce Momjian wrote:
> I know we talk about durability a lot, but it seems we mention "stable
> storage" much more often than "durable storage" in our docs:
...
> Is "stable storage" the same as "durable storage"?  Should we rename
> "stable storage" mentions to "durable storage"?

I have developed the attached doc patch to change "stable storage" to
"durable storage".

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EnterpriseDB                             https://enterprisedb.com

  The usefulness of a cup is in its emptiness, Bruce Lee

Attachments:

stable.diff (text/x-diff, 9.7K) download diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 7a7177c550..218aa5ae04 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -2740,7 +2740,7 @@ include_dir 'conf.d' ensure data preservation even if a standby instance of <productname>PostgreSQL</productname> were to crash, but not if the standby suffers an operating-system-level crash, since the data has not - necessarily reached stable storage on the standby. + necessarily reached durable storage on the standby. Finally, the setting <literal>local</literal> causes commits to wait for local flush to disk, but not for replication. This is not usually desirable when synchronous replication is in use, but is provided for diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index 304c49f07b..cf3b80c1d7 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -1210,12 +1210,12 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser <row> <entry><literal>ControlFileSync</literal></entry> <entry>Waiting for the <filename>pg_control</filename> file to reach - stable storage.</entry> + durable storage.</entry> </row> <row> <entry><literal>ControlFileSyncUpdate</literal></entry> <entry>Waiting for an update to the <filename>pg_control</filename> file - to reach stable storage.</entry> + to reach durable storage.</entry> </row> <row> <entry><literal>ControlFileWrite</literal></entry> @@ -1246,12 +1246,12 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser </row> <row> <entry><literal>DataFileFlush</literal></entry> - <entry>Waiting for a relation data file to reach stable storage.</entry> + <entry>Waiting for a relation data file to reach durable storage.</entry> </row> <row> <entry><literal>DataFileImmediateSync</literal></entry> <entry>Waiting for an immediate synchronization of a relation data file to - stable storage.</entry> + durable storage.</entry> </row> <row> <entry><literal>DataFilePrefetch</literal></entry> @@ -1264,7 +1264,7 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser </row> <row> <entry><literal>DataFileSync</literal></entry> - <entry>Waiting for changes to a relation data file to reach stable storage.</entry> + <entry>Waiting for changes to a relation data file to reach durable storage.</entry> </row> <row> <entry><literal>DataFileTruncate</literal></entry> @@ -1281,7 +1281,7 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser </row> <row> <entry><literal>LockFileAddToDataDirSync</literal></entry> - <entry>Waiting for data to reach stable storage while adding a line to the + <entry>Waiting for data to reach durable storage while adding a line to the data directory lock file.</entry> </row> <row> @@ -1296,7 +1296,7 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser </row> <row> <entry><literal>LockFileCreateSync</literal></entry> - <entry>Waiting for data to reach stable storage while creating the data + <entry>Waiting for data to reach durable storage while creating the data directory lock file.</entry> </row> <row> @@ -1311,12 +1311,12 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser </row> <row> <entry><literal>LogicalRewriteCheckpointSync</literal></entry> - <entry>Waiting for logical rewrite mappings to reach stable storage + <entry>Waiting for logical rewrite mappings to reach durable storage during a checkpoint.</entry> </row> <row> <entry><literal>LogicalRewriteMappingSync</literal></entry> - <entry>Waiting for mapping data to reach stable storage during a logical + <entry>Waiting for mapping data to reach durable storage during a logical rewrite.</entry> </row> <row> @@ -1326,7 +1326,7 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser </row> <row> <entry><literal>LogicalRewriteSync</literal></entry> - <entry>Waiting for logical rewrite mappings to reach stable + <entry>Waiting for logical rewrite mappings to reach durable storage.</entry> </row> <row> @@ -1344,7 +1344,7 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser </row> <row> <entry><literal>RelationMapSync</literal></entry> - <entry>Waiting for the relation map file to reach stable storage.</entry> + <entry>Waiting for the relation map file to reach durable storage.</entry> </row> <row> <entry><literal>RelationMapWrite</literal></entry> @@ -1369,12 +1369,12 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser </row> <row> <entry><literal>ReplicationSlotRestoreSync</literal></entry> - <entry>Waiting for a replication slot control file to reach stable storage + <entry>Waiting for a replication slot control file to reach durable storage while restoring it to memory.</entry> </row> <row> <entry><literal>ReplicationSlotSync</literal></entry> - <entry>Waiting for a replication slot control file to reach stable + <entry>Waiting for a replication slot control file to reach durable storage.</entry> </row> <row> @@ -1383,7 +1383,7 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser </row> <row> <entry><literal>SLRUFlushSync</literal></entry> - <entry>Waiting for SLRU data to reach stable storage during a checkpoint + <entry>Waiting for SLRU data to reach durable storage during a checkpoint or database shutdown.</entry> </row> <row> @@ -1392,7 +1392,7 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser </row> <row> <entry><literal>SLRUSync</literal></entry> - <entry>Waiting for SLRU data to reach stable storage following a page + <entry>Waiting for SLRU data to reach durable storage following a page write.</entry> </row> <row> @@ -1407,7 +1407,7 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser <row> <entry><literal>SnapbuildSync</literal></entry> <entry>Waiting for a serialized historical catalog snapshot to reach - stable storage.</entry> + durable storage.</entry> </row> <row> <entry><literal>SnapbuildWrite</literal></entry> @@ -1417,7 +1417,7 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser <row> <entry><literal>TimelineHistoryFileSync</literal></entry> <entry>Waiting for a timeline history file received via streaming - replication to reach stable storage.</entry> + replication to reach durable storage.</entry> </row> <row> <entry><literal>TimelineHistoryFileWrite</literal></entry> @@ -1430,7 +1430,7 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser </row> <row> <entry><literal>TimelineHistorySync</literal></entry> - <entry>Waiting for a newly created timeline history file to reach stable + <entry>Waiting for a newly created timeline history file to reach durable storage.</entry> </row> <row> @@ -1444,7 +1444,7 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser </row> <row> <entry><literal>TwophaseFileSync</literal></entry> - <entry>Waiting for a two phase state file to reach stable storage.</entry> + <entry>Waiting for a two phase state file to reach durable storage.</entry> </row> <row> <entry><literal>TwophaseFileWrite</literal></entry> @@ -1452,7 +1452,7 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser </row> <row> <entry><literal>WALBootstrapSync</literal></entry> - <entry>Waiting for WAL to reach stable storage during + <entry>Waiting for WAL to reach durable storage during bootstrapping.</entry> </row> <row> @@ -1467,7 +1467,7 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser <row> <entry><literal>WALCopySync</literal></entry> <entry>Waiting for a new WAL segment created by copying an existing one to - reach stable storage.</entry> + reach durable storage.</entry> </row> <row> <entry><literal>WALCopyWrite</literal></entry> @@ -1476,7 +1476,7 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser </row> <row> <entry><literal>WALInitSync</literal></entry> - <entry>Waiting for a newly initialized WAL file to reach stable + <entry>Waiting for a newly initialized WAL file to reach durable storage.</entry> </row> <row> @@ -1494,11 +1494,11 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser </row> <row> <entry><literal>WALSync</literal></entry> - <entry>Waiting for a WAL file to reach stable storage.</entry> + <entry>Waiting for a WAL file to reach durable storage.</entry> </row> <row> <entry><literal>WALSyncMethodAssign</literal></entry> - <entry>Waiting for data to reach stable storage while assigning a new + <entry>Waiting for data to reach durable storage while assigning a new WAL sync method.</entry> </row> <row>

view thread (8+ messages)  latest in thread

Message-ID: <20200821221202.GH13363@momjian.us>
Permalink:  ../20200821221202.GH13363@momjian.us/
Also on:    postgresql.org/message-id/20200821221202.GH13363@momjian.us

 ·  · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: bruce@momjian.us
  Subject: Re: "stable storage"
  In-Reply-To: <20200821221202.GH13363@momjian.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox