From: Kyotaro Horiguchi Date: Wed, 4 Jul 2018 11:44:31 +0900 Subject: [PATCH 4/6] 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 5b913f00c1..8430c1a3cb 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -6081,25 +6081,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 edc9be92a6..a01f68e99b 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -15889,8 +15889,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 36d393d329..f23dd2aaa0 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 cfc805f785..4b8ea2a6b8 100644 --- a/doc/src/sgml/protocol.sgml +++ b/doc/src/sgml/protocol.sgml @@ -2624,7 +2624,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 520d843f0e..416cb0f4f5 100644 --- a/doc/src/sgml/ref/pg_rewind.sgml +++ b/doc/src/sgml/ref/pg_rewind.sgml @@ -234,8 +234,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(Wed_Jul_04_17_29_11_2018_498)-- Content-Type: Text/X-Patch; charset=us-ascii Content-Transfer-Encoding: 7bit Content-Disposition: inline; filename="v3-0005-Let-pg_stat_statements-not-to-use-PG_STAT_TMP_DIR.patch"