Re: [tiny doc fix] statistics are not retained across immediate shutdown

Applied.

---------------------------------------------------------------------------

On Wed, Sep 4, 2013 at 04:11:09AM +0000, Tsunakawa, Takayuki wrote:
> Hi,
>
> In the following page, statistics are kept across server restarts:
>
> http://www.postgresql.org/docs/current/static/monitoring-stats.html
>
> "When the server shuts down, a permanent copy of the statistics data is stored in the global subdirectory, so that statistics can be retained across server restarts."
>
>
> However, statistics are not retained after immediate shutdown (pg_ctl stop -mi). You may say "pg_ctl stop -mi is not a shutdown but an abort, so the sentence is not wrong", but it's an "immediate shutdown" and one mode of shutdown.
>
> I propose a tiny fix to clarify this. Please find the attached patch.
>
> I'd like this to be backported at least 9.2. Thanks.
>
>
> Regards, Takayuki Tsunakawa

> diff -rpcd a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml
> *** a/doc/src/sgml/monitoring.sgml 2013-06-25 03:55:41.000000000 +0900
> --- b/doc/src/sgml/monitoring.sgml 2013-09-03 16:12:05.000000000 +0900
> *************** postgres: <replaceable>user</> <replacea
> *** 185,193 ****
> <filename>pg_stat_tmp</filename> by default.
> For better performance, <varname>stats_temp_directory</> can be
> pointed at a RAM-based file system, decreasing physical I/O requirements.
> ! When the server shuts down, a permanent copy of the statistics
> data is stored in the <filename>global</filename> subdirectory, so that
> ! statistics can be retained across server restarts.
> </para>
>
> </sect2>
> --- 185,195 ----
> <filename>pg_stat_tmp</filename> by default.
> For better performance, <varname>stats_temp_directory</> can be
> pointed at a RAM-based file system, decreasing physical I/O requirements.
> ! When the server shuts down cleanly, a permanent copy of the statistics
> data is stored in the <filename>global</filename> subdirectory, so that
> ! statistics can be retained across server restarts. When recovery is
> ! performed at server start (e.g. after immediate shutdown, server crash,
> ! and point-in-time recovery), all statistics counters are reset.
> </para>
>
> </sect2>

>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +