From be8d6c5c3477ba664c533cf0b93cdf4cd426b6e1 Mon Sep 17 00:00:00 2001 From: Magnus Hagander Date: Mon, 25 Aug 2008 15:11:01 +0000 Subject: Make stats_temp_directory PGC_SIGHUP, and document how it may cause a temporary "outage" of the statistics views. This requires making the stats collector respond to SIGHUP, like the other utility processes already did. --- doc/src/sgml/config.sgml | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 0f9b33c0579..3eca0bab845 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -1,4 +1,4 @@ - + Server Configuration @@ -3418,7 +3418,9 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; path relative to the data directory or an absolute path. The default is pg_stat_tmp. Pointing this at a RAM based filesystem will decrease physical I/O requirements and can lead to increased - performance. This parameter can only be set at server start. + performance. If this parameter is changed when the system is running, + the statistics functions might return no information until a new + file has been written, which typically happens twice per second. -- cgit v1.2.3