From: | Li Japin <japinli(at)hotmail(dot)com> |
---|---|
To: | "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-11-25 02:18:28 |
Message-ID: | 4416156D-BC97-4F0D-BE03-3126B1FB23FE@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
Attachment | Content-Type | Size |
---|---|---|
v9-0001-Allow-terminating-the-idle-sessions.patch | application/octet-stream | 10.5 KB |
v9-0002-Optimize-setitimer-usage.patch | application/octet-stream | 4.1 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Tomas Vondra | 2020-11-25 02:19:23 | Re: [PoC] Non-volatile WAL buffer |
Previous Message | Craig Ringer | 2020-11-25 02:10:44 | Re: POC: postgres_fdw insert batching |