Re: wal_sender_timeout default

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Jasen Lentz <jlentz(at)sescollc(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: wal_sender_timeout default
Date: 2020-05-07 16:10:56
Message-ID: 5fec9a05-a396-cc20-5630-86afd13aa281@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 5/7/20 9:07 AM, Adrian Klaver wrote:
> On 5/7/20 8:56 AM, Jasen Lentz wrote:
>> In Postgres 11.6-2, what is the default timeout for wal_sender_timeout
>> if it is commented out?
>
> Form postgresql.conf

Oops, from.

>
> # The commented-out settings shown in this file represent the default
> values.
> # Re-commenting a setting is NOT sufficient to revert it to the default
> value;
> # you need to reload the server.
>
> ...
>
> #wal_sender_timeout = 60s       # in milliseconds; 0 disables

Realized that the comment maybe confusing. If you just include an
integer it will be in milliseconds. Including a time unit s(econds)
overrides that.

>
>>
>> Jasen M. Lentz, M.Ed
>>
>> Lead Systems Administrator
>>
>> Sesco Enterprises, LLC
>>
>> 4977 State Route 30 East (Mailing Address Only)
>> Greensburg, PA 15601
>>
>> W:  (724) 837-1991 x207
>>
>> C:  (412) 848-5612
>>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2020-05-07 16:16:46 Re: Abnormal Growth of Index Size - Index Size 3x large than table size.
Previous Message Michael Lewis 2020-05-07 16:10:10 Re: Abnormal Growth of Index Size - Index Size 3x large than table size.