Re: Terminate the idle sessions - Mailing list pgsql-hackers

From Li Japin
Subject Re: Terminate the idle sessions
Date
Msg-id 4416156D-BC97-4F0D-BE03-3126B1FB23FE@hotmail.com
Whole thread Raw
In response to Re: Terminate the idle sessions  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Terminate the idle sessions  (Anastasia Lubennikova <a.lubennikova@postgrespro.ru>)
Re: Terminate the idle sessions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers



On Nov 24, 2020, at 11:20 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:

On Mon, Nov 23, 2020 at 11:22 PM Li Japin <japinli@hotmail.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

pgsql-hackers by date:

Previous
From: Craig Ringer
Date:
Subject: Re: POC: postgres_fdw insert batching
Next
From: Tomas Vondra
Date:
Subject: Re: [PoC] Non-volatile WAL buffer