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
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 |