postgres_fdw connection caching enable/disable or timeout feature

Edit
Comment/Review
Change Status
ID 2650
Title postgres_fdw connection caching enable/disable or timeout feature
Topic Server Features
Created 2020-07-17 11:50:07
Last modified 2021-04-02 10:48:23 (3 years, 7 months ago)
Latest email 2021-04-02 10:47:39 (3 years, 7 months ago)
Status
2021-03: Committed
2021-01: Moved to next CF
2020-11: Moved to next CF
2020-09: Moved to next CF
Target version
Authors Bharath Rupireddy (bharathrupireddy)
Reviewers Fujii Masao (masaofujii), Alexey Kondratov (ololobus)Become reviewer
Committer Fujii Masao (masaofujii)
Links CFbot results (CirrusCI) CFbot GitHub
Checkout latest CFbot patchset Go to your local checkout of the PostgreSQL repository and run: 
git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/2650
git checkout commitfest/cf/2650
Emails
[PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit
First at 2020-06-22 05:55:54 by Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com>
Latest at 2021-04-02 10:47:39 by Fujii Masao <masao.fujii at oss.nttdata.com>
Latest attachment (v23-0003-postgres_fdw-server-level-option-keep_connection.patch) at 2021-04-01 16:13:42 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com>
    Attachment (v23-0003-postgres_fdw-server-level-option-keep_connection.patch) at 2021-04-01 16:13:42 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v22-0003-postgres_fdw-server-level-option-keep_connection.patch) at 2021-04-01 15:26:06 from Fujii Masao <masao.fujii at oss.nttdata.com> (Patch: Yes)
    Attachment (v21-0002-postgres_fdw-add-keep_connections-GUC-to-not-cac.patch) at 2021-02-22 05:55:31 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v20-0002-postgres_fdw-add-keep_connections-GUC-to-not-cac.patch) at 2021-02-04 04:06:42 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (postgres_fdw.patch) at 2021-01-29 18:44:30 from Fujii Masao <masao.fujii at oss.nttdata.com> (Patch: Yes)
    Attachment (v1-0001-Don-t-return-valid-state-in-postgres_fdw_get_conn.patch) at 2021-01-29 10:45:43 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Fix-connection-closure-issue-in-pgfdw_inval_callb.patch) at 2021-01-29 05:25:35 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v19-0002-postgres_fdw-add-keep_connections-GUC-to-not-cac.patch) at 2021-01-27 01:06:41 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Stabilize-test-case-for-postgres_fdw_disconnect_a.patch) at 2021-01-26 08:07:03 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v18-0001-postgres_fdw-Add-functions-to-discard-cached-connect.patch) at 2021-01-25 19:08:27 from Fujii Masao <masao.fujii at oss.nttdata.com> (Patch: Yes)
    Attachment (v17-0001-postgres_fdw-function-to-discard-cached-connecti.patch) at 2021-01-25 15:12:39 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v16-0001-postgres_fdw-function-to-discard-cached-connecti.patch) at 2021-01-21 16:17:40 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v15-0001-postgres_fdw-function-to-discard-cached-connecti.patch) at 2021-01-21 03:00:22 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v14-0001-postgres_fdw-function-to-discard-cached-connecti.patch) at 2021-01-20 10:17:01 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v13-0001-postgres_fdw-function-to-discard-cached-connecti.patch) at 2021-01-19 03:09:47 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (0001-doc-Add-note-about-the-server-name-of-postgres_fdw_g.patch) at 2021-01-18 15:57:55 from Fujii Masao <masao.fujii at oss.nttdata.com> (Patch: Yes)
    Attachment (v12-0001-postgres_fdw-function-to-discard-cached-connecti.patch) at 2021-01-18 14:14:30 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (postgres_fdw_get_connections_v2.patch) at 2021-01-18 04:46:40 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (postgres_fdw_get_connections_v1.patch) at 2021-01-18 04:08:07 from Fujii Masao <masao.fujii at oss.nttdata.com> (Patch: Yes)
    Attachment (v11-0001-postgres_fdw-functions-to-show-and-discard-cache.patch) at 2021-01-18 03:33:56 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v10-0001-postgres_fdw-function-to-discard-cached-connecti.patch) at 2021-01-17 07:39:27 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (serverid_v1.patch) at 2021-01-14 10:22:19 from Fujii Masao <masao.fujii at oss.nttdata.com> (Patch: Yes)
    Attachment (v9-0001-postgres_fdw-function-to-discard-cached-connectio.patch) at 2021-01-09 01:12:26 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v8-0001-postgres_fdw-function-to-discard-cached-connectio.patch) at 2021-01-05 07:56:14 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v7-0001-postgres_fdw-function-to-discard-cached-connectio.patch) at 2021-01-02 05:49:17 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v6-0001-postgres_fdw-function-to-discard-cached-connectio.patch) at 2021-01-02 05:23:40 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v5-0001-postgres_fdw-function-to-discard-cached-connectio.patch) at 2021-01-01 10:03:33 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v4-0001-postgres_fdw-function-to-discard-cached-connectio.patch) at 2020-12-30 11:50:23 from Alexey Kondratov <a.kondratov at postgrespro.ru> (Patch: Yes)
    Attachment (v4-0001-postgres_fdw-function-to-discard-cached-connectio.patch) at 2020-12-30 06:10:29 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v3-0004-postgres_fdw-connection-cache-discard-tests-and-documentation.patch) at 2020-12-04 11:15:29 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v2-0001-postgres_fdw-connection-cache-disconnect-function.patch) at 2020-11-27 02:12:50 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v1-0001-postgres_fdw-function-to-discard-cached-connections.patch) at 2020-11-23 06:48:42 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (pgfdw_keep_connections.diff) at 2020-11-17 19:37:28 from Alexey Kondratov <a.kondratov at postgrespro.ru> (Patch: Yes)
    Attachment (v1-0001-Retry-cached-remote-connections-in-case-if-remote.patch) at 2020-07-02 10:59:33 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (testcase) at 2020-06-22 05:55:54 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: No)
