From: Kyotaro Horiguchi Date: Wed, 4 Jul 2018 11:44:31 +0900 Subject: [PATCH 7/8] Documentation update Remove all description on pg_stat_tmp directory from documentation. --- doc/src/sgml/backup.sgml | 4 +--- doc/src/sgml/config.sgml | 19 ------------------- doc/src/sgml/func.sgml | 3 +-- doc/src/sgml/monitoring.sgml | 7 +------ doc/src/sgml/protocol.sgml | 2 +- doc/src/sgml/ref/pg_rewind.sgml | 3 +-- doc/src/sgml/storage.sgml | 6 ------ 7 files changed, 5 insertions(+), 39 deletions(-) diff --git a/doc/src/sgml/backup.sgml b/doc/src/sgml/backup.sgml index 3fa5efdd78..31e94c1fe9 100644 --- a/doc/src/sgml/backup.sgml +++ b/doc/src/sgml/backup.sgml @@ -1116,11 +1116,9 @@ SELECT pg_stop_backup(); The contents of the directories pg_dynshmem/, pg_notify/, pg_serial/, - pg_snapshots/, pg_stat_tmp/, + pg_snapshots/, and pg_subtrans/ (but not the directories themselves) can be omitted from the backup as they will be initialized on postmaster startup. - If is set and is under the data - directory then the contents of that directory can also be omitted. diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 7554cba3f9..cd6b4b6096 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -6115,25 +6115,6 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - - stats_temp_directory (string) - - stats_temp_directory configuration parameter - - - - - Sets the directory to store temporary statistics data in. This can be - a path relative to the data directory or an absolute path. The default - is pg_stat_tmp. Pointing this at a RAM-based - file system will decrease physical I/O requirements and can lead to - improved performance. - This parameter can only be set in the postgresql.conf - file or on the server command line. - - - - diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 10816f556b..a759bfc70d 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -15953,8 +15953,7 @@ SELECT * FROM pg_ls_dir('.') WITH ORDINALITY AS t(ls,n); PG_VERSION | 15 pg_wal | 16 pg_hba.conf | 17 - pg_stat_tmp | 18 - pg_subtrans | 19 + pg_subtrans | 18 (19 rows) diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index add71458e2..a1031b3b2a 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -197,12 +197,7 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser The statistics collector transmits the collected information to other - PostgreSQL processes through temporary files. - These files are stored in the directory named by the - parameter, - pg_stat_tmp by default. - For better performance, stats_temp_directory can be - pointed at a RAM-based file system, decreasing physical I/O requirements. + PostgreSQL processes through shared memory. When the server shuts down cleanly, a permanent copy of the statistics data is stored in the pg_stat subdirectory, so that statistics can be retained across server restarts. When recovery is diff --git a/doc/src/sgml/protocol.sgml b/doc/src/sgml/protocol.sgml index f0b2145208..11f263f378 100644 --- a/doc/src/sgml/protocol.sgml +++ b/doc/src/sgml/protocol.sgml @@ -2612,7 +2612,7 @@ The commands accepted in replication mode are: pg_dynshmem, pg_notify, pg_replslot, pg_serial, - pg_snapshots, pg_stat_tmp, and + pg_snapshots, and pg_subtrans are copied as empty directories (even if they are symbolic links). diff --git a/doc/src/sgml/ref/pg_rewind.sgml b/doc/src/sgml/ref/pg_rewind.sgml index e2662bbf81..bf9c5dd580 100644 --- a/doc/src/sgml/ref/pg_rewind.sgml +++ b/doc/src/sgml/ref/pg_rewind.sgml @@ -270,8 +270,7 @@ PostgreSQL documentation (everything except the relation files). Similarly to base backups, the contents of the directories pg_dynshmem/, pg_notify/, pg_replslot/, - pg_serial/, pg_snapshots/, - pg_stat_tmp/, and + pg_serial/, pg_snapshots/, and pg_subtrans/ are omitted from the data copied from the source cluster. Any file or directory beginning with pgsql_tmp is omitted, as well as are diff --git a/doc/src/sgml/storage.sgml b/doc/src/sgml/storage.sgml index 8ef2ac8010..5ee7493970 100644 --- a/doc/src/sgml/storage.sgml +++ b/doc/src/sgml/storage.sgml @@ -120,12 +120,6 @@ Item subsystem - - pg_stat_tmp - Subdirectory containing temporary files for the statistics - subsystem - - pg_subtrans Subdirectory containing subtransaction status data -- 2.16.3 ----Next_Part(Thu_Nov_08_20_46_48_2018_519)-- Content-Type: Text/X-Patch; charset=us-ascii Content-Transfer-Encoding: 7bit Content-Disposition: inline; filename="v7-0008-Split-out-backend-status-monitor-part-from-pgstat.patch"