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 <br...@momjian.us> https://momjian.us EnterpriseDB https://enterprisedb.com The usefulness of a cup is in its emptiness, Bruce Lee
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>