Re: wal_sender_timeout / wal_receiver_timeout - seconds ormilliseconds? - Mailing list pgsql-docs

From Bruce Momjian
Subject Re: wal_sender_timeout / wal_receiver_timeout - seconds ormilliseconds?
Date
Msg-id 20191105152138.GD12780@momjian.us
Whole thread Raw
In response to Re: wal_sender_timeout / wal_receiver_timeout - seconds ormilliseconds?  (Michael Paquier <michael@paquier.xyz>)
Responses Re: wal_sender_timeout / wal_receiver_timeout - seconds ormilliseconds?  (Michael Paquier <michael@paquier.xyz>)
List pgsql-docs
On Tue, Nov  5, 2019 at 01:27:16PM +0900, Michael Paquier wrote:
> On Mon, Nov 04, 2019 at 09:52:34PM -0500, Bruce Momjian wrote:
> > The default _value_ is 60 seconds, and we use the 's' to specify
> > seconds.  What the comment is saying is that if you _don't_ specify any
> > units, the integer is in milliseconds.  I am not sure how to improve
> > that.
> 
> I do have a suggestion as per the attached, say:
> +#wal_sender_timeout = 60s      # in milliseconds if no unit specified;
> +                               # 0 disables

Ugh, the "if no unit specified" is true of all the settings.  Should we
make that clearer in a more central location.

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


> --
> Michael

> diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample
> index 0fc23e3a61..eea017e840 100644
> --- a/src/backend/utils/misc/postgresql.conf.sample
> +++ b/src/backend/utils/misc/postgresql.conf.sample
> @@ -286,7 +286,8 @@
>  #max_wal_senders = 10        # max number of walsender processes
>                  # (change requires restart)
>  #wal_keep_segments = 0        # in logfile segments; 0 disables
> -#wal_sender_timeout = 60s    # in milliseconds; 0 disables
> +#wal_sender_timeout = 60s    # in milliseconds if no unit specified;
> +                # 0 disables
>  
>  #max_replication_slots = 10    # max number of replication slots
>                  # (change requires restart)
> @@ -326,7 +327,8 @@
>                      # query conflicts
>  #wal_receiver_timeout = 60s        # time that receiver waits for
>                      # communication from master
> -                    # in milliseconds; 0 disables
> +                    # in milliseconds if no unit specified;
> +                    # 0 disables
>  #wal_retrieve_retry_interval = 5s    # time to wait before retrying to
>                      # retrieve WAL after a failed attempt
>  #recovery_min_apply_delay = 0        # minimum delay for applying changes during recovery




-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +



pgsql-docs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: wal_sender_timeout / wal_receiver_timeout - seconds ormilliseconds?
Next
From: Bruce Momjian
Date:
Subject: Re: uniqueness and null could benefit from a hint for dba