postgres_fdw connection caching enable/disable or timeout feature

Edit
ID 2650
Title postgres_fdw connection caching enable/disable or timeout feature
CI (CFBot) Not processed
Stats (from CFBot) Unknown
Topic Server Features
Tags
Created 2020-07-17 11:50:07
Last modified 2021-04-02 10:48:23 (4 years ago)
Latest email 2021-04-02 10:47:39 (4 years ago)
Status
2021-03 (2021-03-01 – 2021-03-31): Committed
2021-01 (2021-01-01 – 2021-01-31): Moved to different CF
2020-11 (2020-11-01 – 2020-11-30): Moved to different CF
2020-09 (2020-09-01 – 2020-09-30): Moved to different CF
Target version
Authors Bharath Rupireddy (bharathrupireddy)
Reviewers Fujii Masao (masaofujii), Alexey Kondratov (ololobus)Become reviewer
Committer Fujii Masao (masaofujii)
Links
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