Re: Terminate the idle sessions

From: Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru>
To: Li Japin <japinli(at)hotmail(dot)com>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: "kuroda(dot)hayato(at)fujitsu(dot)com" <kuroda(dot)hayato(at)fujitsu(dot)com>, Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, "bharath(dot)rupireddyforpostgres(at)gmail(dot)com" <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>, "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Terminate the idle sessions
Date: 2020-12-01 13:55:49
Message-ID: abbf48ce-0009-66c4-fd43-1c9b765d060c@postgrespro.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 25.11.2020 05:18, Li Japin wrote:
>
>
>
>> On Nov 24, 2020, at 11:20 PM, David G. Johnston
>> <david(dot)g(dot)johnston(at)gmail(dot)com <mailto:david(dot)g(dot)johnston(at)gmail(dot)com>> wrote:
>>
>> On Mon, Nov 23, 2020 at 11:22 PM Li Japin <japinli(at)hotmail(dot)com
>> <mailto:japinli(at)hotmail(dot)com>> wrote:
>>
>>
>> How about use “foreign-data wrapper” replace “postgres_fdw”?
>>
>>
>> I don't see much value in avoiding mentioning that specific term - my
>> proposal turned it into an example instead of being exclusive.
>>
>>
>> -         This parameter should be set to zero if you use some
>> connection-pooling software,
>> -         or pg servers used by postgres_fdw, because connections
>> might be closed unexpectedly.
>> +         This parameter should be set to zero if you use
>> connection-pooling software,
>> +         or <productname>PostgreSQL</productname> servers
>> connected to using foreign-data
>> +         wrapper, because connections might be closed unexpectedly.
>>          </para>
>>
>>
>> Maybe:
>>
>> + or your PostgreSQL server receives connection from postgres_fdw or
>> similar middleware.
>> + Such software is expected to self-manage its connections.
>
> Thank you for your suggestion and patient! Fixed.
>
> ```
> +        <para>
> +         This parameter should be set to zero if you use
> connection-pooling software,
> +         or <productname>PostgreSQL</productname> servers connected
> to using postgres_fdw
> +         or similar middleware (such software is expected to
> self-manage its connections),
> +         because connections might be closed unexpectedly.
> +        </para>
> ```
>
> --
> Best regards
> Japin Li
>

Status update for a commitfest entry.
As far as I see, all recommendations from reviewers were addressed in
the last version of the patch.

It passes CFbot successfully, so I move it to Ready For Committer.

--
Anastasia Lubennikova
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message osumi.takamichi@fujitsu.com 2020-12-01 13:59:33 RE: Disable WAL logging to speed up data loading
Previous Message James Coleman 2020-12-01 13:43:38 Re: Consider parallel for lateral subqueries with limit