History
When Who What
2021-04-02 10:48:23 Fujii Masao (masaofujii) Closed in commitfest 2021-03 with status: Committed
2021-04-01 17:22:44 Fujii Masao (masaofujii) New status: Ready for Committer
2021-04-01 14:54:03 Fujii Masao (masaofujii) Added masaofujii as reviewer
2021-04-01 14:54:00 Fujii Masao (masaofujii) Added masaofujii as committer
2021-02-01 12:45:49 Masahiko Sawada (masahikosawada) Closed in commitfest 2021-01 with status: Moved to next CF
2020-12-01 11:10:36 Anastasia Lubennikova (lubennikovaav) Closed in commitfest 2020-11 with status: Moved to next CF
2020-11-23 06:50:07 Bharath Rupireddy (bharathrupireddy) New status: Needs review
2020-11-19 13:48:08 Alexey Kondratov (ololobus) Added ololobus as reviewer
2020-11-06 15:56:25 Anastasia Lubennikova (lubennikovaav) Posted comment with messageid <160467818521.7362.11186359886835925531.pgcf@coridan.postgresql.org>
2020-11-06 15:56:25 Anastasia Lubennikova (lubennikovaav) New status: Waiting on Author
2020-09-29 06:20:23 Bharath Rupireddy (bharathrupireddy) Closed in commitfest 2020-09 with status: Moved to next CF
2020-09-29 06:20:13 Bharath Rupireddy (bharathrupireddy) New status: Needs review
2020-09-29 05:45:18 Michael Paquier (michael-kun) New status: Waiting on Author
2020-08-10 12:34:20 Bharath Rupireddy (bharathrupireddy) New status: Needs review
2020-07-17 11:50:43 Bharath Rupireddy (bharathrupireddy) New status: Waiting on Author
2020-07-17 11:50:20 Bharath Rupireddy (bharathrupireddy) Changed authors to Bharath Rupireddy (bharathrupireddy)
2020-07-17 11:50:07 Bharath Rupireddy (bharathrupireddy) Attached mail thread CALj2ACVvrp5=AVp2PupEm+nAC8S4buqR3fJMmaCoc7ftT0aD2A@mail.gmail.com
2020-07-17 11:50:07 Bharath Rupireddy (bharathrupireddy) Created patch record
Edit
Comment/Review
Change Status